Course Description:
After the completion of this course, the students will get familiarity with the database’s core concepts, database design, its refinement, and a moderate level of expertise in DBMS. Topics include database system architectures, data models, query languages, conceptual and logical design, physical organization, and transaction management. Students will learn high-level languages such as SQL, file organization and access methods are provided as a basis for discussion of query optimization techniques. Students will be able to design the database schema for a small to a medium-sized real-life database application.

Course Learning Outcomes:
CLO:1 Apply the role of database management systems within organizations.
CLO:2 Analyze the database systems, including data models, file structures, index schemes, and query evaluation.
CLO:3 Design a DBMS including stored procedures, stored functions, cursors, packages.

Course Contents:
1. Introduction to DBMS – Four Lectures
• Shortcomings of Traditional File Processing System
• Benefits of DBMS
• Characteristics of DBMS
• Database system and its components

2. Data models – Four Lectures
• Data Types and Data Retrieval
• Database Design – Entity-Relationship Model
• Relational Model
• Relational Algebra

3. Managing Tables- – Four Lectures
• Table Creation
• Adding and modifying Columns
• Restrictions on the Alter Table
• Removing Tables

4. Database Architecture- Four Lectures
• Three Level Schema Architecture
• Data Independence
• Database Languages Database
• SQL Programming and constructs

5. Database Planning, Design, and Administration- Four Lectures
• ACID properties of transactions
• Recovery and Concurrency Control
• DB Planning System Definition
• Requirements Collection and Analysis
• Data Administration and Database Administration

6. Data Constraints- – Four Lectures
• Column & Table level constraints
• Primary & Foreign Key concepts
• Application of other Data constraints.

7. Relational Database Implementation- Four Lectures
• Implementing using DDL and DML
• Database Development Process
• Indexing
• Hashing

8. Query Processing- Four Lectures
• Basics of Query Processing
• Advanced topics:
• Database Security,
• Reliability and Integrity