[go: up one dir, main page]
Scribd
Upload
5 views2 pages

DBMS Lab Programs

The document outlines a series of tasks related to database management, including creating schemas and inserting records with constraints, studying and implementing various SQL commands (TCL, DCL, DDL, DML), and executing aggregate functions and set operators. It also includes the creation of E-R diagrams for different scenarios such as a company, car-insurance, hospital, online bookstore, and library management system, along with the construction of appropriate tables for each diagram. Additionally, it covers normalization up to the third normal form and the implementation of SQL views and triggers.

Uploaded by

ramaneshbhavana
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
5 views2 pages

DBMS Lab Programs

The document outlines a series of tasks related to database management, including creating schemas and inserting records with constraints, studying and implementing various SQL commands (TCL, DCL, DDL, DML), and executing aggregate functions and set operators. It also includes the creation of E-R diagrams for different scenarios such as a company, car-insurance, hospital, online bookstore, and library management system, along with the construction of appropriate tables for each diagram. Additionally, it covers normalization up to the third normal form and the implementation of SQL views and triggers.

Uploaded by

ramaneshbhavana
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

 Create Schema and insert at least 5 records for each table.

Add appropriate

database constraints.

 Study & Implementation of TCL commands (Rollback, Commit, Savepoint)

 Study & Implementation of DCL (Grant, Revoke).

 To study and execute the DDL commands (create, drop, alter, truncate and

rename) in MYSQL with suitable examples

 To study and execute the DML commands (select, insert, update, delete) in

MYSQL with suitable examples

 To implement AGGREGATE function commands (count, sum, avg, min,

max) with suitable examples

 Implementation of SQL SET OPERATORS (union, union all, intersect and

minus)

 Study & Implementation of Views

 Study & Implementation of SQL Triggers (Creation of insert trigger, delete


trigger, update trigger)

 Normalization up to Third Normal Form

 Draw the E-R diagram which models Company. Construct appropriate tables
for the above ER Diagram
 Construct an E-R diagram for a car-insurance company whose customers own

one or more cars each. Each car has associated with it zero to any number of

recorded accidents. Construct appropriate tables for the above ER Diagram?

 Construct an E-R diagram for a hospital with a set of patients and a set of

medical doctors. Associate with each patient a log of the various tests and

examinations conducted. Construct appropriate tables for the above ER

Diagram

 Draw the E-R diagram which models an online bookstore. Construct

appropriate tables for the above ER Diagram

 Construct an E-R diagram for a Library Management System. Construct


appropriate tables for the above ER Diagram

You might also like