CSE - 501 DATABASE SYSTEMS

Comparative study of Files vs. Database systems. A comparative study of the following file organization techniques: Pile file, Sequential file, Indexed Sequential file, Indexed File, Direct File, Multi-ring file.

Introduction to database Concepts, Goals of Database Management Systems, Data Independence, Data Models, Brief Review of file system.

Organization techniques, difference between a file system and a data base system.

Network Model, DGTG proposal. Implementation. Data Definition and Manipulation Languages.

DBMS Models: Hierarchical, Network and Relational Storage Organization for relations, relational algebra and calculus: data description and relational query language. Query processor and optimiser. Functional dependencies, normal forms, multivalued dependencies. Decomposition of relational schemes. Integrity constraints, data impedency, consistency, protection, data security. Concurrent operations on data bases. Crash recovery etc. Introduction to distributed data bases. Data base Machines. Physical Data Base Design, Case Studies: System R, Ingres, IDMS, Oracle etc. Comparison of available data base systems.

TEXTBOOKS

1. J.D. Ullman: Principles of Data Base Systems, Galgotia Publications, New Delhi

2. J. Martin: Computer Data Base Organization, PHI.

REFERENCES

1. S.Atre: Data Base: Structured Techniques for Design Performance and Management,

John Wiley International Edition.

2. C.J. Date: An introduction to Data Base Systems, Vol I & II, Addison Weslay

3. G. Wiedershold: Data Base Design, Mc. Graw Hill

© Copyright National Institute of Science & Technology, Berhampur, Orissa, India
Website Maintained by NIST Training & Consultancy Services