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.