2: Database Systems Course Structure: Lectures: 2 /
Labs: 1 Credit Hours: 3 Prerequisites: Data Structures Objectives: The course aims to introduce basic database concepts,
different data models, data storage and retrieval techniques and database
design techniques. The course primarily focuses on relational data model
and DBMS concepts.
Course Outline: Basic database concepts; Entity Relationship modeling,
Relational data model and algebra, Structured Query language; RDBMS;
Database design, functional dependencies and normal forms; Transaction
processing and optimization concepts; concurrency control and recovery
techniques; Database recovery techniques; Database security and
authorization. Small Group Project implementing a database. Lab outline: Structured Query language commands, PL/SQL Commands,
Creating & populating tables, Design of simple database: Conceptual,
logical and physical level, Database normalization process techniques,
Query optimization (Relational Algebra), Indexing concepts, Performance
of concurrency protocols, Partial & full recovery techniques, Concepts of
database securities, Development of a GUI interface (optional). Design
and implementation of a simple MIS system
