Database Management System detailed syllabus for Industrial Engineering & Management (IEM) for 2021 regulation curriculum has been taken from the Anna Universities official website and presented for the IEM students. For course code, course name, number of credits for a course and other scheme related information, do visit full semester subjects post given below.
For Industrial Engineering & Management 5th Sem scheme and its subjects, do visit IEM 5th Sem 2021 regulation scheme. For Professional Elective-IV scheme and its subjects refer to IEM Professional Elective-IV syllabus scheme. The detailed syllabus of database management system is as follows.
Course Objectives:
Download the iStudy App for all syllabus and other updates.
Unit I
RELATIONAL MODEL 9
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 9
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
Download the iStudy App for all syllabus and other updates.
Unit IV
MULTIMEDIA DATABASES 9
Multidimensional Data Structures – Image Databases – Text / Document Databases – Video Databases – Audio Databases – Multimedia Database Design.
Unit V
CURRENT ISSUES ACTIVE 9
Databases – Deductive Databases – Data Warehousing – Data Mining – Database Tuning -Database Security.
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.
Reference Books:
Download the iStudy App for all syllabus and other updates.
For detailed syllabus of all the other subjects of Industrial Engineering & Management 5th Sem, visit IEM 5th Sem subject syllabuses for 2021 regulation.
For all Industrial Engineering & Management results, visit Anna University IEM all semester results direct link.