Database Design (IS414-2017)
Semester:
Spring
Course Description
This course aims to provide the students with knowledge and skills needed to design relational database schemas ( conceptual and logical design). Design issues related to new database models are also considered. Relational database tuning is taken into consideration after the design concepts are illustrated through the course.
Teaching Assistants
Eng. Ali Zidan , Eng. Ibrahim Gomaa and Eng. Mona Khamis
Text Book
Fundamentals of Database Systems (6th Edition)
Ramez Elmasri (Author), Shamkant Navathe (Author)
Lectures
| Wednesdays 8:00 - 9:30 -- Lecture hall 260 |
| Thursdays 8:00 - 9:30 -- Lecture hall 261 |
Grading Scheme (Preliminary- Not Final)
| 60% Final exam |
| 10% Mid-Term exam |
| 8% Assignments (Sheets) |
| 14% Programming Assignemnt + Graph DB Project |
| 3% Workshop in labs |
| 5% Quizzes |
Schedule
| Week | DBD Lecture |
| 1 | Course Overview & Motivation (PDF) |
| DB Design Process + ERD Notations + Lessons Learned in ERD (PDF) | |
| 2 | Conceptual Normalization (Functional Dependencies) (PDF) |
| Conversion (Conceptual to Logical Schema)(PDF) | |
| 3 | Functional Dependencies Inference rules (PDF) |
| Functional Dependencies (Closure, cover, equivalence) (PDF) | |
| 4 | Functional Dependencies (Non Redundant FDs, Extraneous Attributes) (PDF) |
| Functional Dependencies (Minimal Cover) (PDF) | |
| 5 | Normalization using functional dependencies (1st, 2nd, 3rd, BCNF) (PDF) |
| views (virtual and materialized views) (PDF) | |
| 6 | Relational Database Tuning (PDF) |
| Relational Database Tuning (PDF) | |
| 7 | Relational Database Tuning (PDF) |
| Relational Database Tuning (PDF) | |
| 8 | Relational Database Tuning (PDF) |
| 9 | MidTerms |
| 10 | Graph Databases (PDF) |
| 11 | Neo4j Cypher Language (PDF) |
| 12 | Neo4j Cypher Language (PDF) |
| Neo4j Cypher Language (PDF) | |
| 13 | Neo4j Cypher Language (PDF) |
Related materials