Database Deign

Text Book

Fundamentals of Database Systems, 6th Edition, by Elmasri/Navathe, published by Addison-Wesley, 2010.
[download][Book]

WeekDateCovered TopicsComments
110/10Chapter 1: Course organization
217/10 and 24/10Chapter 1& 2 : Introduction to database systems- Databases and Database Users- database system concepts and architecture[Chapter1][ch1] <br>[Chapter2][ch02]
331/10Chapter 7 : Data Modeling Using the Entity-Relationship Model[Chapter 7][ch07]
414/11 and 21/11Chapter 8 : Enhanced Entity-RelationshipFirst Exam 14/11/2016<br> [Chapter 8][ch08]
528/11 and 14/12Chapter 3 : The relational data model.[Chapter 3][ch03]Project – Phase 1 due on 9/11
621/12 and 23/12Chapter 9 : Conceptual to Relational Mapping [Chapter 9][ch09]Second Exam on 2/12
728/12 and 30/12Chapter 15 : Functional dependencies, and normalization.Project – Phase 2 due on 28/12
8-/- and -/-Mid-term ExamMid-term: Chapter 1,2,3,7,8,9,13
9Chapter 6 : Relational algebra and Relational calculus
107/3Chapter 4&5 : The SQL database language 1.[Chapter 4&5][ch04]
1114/3Chapter 4&5 : The SQL database language 2.[company sql][company] [SQL Joins][SQLJoins] [TRRIGERS][TRRIGERS]
1221/3Chapter 13 : Database programming techniques.Lab Exam on 16/3 Project <br> Phase 3 due on
1328/3 and 4/4Chapter 17 : Disk Storage, Basic File Structures and Hashing Chapter 18 : Indexing Structures for FilesThird Exam on 30/3
1411/4 and 18/4Chapter 18 : Indexing Structures for Files
15Project presentationProject – Phase 4 (final) due on <br>Presentation Evaluation <br>Presentation Schedule
16TBA

Leave a Reply

Your email address will not be published. Required fields are marked *

bookmark
required required
web