1 / 15

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, nzhou@uncc.edu. Why you should take this course. Good job market Easy to learn Have fun Required by BS program. Class Policy.

yates
Download Presentation

Database Design and Implementation

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Database Design and Implementation ITCS3160 Instructor: Jianping Fan Course Webpage: http://www.cs.uncc.edu/~jfan/course5.html TA: Ning Zhou, nzhou@uncc.edu

  2. Why you should take this course • Good job market • Easy to learn • Have fun • Required by BS program

  3. 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

  4. 1. Topics • E-R model • Relational model • SQL • Database implementation • Database Indexing: B-tree • Transaction management • Advanced Database

  5. 2. Grade Format • 5% for show-up in the class • 10% for homeworks • 25% for mid test • 35% for final test • 25% for project

  6. 3. show-up • You have to attend class except…. • If you cannot attend the class, you should let instructor know one day before.

  7. 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

  8. 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

  9. 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

  10. 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

  11. 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.

  12. 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.

  13. 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.

  14. 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

  15. I am a nice professor • If you do your best

More Related