Database Management System (DBMS) (2620003)


Theory Hours : 4 Paractical Hours : 0 Tutorial Hours : 0 Credits  :  4
Theory Marks 70 Practical Marks 0 Midsem Marks 30 Continuous Evaluation Marks 50
Total Marks : 150



Syllabus

[PDF]


Learning Objectives:
Introduces the student to the fundamental concepts necessary for designing, using and implementing database systems and applications.

Prerequisites :
Basic knowledge of working with computers.

Contents:
indicates # of lectures

1. Introduction to Database System
Basic Concepts : data, database, database systems, database management systems, instance, schema, Database Applications, Purpose and Advantages of Database Management System (over file systems), View of Data (Data Abstraction, Data Models), Database Langu

2. Entity Relationship Diagram
Design Phases, Design Alternatives (Major Pitfalls), Entity Relational Model (Entity Sets, Relationship Sets, Attributes), Constraints (Mapping Cardinalities, Keys, Participation Constraints), Entity Relationship Diagram, Weak Entity Set, Extended E-R Fea

3. Database Design
Features of Good Relational Design, Atomic Domain and First Normal Form, Decomposition Using Functional Dependency (Key and Functional Dependency, BCNF, 2NF, 3NF), Functional Decomposition Theory (Closure Set of Functional Dependency with Armstrong Rules,

4. Relational Model
Structure of Relational Databases (Basic Structure, Database Schema, Types of Keys), Fundamental Relational Algebra Operations (Select, Project, Union, Set Difference, Cartesian Product and Rename Operator), Additional Relational Algebra Operators (Set In

5. Transaction Concepts
Transaction Concept (Transaction State, Basic Definitions, ACID Property), Implementation of Atomicity and Durability (Shadow Paging Concept), Concurrent Execution (Reasons of Concurrent Execution, Serial and Concurrent Schedule), Serializability (Conflic

Chapter-wise coverage from the Text Books:
• Unit : 1 Chapters : 1.1 to 1.5, 16.1, 1.6.2, 1.6.3, 1.7.1, 1.7.2, 1.8, 1.11 No. of Pages : 26 • Unit : Chapters : 2 6.1 to 6.4, 6.6, 6.7 No. of Pages : 34 • Unit : Chapters : 3 7.1 to 7.3, 7.4 (except 7.4.2), 7.6 No. of Pages : 36 • Unit : Chapters : 4

Guidelines for CEC:
• ERD and Normalization: It is recommended to give atleast one case study, which requires students to analyze problem, draw ERD, convert ERD into tables and normalize the tables. • Relational Algebra: For a given relational schema students will be asked t

Accomplishments of the student after completing the course:
• Effective transformation of the real-world data into the relational data model of the database system and data retrieval. • Clear understanding for the need of a database. • Ability to store information without unnecessary redundancy. • Clear understand




Books

Database System Concepts    
Silberschatz, Korth, Sudarshan - McGraw Hill Publication
An Introduction to Database Systems    
C J Date, A Kannan, S Swaminathan - Pearson Education (2006)
Database Systems : Concepts, Design and Applications    
S K Singh - Pearson Education
Fundamentals of Database Systems    
Elmsari, Navathe - Pearson Education (2008)
Database Systems : Design, Implementation and Management    
Peter Rob, Carlos Coronel - Cengage Learning (2007)




Exam Papers





GTU Results