Database Design and Implementation

ITCS6160 & ITCS 8160Instructor: Jianping Fan

Webpage: http://www.cs.uncc.edu/~jfan/course6.html

Why you should take this course

Good job market

Easy to learn

Have fun

Required by MS program

Class Policy Come early (no late than 6:35PM), do

not leave classroom within my lecture! Do not bring food into classroom,

especially do not eat in the class (F grade may be given)

Do not talk in the class, but welcome to ask questions!

Share your ideas in the class & Interaction with instructor

Help on distributing information

Text Book

Raghu Ramakrishnan, Johannes Gehrke, ``Database Management Systems”, Mc-Gram Hill, third edition

Why this book?

1. Topics

E-R model Relational model SQL Database implementation Database indexing: B-tree & Others Transaction management Advanced database

2. Grade Format

5% for show-up in the class 15% for home-works (7 totally) 30% for mid test 40% for final test 10%-15% for project

3. show-up & in-class rules

You have to attend class except….

If you cannot attend the class, you should let instructor know one day before by email.

Hands-on learning classesIf you miss 3 or more classes without good reasons, you are not allowed to take mid-term and final tests!

3. show-up & in-class rules

Do not leave for restroom or answering phone-call within my lecture; If you have emergency issue, rise your hand.

Do not bring foods into classroom, especially eat in my lecture time.

others

4. Homework

We will assign 7 homework You will get benefit from these

homework 15% Mid-test or final test questions will

follow the same format for homework

5. Mid-test

Mid test will include E-R model, relational model, relational algebra, SQL

If you get A in mid test, you will get 30% benefit for your final grade

If you get B in your mid test and you want to get A finally, you should get A from both final test and project

6. Final Test

Final test will include the topics which are not included in the mid test but be introduced in the class.

If you get A in final test, you can get 40% benefit

7. Project

You will have two choices of the project for this class

(a) Presenting one research topic in this class, see course web page for the assigned papers!

(required for PhD students, optional for MS)

(b) Building an online registration system for UNCC!

8. Hands-on Learning

We will organize 2 times hands-on learning in computer lab.

We will focus on Oracle 8i TA will do this We will find our computer lab soon

9. The way to A

Do your best for homework, mid and final test and also project

You are welcome to send your feedback to the instructor for improving the learning environment for this class.

You can also make appointment to visit the instructor or TA.

10. Suggestions from Instructor

Do your best in the class Show your problems to the

instructor or TA when you cannot make it

Show the evidence to us if you think you are right.

Open discussion is needed

I am a nice professor

If you do your best & follow class policy

Do your best & have fun!

You can withdraw if you cannot accept the class policy!