1. Introduction to Databases and Transactions :
- What is database system, purpose of database system, view of data, relational databases, architecture, transaction management.
2. Data Models :
- The importance of data models, Basic building blocks, Business rules, The growth of data models, Degrees of data abstraction.
3. Database Design ,ER-Diagram and Unified Modeling Language :
- Database design and ER Model:overview, ER-Model, Constraints, ER-Diagrams, ERD Issues, weak entity sets, Codd’s rules, Relational Schemas, Introduction to UML.
- RDBMS: Logical view of data, keys, honor rules.
- Database design and ER Model : Overview, ER-Model, Constraints, ER-Diagrams, ERD Issues, weak entity sets, Codd’s rules, Relational Schemas, Introduction to UML.
- RDBM design: Features of good design, atomic domain and Normalization (1NF, 2NF, 3NF, BCNF).
4. Relational Algebra and Calculus :
- Relational algebra: Introduction, Selection and calculation, set operations, Joins, Division, syntax, Operators, group and ungroup, relational comparison.
- Calculus : Tuple relational calculus, Domain relational Calculus, calculus vs algebra, computational capabilities.
5. Constraints, Views and SQL :
- What is constraints, types of constrains, Integrity constraints.
- Views: Introduction to views, data independence, security, updates on views, and compare between tables and views.
- SQL : Data Definition, Aggregate function, Null Values, nested sub queries, Joined relations. Triggers.
6. Transaction management and Concurrency control :
- Transaction management: ACID property, serializability and concurrency control, Lock based concurrency control (2PL, Deadlocks),Time symbol methods, positive methods, database recovery management.