INTRO TO DATABASE MANAGEMENT SYSTEMS

UNIT 1

1.       Overview of Database Management.

1.1     Shortcomings of a file management system.
1.2     Difference between a database and a database system.
1.3     Benefits of database approach.
1.4     Data independence.
1.5     Data abstraction - The ANSI / SPARC architecture.
1.6     The database management system.
1.7     The database administrator.
1.8     Database users.
1.9     Overall database system architecture.

UNIT 2

2.       Data Models.

2.1     The entity relationship model

2.1.1 Entity sets, relationship sets.
2.1.2  Mapping cardinalities.
2.1.3 Primary key specification.
2.1.4 Entity relationship diagram.
2.1.5  Weak entities.
2.1.6  Extended ER features.
2.1.7 Design of an ER schema.
2.1.8 Reducing an ER schema to tables.

UNIT 3

3.       File Structures.

3.1     Fixed length records.
3.2     Sequential file organization.
3.3     Clustering file organization.
3.4     Data dictionary storage

4.       Indexing and hashing.

4.1.     Types of indices(Ordered,B*Tree ,B Tree).
4.2.     Hashing.
4.3      Comparison of ordered indexing and hashing.
4.4      Multiple keys access.