50 likes | 204 Views
Palestine University First Quarter -- 2007. Course Outline. Palestine University First Quarter -- 2007. Course Name : Advanced Database Systems Instructor : Dr. Khamis Awwad E-mail address: omar@psut.edu.jo Time: 2-5 PM Sunday (during Ramadn) Tex Book:
E N D
Palestine UniversityFirst Quarter -- 2007 Course Outline
Palestine UniversityFirst Quarter -- 2007 Course Name : Advanced Database Systems Instructor: Dr. Khamis Awwad E-mail address: omar@psut.edu.jo Time: 2-5 PM Sunday (during Ramadn) Tex Book: Fundamentals of Database Systems, 4th edition, Elmasri et. al, Addison-Wesley, 2004
Other Reading Materials: 1. AnIntroduction to Database Systems. 8th ed. Date, C. Addison-Wesley 2004. 2. Database System Concepts. 4th ed, Silberschatz et. Al, McGraw-Hill, 2002. 3. Database Systems: The Complete, Garcia-Molina et. Al, Prentice Hall, 2002 4. Other learning resources (e.g. Web sites, video tapes, CD's, ..) 5. Extra resources can be found at the ACM's website www.acm.org Grading: The total grades of this course are assigned as follows: 1. Midterm exam 30% 2. Final Exam 50% 3. Class Activities 20%
Reading and Assignments From the Text Book 1. Databases and Database Users -- Ch 1 Q 1.1, 1.2, 1.3, 1.4 E 1.7, 1.9 2. Database System Concepts and Architecture ---Ch 2 Q 2.1,2.4,2.5,2.9 E 2.11 3. Database Modeling Using the ER Model -- Ch 3 Q 3.3, 3.6, 3.10, 3.12 E 3.16, 3.21,3.22, 3.23, 4. Enhanced ER and UML Modeling -- Ch 4 Q 4.2, 4.8,4.10 E 4.17,4.19 5. ER and EER to Relational Mapping – Ch 7 Q 7.1, 7.2 E 7.3, 7.4 6. The Relational Data Model and DB Constraints – Ch5 Q 5.1, 5.5, 5.7 5.8 E 5.10, 5.13 7. The Relational Algebra and Relational Calculus – Ch6 Q 6.2, 6.3, 6.5 E 6.16, 6.18
8. SQL -- Ch8, Ch 9 Q8.1,8.3,8.5,9.1,9.2,9.4 E 8.16 8.17, 9.7,9.9 9. Functional Dependencies Normalization For Relational Databases – Ch 10 Q 10. 2, 10.6, 10.8, 10.10 E 10.17, 10.19, 10.24, 10.30 10. Intro to Transaction Processing , Concepts & Theory -- Ch 17 Q 17.1, 17.2, 17.6, 17.7 E 17.14, 17.22, 17.23 11. Concurrency Control Techniques – Ch 18 Q 18.1, 18.2, 18.7 E 18.21, 18.25 12. Concepts for Object Databases – Ch 20 Q20.1,20.2,20.5,20.8 E 20.13,20.15 13. Data Mining Concepts—Ch 27 Q 27.1,27.3,27.4 E 27.1427.19, 27.20 GOOD LUCK !