Databases I

The course deals with the design, implementation and usage of relational databases. The design is described using two methodologies: (a) the Entity-Relationship (ER) model and its transformation to a relational model, and (b) the creation of a relational model (database schema) via the process of database normalization. The structured query language (SQL) is presented in detail for (a) implementing a relational model in a Database Management System (DBMS), (b) managing the data in the DBMS (insertions, deletions, updates), and (c) formulating queries for retrieving data and information from the DBMS.

Objectives

not available

Prerequisites

not available

Syllabus

Introduction to Databases, Entity-Relationship model (ER), Relational model, SQL (data definition language queries), Relational algebra, SQL (introduction, QBE, nested queries, aggregate queries, advanced queries, constraints, triggers, views, insert/delete/update queries), Normalization (1NF, 2NF, 3NF, BCNF, 4NF)