MC7103 syllabus - DATABASE MANAGEMENT SYSTEMS

MC7103                                  DATABASE MANAGEMENT SYSTEMS                 L T P C

         3 0 0 3

 COURSE OBJECTIVES

1. To understand the fundamentals of data models and conceptualize and depict a database system using ER diagram

2. To make a study of SQL and relational database design.

3. To know about data storage techniques an query processing.

4. To impart knowledge in transaction processing, concurrency control techniques and recovery

procedures.

UNIT I INTRODUCTION                                                                                           9

File systems versus Database systems – Data Models – DBMS Architecture – Data Independence –

Data Modeling using Entity – Relationship Model – Enhanced E-R Modeling.

UNIT II RELATIONAL MODEL AND QUERY EVALUATION                                 9

Relational Model Concepts – Relational Algebra – SQL – Basic Queries – Complex SQL Queries –

Views – Constraints – Relational Calculus – Tuple Relational Calculus – Domain Relational Calculus –

overview of commercial RDBMSs – Database Design – Functional Dependencies – Normal Forms –

1NF – 2NF-3NF-BCNF – 4NF-5NF - Algorithms for Executing Query Operations –– Cost Estimation

UNIT III TRANSACTION PROCESSING                                                                 9

Transaction Processing – Properties of Transactions - Serializability – Transaction support in SQL -

Locking Techniques – Time Stamp ordering – Validation Techniques – Granularity of Data Items –

Recovery concepts – Shadow paging – Log Based Recovery – Database Security Issues – Access

control – Statistical Database Security.

UNIT IV FILES AND INDEXING                                                                               9

File operations – Hashing Techniques – Indexing – Single level and Multi-level Indexes – B+ tree –

Static Hashing - Indexes on Multiple Keys.

UNIT V SPECIAL PURPOSE DATABASES                                                            9

OODBMS- - Object-Based Databases - OO Data Model - OO Languages – Persistence – Object

Relational Databases - XML – Structure of XML - Temporal Databases – Mobile Databases – Spatial

Databases – Case Study for Design and Manage the Database for any Project

TOTAL : 45 PERIODS

COURSE OUTCOMES:

1. Understand the basic concepts of the database and data models.

2. design a database using ER diagrams and map ER into Relations and normalize the

relations

3. Acquire the knowledge of query evaluation to monitor the performance of the DBMS.

4. Develop a simple database applications using normalization.

5. Acquire the knowledge about different special purpose databases and to critique how

they differ from traditional database systems.

REFERENCES:

1. Abraham Silberschatz, Henry F.Korth and S.Sundarshan “Database System Concepts”, Sixth

Edition, McGraw Hill, 2010.

2. C.J. Date, “An Introduction to Database Systems”, Eight Edition, Pearson Education Delhi,

2003.

3. Ramez Elamassri and Shankant B-Navathe, “Fundamentals of Database Systems”, Sixth

Edition, Pearson Education Delhi, 2010.

4. Raghu Ramakrishnan, Johannes Gehrke ,’ Database management systems” McGraw Hill,

2003.

5. Peter Rob, Carlos Coronel, “Database System Concepts”, Cengage Learning, 2008.

6. Frank. P. Coyle, “XML, Web Services And The Data Revolution”, Pearson Education, 2012.

7. Lee Chao, “Database Development and Management”, Auerbach Publications, 2010.

8. Peter Rob, Carlos coronel , “Data base system concepts” , Ceange Learning 2008