Course Rationale

DBMS refers to an introductory course for understanding the fundamental concepts, principles, and techniques of database management systems. DBMS aims at the design, implementation and maintenance of relational databases, as well as various database models, query languages, normalization techniques, and database administration.

Course Objective:

• Gain a foundational understanding of database management systems, including data models, normalization principles, and relational algebra.  
• Develop proficiency in SQL for data manipulation, querying, and database schema definition. 
• Learn to design and implement efficient relational databases using normalization techniques and proper schema design principles. 
• Understand database security concepts and implement measures such as authentication, authorization, encryption, and auditing to protect data integrity and confidentiality. 
• Explore advanced topics such as distributed databases, NoSQL databases, and data warehousing to understand emerging trends and technologies in the field.

Course Assessment:

Final grade in each course will be given on the basis of performance in class attendance, in-
course examinations, assignments, midterm test and final examination is shown in Table.

Text Book

Database System Concept, Silbertz, Korth and Sudarshan

Reference Book

Fundamentals of Relational Database Management Systems, Author: S. Sumathi and S. Esakkirajan.