CT1313 Lectures

CT1313
This course aims at giving the students a foundation of the fundamental concepts of database. This should allow students to design and implement real life databases, in addition to evaluate existing ones. Students will be able to use query of different types of complexity.

Study Materials:
 

• Book: Database Systems Concepts, Silberschatz, Korth, Sudarshan 5th edition  Mc Graw Hill
• Essential References : Fundamentals of Database Systems, ElMasri, Navathe   5th  Edition Addison Wesley
• Electronic materials:  lecture slides, handouts, and your lecture notes

 

 

week	Basic and support material to be covered
(1)	Database overview
(2)	Data Modelling Using the Entity-Relationship (ER) Model
(3)	Data Modelling Using the Entity-Relationship (ER) Model
(4)	The Relational Data Model
(5)	The Relational Data Model
(6)	Structured Query Language
(7)	Review
(8) First examination	Functional Dependencies
(9)	Spring holiday
(10)	Normalization
(11)	Normalization
(12)	File Organization
(13)	Indexing
(14) Second examination	Indexing Lab Sql
(15)	Projects discussion
(16) Final Examination	Projects discussion

 

Total from 60 file was uploaded
B+ tree example was uploaded