Photo by Marten Bjork on Unsplash
Database Management System
Here is an basic overview of DBMS course for university CS student including course contents, statement, topics, assignments.
Table of contents
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:
Learn the fundamentals of database systems including data models, database architectures, database manipulations, file organization and retrieval
Learn the theories and techniques for developing database applications, management and security
Demonstrate the management and administration of database systems
Prescribe new developments and trends in databases using commercial languages on contemporary issues
Topics/Assignments:
Introduction to database, relational database, necessity of database management systems. Different data models and administration of the database.
Entity-relationship data model: attributes and constraints.
Entity-relationship data model: case study to design database.
Introduction to schema models, definition and manipulation language
Relational Database: constraints, attributes, manipulations.
Relational Database: simple query details
Relational Database: complex query details
Relational Database: View concepts
Relational Algebra: Basic Operations
Relational Algebra: Complex Operations
Relational Database: Security and integrity management
Database theories: functional dependencies, impact of functional dependencies.
Database techniques: anomaly problems, normalization, different normal forms
Database theories and techniques: application of functional dependencies to normalize the database into different normal forms.
Application of Normalization in designing databases on real-life problems
Indexing and Hashing: introduction, importance, types, applications
Indexing: B+ tree structure, manipulation of B+ tree structure
Hashing: Dynamic hash structure and its manipulation
Transaction: definition, characteristics, importance, states
Transaction: consistency and serializability
Transaction: atomicity and backup system. RAID: different levels.
File storage management