Database Management Systems

Objective:

The course is designed with an objective to
 Construct simple and moderately advanced database queries using Structured Query
Language (SQL)
 Apply logical database design principles, including E-R diagrams and database
normalization

Learning Outcome:

On completion of the course, students will be able to
 Describe the principles of the relational database Access
 Define and manipulate data using SQL
 Construct and normalize conceptual data models.

Unit I: 10L

Introduction to Database Management Systems: Characteristics of database approach, data
models, DBMS architecture and data independence.

Unit II: 15L

Entity Relationship and Enhanced ER Modeling: Entity types, relationships, SQL-99: Schema
Definition, constraints, and object modeling.

Unit III: 15L

Relational Data Model: Basic concepts, relational constraints, relational algebra, SQL queries.

Unit IV: 20L

Database design: ER and EER to relational mapping, functional dependencies, normal forms up
to third normal form.

Books Recommended:

1. R. Elmasri, S.B. Navathe, Fundamentals of Database Systems 6th Edition, Pearson
Education, 2010.
2. R. Ramakrishanan, J. Gehrke, Database Management Systems 3rd Edition, McGrawHill, 2002.
3. A. Silberschatz, H.F. Korth, S. Sudarshan, Database System Concepts 6th Edition,
McGraw Hill, 2010.
4. R. Elmasri, S.B. Navathe Database Systems Models, Languages, Design and application
Programming, 6th Edition, Pearson Education, 2013.

Computer Lab Based on Database Management Systems:

 Describe the principles of the relational database Access
 Define and manipulate data using SQL
 Construct and normalize conceptual data models.