Scribd
Upload
76 views2 pages

Dbms Lab Syllabus

The document outlines the objectives and outcomes of a Database Management Systems laboratory course, focusing on SQL and PL/SQL skills. It includes a list of experiments that cover database creation, complex queries, and the development of mini projects. The course aims to equip students with practical skills in database design and manipulation, supported by references to key textbooks.

Uploaded by

charumathi
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
76 views2 pages

Dbms Lab Syllabus

The document outlines the objectives and outcomes of a Database Management Systems laboratory course, focusing on SQL and PL/SQL skills. It includes a list of experiments that cover database creation, complex queries, and the development of mini projects. The course aims to equip students with practical skills in database design and manipulation, supported by references to key textbooks.

Uploaded by

charumathi
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

DATABASE MANAGEMENT SYSTEMS LABORATORY LTPC

PUIT4PL02

0042

COURSE OBJECTIVE
1. Have basics of data manipulation skills through SQL
2. Understand how to write complex queries, sub queries and joins
3. Understand the significance of using views, synonyms, sequences, indexes and constraints
4. Have basics of data processing skills through PL/SQL, triggers, procedures, exceptions and
functions
5. Have basics of developing mini project using database systems
LIST OF EXPERIMENTS:
1. Creation of a database and writing SQL queries to retrieve information from the database.
2. Performing Insertion, Deletion, Modifying, Altering, Updating and Viewing records based on conditions.
3. Create complex queries and sub queries.
4. Perform different types of joins.
5. Creation of Views, Synonyms, Sequence, Indexes, save point.
6. Creating an Employee database to set various constraints.
7. Creating relationship between the databases.
8. Study of PL/SQL block.
9. Write a PL/SQL block to satisfy some conditions by accepting input from the user.
10. Write a PL/SQL block that handles all types of exceptions.
11. Creation of Procedures.
12. Creation of database triggers and functions.
TOTAL: 60 PERIODS
COURSE OUTCOMES: At the end of the course, the students will be able to:

COs Course Outcomes Cognitive Level

CO1 Design database of required form and retrieve information from it using SQL Create

CO2 Use complex queries, sub queries and joins Apply

CO3 Develop databases using views, synonyms, sequences, indexes and constraints Apply

CO4 Create
Create PL/SQL functions, triggers, procedures, exceptions and functions
CO5 Implement a mini project with database design for given problem Apply

CO – PO Mapping

CO PO1 PO2 PO3 PO4 PO5 PO6 PO7 PO8 PO9 PO10 PO11 PO12 PSO1 PSO2
CO1
2 2 3 2 1 - - - 2 2 1 3 2 1
CO2
3 1 1 1 1 - - - 2 3 1 2 1 1
CO3
3 2 3 2 2 - - - 2 2 3 3 2 2
CO4
1 2 3 2 1 - - - 3 1 2 3 2 2
CO5
1 1 3 3 2 - - - 1 2 2 2 2 2

REFERENCES:

1. Abraham Silberschatz, H. F. Korth S. Sudershan, Database System Concepts, McGraw Hill, 6th Edition
2010.
2. Thomas Connolly, Carolyn Begg, Database Systems: A Practical Approach to Design, Implementation and
Management,6th Edition,2012.
3. Pramod J. Sadalage and Marin Fowler, NoSQL Distilled: A brief guide to merging world of Polyglot
persistence, Addison Wesley, 2012

You might also like