Course Structure
Course id: IS 335 – Database Management Systems
Credit hours: 4 (3H. Lecture + 1H. Tutorial)
Instructor: Dr. Mourad YKHLEF
Objectives: The intention of this course is to introduce the essential concepts of Database Management Systems.New advanced trends related to the field will be introduced to give the student a good knowledge about the current and future directions of the field.
Course’s content:
|
1. Preliminaries and Overview |
1 week |
|
2. Advanced Concepts in ER diagram |
1 week |
|
3. Advanced SQL and Recursion |
1 week |
|
4. Data storage |
1 week |
|
5. Indexing and Hashing |
2 weeks |
|
6. Query processing and Optimization |
2 week |
|
7. Transactions and Concurrency |
2 week |
|
8. Transactions and Recovery |
1 week |
|
9. Database Security |
1 week |
|
10. Semi-structured data and XML |
1 week |
Recommended books:
- Ramez Elmasri, Shamkant B. Navathe, Fundamentals of Database Systems, 5th edition 2007, Addison Wesley, ISBN-10: 0321369572
- Hector Garcia-Molina, Jeffrey D. Ullman, Jennifer D. Widom, Database Systems: The Complete Book, 2001, Prentice Hall, ISBN-10: 0130319953
- Abraham Silberschatz, Henry F. Korth, S. Sudarshan, Database Systems Concepts, 5th edition, 2005, McGraw-Hill, ISBN-10: 0072958863
Evaluation:
15% for first mid term exam
20% for second mid term exam
10% for homework, quiz and presence
15% for project
40% for the final exam