Unit 1
DBMS Concepts Introduction,
Data models, Entities and attributes, Relationships, E-R
diagram. Relational Data
models: Domains, Tupples, Attributes, Keys, Relational
database, Schemas,
Integrity constraints. Relational algebra and relational calculus,
Normalization, Normal
forms.
Unit 2
Query Processing and
Optimization. Distributed databases: Fragmentation, Replication,
Location & Fragment
transparency, Distributed Query Processing and Optimization.
Unit 3
Object oriented and object
relational databases: Specialization, Generalization,
Aggregation,
Unit 4
Association. Introduction
to Image and Multimedia databases and data structures. Data
structure- R tree, K d
tree, Quad trees, Content based retrieval: Color Histograms.
Unit 5
Web databases: Accessing
databases through web
Reference
Books:
1. R. Elmasri, S. Navathe,
Fundamentals of Database System, Benjamin Cummings
2. C.J. Date, An
Introduction to Data base Systems, Volume I, Addison Wesly
3. H. F. Korth and A.
Silberschatz. Database Concept, TMH
4. Object Oriented
databases :Narang, Prentice-Hall of India, New Delhi
5. Rob, Database Systems,
Cengage, (Thomson)
6. Pratt, Concepts
of DBMS, Cengage.
No comments:
Post a Comment