Introduction to file and Database Management Systems

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 – Thee ANSI / SPARC architecture.
1.5.1 The external level.
1.5.2 The conceptual level.
1.5.3 The internal level.
1.5.4 Mappings between levels.
1.5.5 Data independence.
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 E-R features.
2.1.7 Design of an ER schema.
2.1.8 Reducing an ER schema to tables.

UNIT 3

4. File Structures.
4.1 Fixed length records.
4.2 Sequential file organization.
4.3 Clustering file organization.
4.4 Data dictionary storage

5. Indexing and hashing.
5.1 . Types of indices.
5.1.1 Ordered indices.
5.1.2 B*- Tree index files.
5.1.3 B- Tree index files.
5.2. Hashing.
5.2.1 Static Hashing.
5.2.2 Dynamic Hashing.
5.3 Comparison of ordered indexing and hashing.
5.4 Multiple keys access.

Home > Bachelor of Science > Introduction to file and Database Management Systems
  1. No comments yet.
  1. No trackbacks yet.