Scribd
Upload
91 views

LoP PDF

This document provides a list of 15 practical assignments for a Database Management System course scheduled over 15 weeks. The practicals cover basic SQL commands, creating and manipulating database tables, functions, nested and correlated queries, data constraints, joins, set operations, views, data control language commands, and PL/SQL programming. Students will be evaluated on the logic, implementation, neatness and timely submission of their work.

Uploaded by

Kushal Rajput
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
91 views

LoP PDF

This document provides a list of 15 practical assignments for a Database Management System course scheduled over 15 weeks. The practicals cover basic SQL commands, creating and manipulating database tables, functions, nested and correlated queries, data constraints, joins, set operations, views, data control language commands, and PL/SQL programming. Students will be evaluated on the logic, implementation, neatness and timely submission of their work.

Uploaded by

Kushal Rajput
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/ 3

Database Management System

List of Practicals

Sr. No. Title Schedule


(in Weeks)

1. • Basic SQL commands Like Ed, c, spool etc. 1


• Creating Table
• Retrieve/view table structure
Inserting Data into tables 2

• Global Insertion: Insert into all rows and


columns
• Insert data into specified columns
• Insert data into specified order of columns
• Inserting data by getting prompt View /
Retrieve Data from the table.

• Global Retrieval : All rows and columns


e.g. SQL> select * from tablename

• Retrieving specific column data


• Retrieving data in specific sorted order
• Retrieve Unique values
• Dealing with NULL values
• Pattern Matching
2. Update and Delete data of the table. 3

• Update and delete all Records / specific set of


Records.
• Modify the structure of the table.
• Add new columns
• Modify existing columns
• Delete existing column
3. Functions 4

• Numeric
• Date
• String
• Conversion
4. Table file operation 5

• Renaming Table
• Delete table
• Create a table with existing table’s structure
and / or data
• Copy data from one table to another
5. Nested Query (sub query will be evaluated once for 6,7
all records of main query)

Co-related Query ( Sub query will be evaluated


every time for every record)

Use of All, Any , Exists

6. Apply Data Constraints on Tables 8

• Unique
• Primary Key
• Foreign key
• Default
• Check
7. Joins on Tables 9

• Equi Join
• Self Join
• Natural Join
• Theta Join
8. Use of Set operators 10

• Union
• Intersect
• Minus (Except)
Perform View operations

• Creating
• Modifying
9. Perform the DCL commands (grant, revoke): 11,12

Create a Student table with following fields:


StudentCode, Name, Dateofbirth, Course, RollNo,
Batch, Result.

Grant and Revoke following security constraints:

• User F can retrieve over entire table


• User S can insert and delete on entire table.
• Every user can retrieve over his/her record
only.
• User N can retrieve over entire table and
update on Course and RollNo only
• User T can retrieve over Name, StudentCode,
and Result only.
• User W can retrieve as T and update as N
• User P can all the privileges for BE-IT
student’s records.
• User J can delete on records for student of
Batch B2
• User B can update and delete on students
record of courses where there are no more
than 5 student
• User K can retrieve for Eldest and youngest
student
10. PL/SQL 13,14,15
 PL/SQL Anonymous Block
 Function
 Procedure
 Trigger (row-level, Statement -level)

The faculty will evaluate the student based on the logic (3 marks), implementation (5 marks),
neatness and timely submission (2 marks).

You might also like