Scribd
Upload
46 views1 page

DBMS LAB Assignments List

The document outlines a list of DBMS lab assignments for students, including tasks such as requirement analysis, database creation, executing DDL and DML statements, and writing SQL queries. It also covers advanced topics like PL/SQL stored procedures, triggers, and MongoDB CRUD operations. Students are advised to select their course project topics at the beginning of the semester to integrate these assignments into their project work.

Uploaded by

nikhilyt93
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
46 views1 page

DBMS LAB Assignments List

The document outlines a list of DBMS lab assignments for students, including tasks such as requirement analysis, database creation, executing DDL and DML statements, and writing SQL queries. It also covers advanced topics like PL/SQL stored procedures, triggers, and MongoDB CRUD operations. Students are advised to select their course project topics at the beginning of the semester to integrate these assignments into their project work.

Uploaded by

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

DBMS Lab Assignments List

Assignmen Title of Assignment


t No
1 Choose a database application; you propose to work on throughout the course.
Perform requirement analysis in detail for the same. Draw an entity-relationship
diagram for the proposed database.
2 Create a database with appropriate constraints using DDL and populate/modify
it with the help of DML.
3 Execute DDL statements which demonstrate the use of views. Try to update the
base table using its corresponding view. Also consider restrictions on updatable
views and perform view creation from multiple tables.
4 Write equijoin, non equijoin, self join , Natural join and outer join queries.
5 Design and Execute "SELECT" queries using conditional, logical, like/not like,
in/not in, between...and, is null/is not null operators in where clause, order by,
group by, aggregate functions, having clause, and set operators. Use SQL single
row functions for date, time, string etc.
6 Write useful stored procedures in PL/SQL.
7 Write and execute all types of database triggers in PL/SQL.
8 Study Assignment on Parallel and Distributed databases.
9 Mongo DB CRUD operations.

**Note: It is expected that students should choose their course project topics in the start of semester
only so that, they can apply all lab assignments for their course project database system.

You might also like