Advanced Data Modeling

Unit 1

What is data modeling, The History of Data Modeling, Data Modeling Fundamentals, Entity Relationship Model, Enhanced Entity Relationship Models, UML, Physical Data Models.

Unit 2

Mathematical Foundation of the Relational Model, Keys and Referential Integrity, Functional dependencies and normalization, Relational Algebra, Relational Mappings.

Unit 3

Object Oriented Databases - Introduction, Weakness of RDBMS, Object Oriented Concepts Storing Objects in Relational Databases, Next Generation Database Systems, Object Oriented Data models, OODBMS Perspect, Issues in OODBMS, Advantages and Disadvantages of OODBMS.

Unit 4

Object Oriented Database Design, OODBMS Standards and Systems, Object Management Group, Object Database Standard ODMG, Object Relational DBMS, Comparison of ORDBMS and OODBMS.

Unit 5

XML Fundamentals, XML Schema and DTD document definitions, XSLT transformations and programming, Parsing XML.

REFERENCES:

1. Ramez Elmasri & Shamkant B.Navathe, “Fundamentals of Database Systems”, Sixth Edition, Pearson Education, 2010.

2. Peter Rob and Corlos Coronel, “Database Systems - Design, Implementation and Management”, Thompson Learning, Course Technology, 5th Edition, 2003.

3. Graeme Simsion & Graham Witt, “Data Modeling Essentials, Third Edition”, Morgan Kaufmann

4. David Hunter, Jeff Rafter, Joe Fawcett, and Eric van der Vlist “ Beginning XML Fourth Edition, Wrox Publications.

5. A Silberschatz, H Korth, S Sudarshan, “Database System and Concepts ”, Fifth Edition, McGraw-Hill