Course Rationale:
Database Management Systems (DBMS) are vital components of modern information systems. Database applications are pervasive and range in size from small in-memory databases to terra bytes or even larger in various applications domains. The course focuses on the fundamentals of knowledge-base and relational database management systems, and the current developments in database theory and their practice.
Course Objective:
Upon successful completion of this course, students should be able to:
- Describe the fundamental elements of relational database management systems.
- Explain the basic concepts of relational data model, entity-relationship model, relational database design, relational algebra and SQL.
- Design ER-models to represent simple database application scenarios
- Convert the ER-model to relational tables, populate relational database and formulate SQL queries on data.
- Improve the database design by normalization.
- Familiar with basic database storage structures and access techniques.
Course Outcome
CO1: To be able to apply analytical skills to map out the conceptual design for a real-life problems and write database documentation, including data standards, procedures and definitions for the data dictionary.
CO2: To be able to draw the model of Relational Database using Entity Relationship (ER) model and explain the fundamental elements of Database management System.
CO3: To be able to evaluate the logical design to translate into a specific data model and physical design to meet system storage requirements.
CO4: To be able to evaluate MSSQL/MySQL/Oracle features and MSSQL /MySQL/Oracle related products for maintaining the integrity and performance of enterprise databases.
