[go: up one dir, main page]
Scribd
Upload
135 views1 page

Experiment List - DBMS - KCS551

This document outlines the course outcomes and experiment list for the Database Management System Lab course at ABES Engineering College, Ghaziabad. The course aims to teach students how to create database objects using Oracle 11g, design database schemas, write SQL queries and PL/SQL code, and enforce data integrity constraints. The experiment list includes tasks like creating ER diagrams, implementing DDL, DML, and DQL commands, using joins, subqueries and functions, creating views and indexes, and writing procedures, functions and triggers in PL/SQL. Students will perform hands-on experiments on Oracle to reinforce these skills. The course is signed off by the Head of the Information Technology department.

Uploaded by

Navneesh kumar
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
135 views1 page

Experiment List - DBMS - KCS551

This document outlines the course outcomes and experiment list for the Database Management System Lab course at ABES Engineering College, Ghaziabad. The course aims to teach students how to create database objects using Oracle 11g, design database schemas, write SQL queries and PL/SQL code, and enforce data integrity constraints. The experiment list includes tasks like creating ER diagrams, implementing DDL, DML, and DQL commands, using joins, subqueries and functions, creating views and indexes, and writing procedures, functions and triggers in PL/SQL. Students will perform hands-on experiments on Oracle to reinforce these skills. The course is signed off by the Head of the Information Technology department.

Uploaded by

Navneesh kumar
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
You are on page 1/ 1

ABES ENGINEERING COLLEGE, GHAZIABAD

Department of Information Technology

Database Management System Lab (KCS-551)


B. Tech., 3rd Year (IT), Vth Sem, 2023-24

Course Outcome:

S.NO CO Description KL
1 Understand and apply oracle 11 g products for creating tables, views,
K2,K4
indexes, sequences and other database objects.
2 Design and implement a database schema for company data base,
banking data base, library information system, payroll processing K3,K5
system, student information system.
3 Write and execute simple and complex queries using DDL, DML,
K4,K5
DCL and TCL
4 Write and execute PL/SQL blocks, procedure functions, packages and
K4,K5
triggers, cursors
5 Enforce entity integrity, referential integrity, key constraints, and
K3,K4
domain constraints on database.

Note: You are required to perform practical on Oracle

Experiment List

S.No Description CO KL
.
1 Creating ER Diagram using Case Tools CO2 K4
2 Execution of DDL Commands and Constraints CO1,CO3,CO5 K5
3 Execution of DML Commands CO3 K5
4 Execution of DQL Commands & Sorting Data CO3 K5
5 Implementation of Subqueries/Nested Query CO3 K5
6 Implementation of Joins using multiple table CO3 K5
7 Execution of Group & having clause for Restriction CO3 K5
data
8 Solving the queries using SINGLE row functions CO3 K5
9 Implementation of Views & Indexing CO1 K4
10 Implementation of CO4 K5
Procedures/Functions/Triggers/Cursors
11 Creating Database/ Table Space CO3 K4
 Managing Users: - Create User, Delete User
 Managing Passwords
 Managing roles: - Grant , Revoke
(Beyond Syllabus)
12 Given an integer i, write a PL/SQL procedure to CO4 K5
insert the tuple (i, 'xxx') into a given relation.
(Beyond Syllabus)

Prof. (Dr.) Amit Sinha Faculty Signature


HoD (IT)

You might also like