Thursday, 15 September 2016

Syllabus A7-R4 Introduction to Database Management System (NIELIT A Level)

Objective of the Course

This 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,
Normalization.

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
System
An Architecture of the Database System                04
Relational Database Management System              08
Normalization 08
Relational Algebra and Relational                          08
 Calculus
The SQL Language                         12
Backup and Recovery                         02
Security                                         02
Integrity                                         02
Design and Development of Database                10
Applications
                                                            Lectures = 60
                            Practical/tutorials = 60
                                Total = 120

Detailed Syllabus

1. 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.

RECOMMENDED BOOKS
MAIN READING

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,
2007.
4. Desai C. Bipin, “An Introduction to Database Systems”, Galgotia Publication, 2009.
SUPPLEMENTARY READING
1. Leon A and Leon M, “Fundamentals of DBMS”, Vijay Nicole & Tata McGraw-Hill,
2007.
2. Gill P.S, “DBMS”, I.K. International, 2008.
3. Singh S.K, “Database Systems: Concepts, Design & Applications”, Pearson
Education, 2008.

4. Leon A and Leon M, “Database Management Systems”, Vikas Publishing House.