IS414: Database Design (Spring 2016)
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
Eng. Dina Abbas
Text Book
Fundamentals of Database Systems (6th Edition)
Ramez Elmasri (Author), Shamkant Navathe (Author)
Lectures
| Wednesdays 8:00 - 9:30 -- Lecture hall 620 |
| Thursdays 9:45 - 11:00 -- Lecture hall 620 |
Grading Scheme
| 60% Final exam |
| 10% Mid-Term exam |
| 12% Assignments (Sheets) |
| 7% Programming Assignemnt |
| 6% 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 | MidTerms |
| 9 | NOSQL Database Introduction PDF |
| 10 | Easter Vacation |
| 11 | Graph Databases PDF |
| 12 | Neo4j Cypher Language PDF |
| Neo4j Cypher Language PDF | |
| 13 | Neo4j Cypher Language PDF |
Year Grades
16 May 2015 (Year Grades without Sheet 3 and Quiz 2)
Related materials