CIE365 Database Management System Syllabus:
CIE365 Database Management System Syllabus – Anna University Regulation 2021
COURSE OBJECTIVES:
• To understand the fundamentals of data models and conceptualize and depict a database system using ER diagram.
• To make a study of SQL and relational database design.
• To know about data storage techniques and query processing.
• To impart knowledge in transaction processing, concurrency control techniques and recovery procedures.
UNIT I RELATIONAL MODEL
Data Model – Types of Data Models: – Entity Relationship Model – Relational Data Model – Mapping Entity Relationship Model to Relational Model – Structured Query Language – Database Normalization – Transaction Management.
UNIT II PARALLEL AND DISTRIBUTED DATABASES
Centralized and Client-Server Architectures – Parallel Systems – Distributed Systems – Parallel Databases – I/O Parallelism – Inter- and Intra-Query Parallelism – Inter- and IntraOperation Parallelism – Distributed Database Concepts: – Distributed Data Storage – Distributed Transactions – Commit Protocols – Concurrency Control – Distributed Query Processing.
UNIT III XML DATABASES XML
Databases: XML Data Model – DTD – XML Schema – XML Querying – Web Databases – Open Database Connectivity.
UNIT IV MULTIMEDIA DATABASES
Multidimensional Data Structures – Image Databases – Text / Document Databases – Video Databases – Audio Databases – Multimedia Database Design.
UNIT V CURRENT ISSUES ACTIVE
Databases – Deductive Databases – Data Warehousing – Data Mining – Database Tuning – Database Security.
TOTAL:45 PERIODS
COURSE OUTCOMES:
• Upon Completion of the course, the students will be able to Understand the basic concepts of the database and data models.
• Design a database using ER diagrams and map ER into Relations and normalize the relations
• Acquire the knowledge of query evaluation to monitor the performance of the DBMS.
• Develop a simple database applications using normalization.
• Acquire the knowledge about different special purpose databases and to critique how they differ from traditional database systems.
REFERENCES:
1. R. Elmasri, S.B. Navathe, ―Fundamentals of Database Systems‖, Addison-Wesley, 2011.
2. Thomas Cannolly and Carolyn Begg, ―Database Systems, A Practical Approach to Design, Implementation and Management‖, Third Edition, Pearson Education, 2007.
3. Henry F Korth, Abraham Silberschatz, S. Sudharshan, ―Database System Concepts‖, Fifth Edition, McGraw Hill, 2006.
4. C.J.Date, A.Kannan and S.Swamynathan, ‖An Introduction to Database Systems‖, Eighth Edition, Pearson Education, 2006.
5. V.S.Subramanian, ―Principles of Multimedia Database Systems‖, Harcourt India Pvt. Ltd., 2001.