Database Management System(DBMS)

Database Management Systems EG 2107 CT

         Year: II

Semester: III                                                                                                 Total: 7 hours/week 

Lecture: 3 hours/week

Tutorial: 1 hours/week

Practical: 3 hours/week Course Description: 

The course covers the fundamental concepts of database and database management system including database design using entity relationship diagram, relational databases, structured query language, normalization, transaction processing, and concurrency control and recovery techniques.

Course Objective: 

The main objective of this course is to: 

•       Explain the concepts of database and database management system.

•       Provide knowledge of database design using entity relationship diagram.

•       Perform on SQL statements, normalization, transaction processing, and database recovery.

Course Contents:

Units	Topics	Contents	Hours	Methods/ Media	Marks
1	Database and Database System	•       Introduction; •       Characteristics of the Database Approach; •       Advantages of Using the DBMS Approach;  •       Data Models,  •       Schemas, and Instances; •       Three-Schema Architecture and Data Independence; •       Centralized and Client/Server Architectures for DBMSs; •       Classification of Database Management Systems	(6 )
2	Data Modeling Using the EntityRelational Model	•       Introduction to Entity-Relationship Model;  •       Entity Types,  •       Entity Sets,  •       Attributes, and Keys;  •       Relationship Types,  •       Relationship Sets,  •       Roles, and Structural Constraints;  •       Weak Entity Types;  •       ER Diagrams	(9 )

                                                                                                                  82

Units	Topics	Contents	Hours	Methods/ Media	Marks
3	The Relational Database and SQL	•                Relational Model Concepts;  •                Relational Model Constraints and Relational Database Schemas;   Introduction to Relational Algebra;   SQL:  •                Data Definition and Data Types,  •                Specifying Constraints,  •                Basic Retrieval Queries, and INSERT,  •                DELETE and UPDATE Statements	(10 )
4	Relational Database Design	•       Relational Database Design Using ER- to- •       Relational Mapping;  •       Functional Dependencies;  •       First, Second and Third Normal Form;  •       Properties of Relational Decomposition	(7 )
5	Transaction Processing, Concurrency Control, and Recovery	•       Introduction to Transaction Processing;  •       Transaction and System Concepts;  •       Desirable Properties of Transactions;  •       Serializable Schedule;  •       Two-Phase Locking and Timestamp Ordering Techniques;  •       Introduction to Database Recovery	(13 )
	Practical:
	•       Write SQL query for CREATE, INSERT, DELETE, and UPDATE operations. •       Write SQL query for SELECT operation. •       Write SQL query using aggregate functions. •       Apply SQL for specifying constraints.		45hrs

Recommended Books:

•       Ramez Elmasri and Shamkant B. Navathe (2010), Fundamentals of Database Systems, 6^th Edition, Pearson Addison Wesley

•       Silberschatz, H.F. Korth, and S. Sudarshan (2010), Database System Concepts, 6^th Edition, McGraw Hill

•       Raghu Ramakrishnan, and Johannes Gehrke (2007), Database Management Systems, 3^rd Edition ,McGraw-Hill

•       Jaffrey D. Ullman, Jennifer Widom; A First Course in Database Systems; Third Edition; Pearson Education Limited

          

                                                                                                                  83