Database Management System

What you’ll study

Introduction: a general overview and the purpose of a DBMS, advantages, applications, common features and the overall structure of the database. Data modeling — the relational model: structure, key constraints, referential integrity and general constraints, relational algebra (fundamental, additional and extended operations), aggregate functions, outer joins and database modification. The ER model: entity and relationship sets, constraints — key, mapping cardinality and participation, strong and weak entity sets, E-R diagrams, class hierarchies, aggregation, conceptual database design. Relational database design: features of good design, functional dependency theory — closure of a set of FDs and of attribute sets, canonical cover, atomic domains and first normal form. Database application development with SQL: data-definition and data-manipulation languages, integrity constraints, basic, nested and complex queries, modification of the database, views and cursors, stored procedures, assertions and triggers.