PART-I
I. Overview of Database Management System
- File System: Introduction, Drawbacks
- History and Development of DBMS
- Objectives of DBMS
- Classification of DBMS
- Advantages and Disadvantages of DBMS
- ANSI / SPARK Model (Levels of abstraction)
- Component and Interfaces of DBMS
- DBMS Architectures
- Data Models
- Situations where DBMS is not necessary
- DBMS Vendors and their productions
II. Entity Relational Model
- The Building Blocks of ER-Model
- Types of Entities, attributes, relation ships
- Reducing ER Diagram to Tables
- Enhanced ER Modeling
- Generalization and specialization
- IS-A and HAS-A Relationships
- Attribute and Multiple inheritance
- constraints on Generalization and specialization
- Aggregation and composition
0 comments:
Post a comment