Transcript Database Design and Implementation

Database Design and Implementation
ITCS3160
Instructor: Jianping Fan
Course Webpage:
http://www.cs.uncc.edu/~jfan/course5.html
TA: Ning Zhou, [email protected]
Why you should take this course

Good job market

Easy to learn

Have fun

Required by BS program
Class Policy





Come early (no late than 3:35PM)
Do not talk in the class, but welcome to
ask questions!
Share your ideas in the class
Interaction with instructor
Help on distributing information
1. Topics







E-R model
Relational model
SQL
Database implementation
Database Indexing: B-tree
Transaction management
Advanced Database
2. Grade Format





5% for show-up in the class
10% for homeworks
25% for mid test
35% for final test
25% for project
3. show-up


You have to attend class except….
If you cannot attend the class, you
should let instructor know one day
before.
4. Homework



We will assign 7 homework
Each of you should send your paper
homework (hard copy) to instructor.
You will get benefit from these
homework: 10% for final grade
Homework

Late policy:




Homework turned in up to one week after the
due date - 20% penalty.
No acceptable after one week.
Must be printed out.
More information

http://www.cs.uncc.edu/~jfan/course5.html
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
25% benefit for your final grade
If you get B in your mid test and you
want to get A for final grade, 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
35% benefit
7. Project



We will have one project for this class
In this project, you are asked to build a
small database system.
Details for the project will be introduced
after we introduce SQL.
8. Hands-on Learning


We will organize three times hands-on
learning in computer lab (obviously it
depends the available of computer lab
at that time). We have submitted
reservation for this and wait for answer.
We will focus on Oracle 8i, but you can
use MSN SQL for project
implementation.
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 welcome
I am a nice professor

If you do your best