Objective of the CourseThis course will allow students to develop background knowledge as well as core expertise in
Database Management Systems. The students will learn Database concept, Data Structure,Data Models, various approaches to Database design, strengths of relational model,
At the end of the course the student will be able to
• Understand Database design and normalisation techniques.
• Use Standard Query Language and its various versions.
• Understand Importance of backup and recovery techniques.
• Develop Database system to handle the real world problem.
Topic Minimum number of hours
An Overview of Database Management 04
An Architecture of the Database System 04
Relational Database Management System 08
Relational Algebra and Relational 08
The SQL Language 12
Backup and Recovery 02
Design and Development of Database 10
Lectures = 60
Practical/tutorials = 60
Total = 120
Detailed Syllabus1. An Overview of the Database Management System (04 Hrs.)
What is database?, Why database?, database system, database management system (DBMS), advantages of DBMS.
2. An Architecture of the Database system (04 Hrs.)
Three levels of architecture, mappings, role of database administrator(DBA), E-R model,three approaches of DBMS- relational, hierarchical and network.
3. Relational Database Management System (RDBMS) (08 Hrs.)Introduction, RDBMS terminology, relational model, base tables, keys.
4. Normalization (08 Hrs.)Normal forms, Boyce-Codd Normal form, higher normal forms.
5. Relational Algebra and Relational Calculus (08 Hrs.)Relational operators, tuple calculus, well formed formulae.
6. The SQL Language (12 Hrs.)
Introduction , Characteristics of SQL, data definition, data manipulation, SQL commands,SQL operators, Queries, aggregate functions.
7. Backup and Recovery (02 Hrs.)Transaction recovery, system recovery, SQL support
8. Security (02 Hrs.)General considerations, controls, audit trail, data encryption, SQL support.
9. Integrity (02 Hrs.)General considerations ,integrity rules, SQL support.
10. Design and Development of Database Applications (10 Hrs.)Database applications using some standard RDBMS.
1. Silberschatz A, Korth H.F and Sudarshan S, “Database System Concepts”, Fifth
Edition, Tata McGraw-Hill, 2006.
2. C.J.Date, “ An introduction to Database Systems”, Pearson Education, 2007.
3. R. Elmasri, S. B Navathe, “ Fundamentals of Database System”, Pearson Education,
4. Desai C. Bipin, “An Introduction to Database Systems”, Galgotia Publication, 2009.
1. Leon A and Leon M, “Fundamentals of DBMS”, Vijay Nicole & Tata McGraw-Hill,
2. Gill P.S, “DBMS”, I.K. International, 2008.
3. Singh S.K, “Database Systems: Concepts, Design & Applications”, Pearson
4. Leon A and Leon M, “Database Management Systems”, Vikas Publishing House.