Scribd
Upload
40 views1 page

Dbms Lab

The document outlines the syllabus for a Database Management System course for 5th semester CSE(IoT) students. It includes a series of experiments focusing on ER Diagrams, relational model conversion, normalization, SQL table creation, DML commands, queries, subqueries, joins, and triggers. Each section requires students to apply theoretical knowledge through practical exercises and case studies.

Uploaded by

ashuwashu22
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
40 views1 page

Dbms Lab

The document outlines the syllabus for a Database Management System course for 5th semester CSE(IoT) students. It includes a series of experiments focusing on ER Diagrams, relational model conversion, normalization, SQL table creation, DML commands, queries, subqueries, joins, and triggers. Each section requires students to apply theoretical knowledge through practical exercises and case studies.

Uploaded by

ashuwashu22
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

INDEX

Subject : Database Management System Code : 155502P

Semester : 5th Discipline : CSE(IoT)


S. No. Details of Experiments (s) Faculty Signature
Student should decide on a case study and formulate the problem
1.
statement for ER Diagram.

Conceptual Designing using ER Diagrams (Identifying entities,


2. attributes, keys and relationships between entities, cardinalities,
generalization, specialization etc.)

Converting ER Model to Relational Model (Represent entities and


3. relationships in Tabular form, Represent attributes as columns,
identifying keys)

Normalization -To remove the redundancies and anomalies in the


4.
above relational tables, Normalize up to Third Normal Form.

Creation of Tables using SQL- Overview of using SQL tool, Data


5. types in SQL, Creating Tables (along with Primary and Foreign
keys), Altering Tables and Dropping Tables.

6. Practicing DML commands- Insert, Select, Update, Delete.

Practicing Queries using ANY, ALL, IN, EXISTS, NOT EXISTS,


7.
UNION, INTERSECT, CONSTRAINTS etc.

Practicing Sub queries (Nested, Correlated) and Joins (Inner, Outer


8.
and Equi).

Practice Queries using COUNT, SUM, AVG, MAX, MIN, GROUP


9.
BY, HAVING, VIEWS Creation and Dropping.

Practicing on Triggers - creation of trigger, Insertion using trigger,


10.
Deletion using trigger, Updating using trigger.

You might also like