Purpose and use of Database systems, Data Models, Data Schemas, Database Architecture. Entity-Relationship Model, Constraints, Generalizations. Relational Data Model. Relational Algebra and Relational Calculus. SQL. QBE. Functional Dependencies and Normalization for Relational Databases. Database Design Methodology. File Structure, Physical Organization, Visualization of Structures in Files. Indexing and Hashing. Data flow management. Study of existing systems.
As part of the course, a workshop is held that aims at understanding and practical application of the design and implementation processes of relational databases using MySQL. The workshop is divided into 4 sections: (1) Requirements Analysis and DB Design (ER, Relational Diagram), (2) DB Creation (create, insert), (3) Querying the DB (select, update, delete) and (4 ) Programming in SDBD (triggers, stored procedures).
The teaching of the laboratory is blended and takes place through lectures followed by laboratory exercises. The workshop concludes by designing a full-scale DB, building tables and importing data through appropriate SQL commands, implementing SQL queries, and building a Java application to communicate with the DB, view and change its data.