MI4402 Data Management Syllabus:
MI4402 Data Management Syllabus – Anna University PG Syllabus Regulation 2021
COURSE OBJECTIVES:
To understand the fundamentals of database systems
To learn widely used Relational Database Management Systems (RDBMS) and its related concepts
To understand emerging database technologies like NoSQL
UNIT I DATABASE MANAGEMENT SYSTEMS:
Data, Database, Database Management Systems, Types of Database Management Systems – Relational, Hierarchical, Network, and Object oriented database management systems, Entity Relationship Model (E-R Model)
UNIT II RELATIONAL DATABASE MANAGEMENT SYSTEMS (RDBMS):
Relational Model -Relations, Tupples, domains and type of keys, Boyce–Codd Normal Form, normalization of databases– The first and second normal form of databases.
UNIT III INTRODUCTION TO SQL:
Data Definition Language (DDL), Data Manipulation Language (DML), Data Control Language, Cartesian Product and Joins, Use of Union, Intersection, Minus, SQL operators and functions, SQL select statement and type of queries, In, Exists, Group by Having and Like clause in SQL
UNIT IV XML:
Structure of XML Data, XML Document Schema, Querying and Transformation, Storage of XML Data, XML Data and World Wide Web
UNIT V EMERGING DATABASE TECHNOLOGIES – NOSQL:
Why NoSQL? Overview of NoSQL, Brief Introduction to various NoSQL Data Models– Key-Value, Document, Column-Family Stores and Graph and Limitations of NoSQL
TOTAL: 45 PERIODS
COURSE OUTCOMES:
At the end of this course, student should be able to:
Develop entity-relationship diagrams and relational schemas for a database using a given set of business rules
Write SQL statements for a variety of data definition and data manipulation scenarios
Define and manipulate XML Data
Handle unstructured data using NoSQL.
TEXT BOOKS :
1. Abraham Silberschatz,Henry F. Korth and S. Sudarshan, Database System Concepts, Sixth Edition, Tata McGraw-Hill,2013
2. Ramez Elmasri and Shamkant B. Navathe; Fundamentals of Database Systems, Pearson, Seventh Edition, Global Edition,2010
REFERENCES:
1. C.J.Date, “An Introduction to Database Systems”,Eighth Edition, PearsonEducation,2004.
2. Pramod J. Sadalage and Martin Fowler, NoSQL Distilled: A Brief Guide to the Emerging World of Polyglot Persistence 1st Edition, Addison-Wesley Professional,2012.
3. Guy Harrison,Next Generation Databases: NoSQL, NewSQL, and Big Data, Apress,2015.