Database Management Systems Lab

P-4, Credit-2 Course Objective: This course aims to provide hands-on experience in designing databases, writing SQL queries, and applying normalization and data integrity concepts using a DBMS package for business applications.

Course Outcomes:

CO1. Perform practical exercises to define and describe database systems CO2. Create and design databases implementing constraints to ensure data integrity in sample business applications CO3. Develop proficiency in writing and executing SQL queries CO4. Analyze and normalize relational database schemas for specific business cases Lab would be based on the Paper BBA-CAM 201: DBMS and it will be based on DBMS package.

I.

To write SQL queries and retrieving data.

II.

SQL: Introduction to tables, Creating Tables, duplicating tables, modifying tables, dropping tables, rename a tables III.

Records: Inserting and updating the records in tables, Deleting the records, Viewing a table structure, Introduction to keys, Data integrity constraints IV.

Query: Simple query, Nested query, Joins: Natural join, Inner join, Cross join, Outer join, Full join. Aggregate functions: Group by and having clause, Relational and Logical operators.

V.

Views, use of rollback and commit command, save points, Functions: string functions, statistical functions, date functions, Numeric functions conversion function