Database Management System

Course Contents:

Concepts and methods in database systems, File organization and retrieval, Data manipulation, Query formulation and language, Database models, Data description languages, database integrity and security, Data dictionary/directory systems, database administration, Database design, Survey of some existing database management systems, Some applications using commercial languages.

Statement:

1. Learn the fundamentals of database systems including data models, database architectures, database manipulations, file organization and retrieval

2. Learn the theories and techniques for developing database applications, management and security

3. Demonstrate the management and administration of database systems

4. Prescribe new developments and trends in databases using commercial languages on contemporary issues

Topics/Assignments:

1. Introduction to database, relational database, necessity of database management systems. Different data models and administration of the database.

2. Entity-relationship data model: attributes and constraints.

3. Entity-relationship data model: case study to design database.

4. Introduction to schema models, definition and manipulation language

5. Relational Database: constraints, attributes, manipulations.

6. Relational Database: simple query details

7. Relational Database: complex query details

8. Relational Database: View concepts

9. Relational Algebra: Basic Operations

10. Relational Algebra: Complex Operations

11. Relational Database: Security and integrity management

12. Database theories: functional dependencies, impact of functional dependencies.

13. Database techniques: anomaly problems, normalization, different normal forms

14. Database theories and techniques: application of functional dependencies to normalize the database into different normal forms.

15. Application of Normalization in designing databases on real-life problems

16. Indexing and Hashing: introduction, importance, types, applications

17. Indexing: B+ tree structure, manipulation of B+ tree structure

18. Hashing: Dynamic hash  structure and its  manipulation

19. Transaction: definition, characteristics, importance, states

20. Transaction: consistency and serializability

21. Transaction: atomicity and backup system. RAID: different levels.

22. File storage management