Introduction; An example; Characteristics of Database approach; Actors on the screen; Workers behind thescene; Advantages of using DBMS approach; A brief history of database applications; when not to use a DBMS.Data models, schemas and instances; Three-schema architecture and data independence; Database languages andinterfaces; The database system environment; Centralized and client-server architectures; Classification ofDatabase Management systems.
Using High-Level Conceptual Data Models for Database Design; An Example Database Application; EntityTypes, Entity Sets, Attributes and Keys; Relationship types, Relationship Sets, Roles and Structural Constraints;Weak Entity Types; Refining the ER Design; ER Diagrams, Naming Conventions and Design Issues;Relationship types of degree higher than two.
Relational Model Concepts; Relational Model Constraints and Relational Database Schemas; Update Operations,Transactions and dealing with constraint violations; Unary Relational Operations: SELECT and PROJECT;Relational Algebra Operations from Set Theory; Binary Relational Operations : JOIN and DIVISION;Additional Relational Operations; Examples of Queries in Relational Algebra; Relational Database Design UsingER- to-Relational Mapping.
SQL Data Definition and Data Types; Specifying basic constraints in SQL; Schema change statements in SQL;Basic queries in SQL; More complex SQL Queries. Insert, Delete and Update statements in SQL; Specifyingconstraints as Assertion and Trigger; Views (Virtual Tables) in SQL; Additional features of SQL; Databaseprogramming issues and techniques; Embedded SQL, Dynamic SQL; Database stored procedures and SQL /PSM.
Informal Design Guidelines for Relation Schemas; Functional Dependencies; Normal Forms Based on PrimaryKeys; General Definitions of Second and Third Normal Forms; Boyce-Codd Normal Form
The ACID Properties; Transactions and Schedules; Concurrent Execution of Transactions; Lock- BasedConcurrency Control; Performance of locking; Transaction support in SQL; Introduction to crash recovery.