Introduction: Database concepts, characteristics of database approach, data models, data independence, database users, and database system architecture. 5L
[1]: [1.1 to 1.8, 2.1 to 2.6]
Relational Data Model: Relational model concepts, relational database constraints. 6L
[1]: [3.1 to 3.4] The Relational Algebra and Relational Calculus 6L
[1]: [6.1 to 6.5]
SQL Programming: 8L Data Definition Language, Data Manipulation Language, basics of SQL, query designing in SQL using aggregate functions and nested queries.
[1]: [4.1 to 4.5]
Entity Relationship (ER) Modeling: Entity types, entity set, attribute and key, relationships, relation types, entity relationship, ER modeling, ER diagrams, database design using ER diagrams. 5L
[1]: [7.1 to 7.7]: Enhanced Entity-Relationship (EER) model. 5L
[1]: [8.1 to 8.5]
Database Design: Relational database design by ER and EER-to-Relational Mapping. 3L
[1]: [9.1 to 9.2] Functional dependencies, Normal forms. 8L
[1]: [15.1 to 15.7]
Transaction Processing: 2L Introduction to Transaction Processing Concepts and Theory.
[1]: [21.1 to 21.3]
Recommended Reading Material
Text Books 1. R. Elmasri, S.B. Navathe, Fundamentals of Database Systems, 6th edition, Pearson Education, 2010
Some content on this page was disabled on July 16, 2020 as a result of a DMCA takedown notice from Pao Lopez. You can learn more about the DMCA here:
incarnation 
