Friday, 18 October 2013


MC7103                                  DATABASE MANAGEMENT SYSTEMS                 L T P C
         3 0 0 3

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

No comments:

Post a Comment