DATABASES 1

Review of relational database systems. Physical issues in DBMSs. Storage media. ER Modeling and Design. EER Modeling and Design. Normalization Forms. Relational Algebra and Review of relational operators. QBE (Query By Example), SQL DML. SQL DDL, Security issues.

Objectives

The course aims to introduce students to all the details of the database management. Upon successful completion of the course students will be able to design, implement and operate a database.

Prerequisites

DATA STRUCTURE

Syllabus

Review of relational database systems. Physical issues in DBMSs. Storage media. ER Modeling and Design. EER Modeling and Design. Normalization Forms. Relational Algebra and Review of relational operators. QBE (Query By Example), SQL DML. SQL DDL, Security issues.