Page 81 - Microsoft Word - B.Tech. Course Structure (R20) WITH 163 CREDITS

JNTUA College of Engineering (Autonomous),Ananthapuramu
Department of Computer Science & Engineering
Database Management Systems Lab
Course Code: Semester IV(R20) L T P C: 0 0 3 1.5
Course Objectives:
• To implement the basic knowledge of SQL queries and relational algebra.
• To construct database models for different database applications.
• To apply normalization techniques for refining of databases.
• To practice various triggers, procedures, and cursors usingPL/SQL.
• To design and implementation of a database for an organization

Course Outcomes:
CO1: Design databases
CO2: Define SQL queries and Retrieve information from data bases
CO3: Apply the constraints in queries
CO4: Implement PL/SQL programs
CO5: Investigate for data inconsistency

Week-1: CREATION OF TABLES

1. Create a table called Employee with the following structure.
Name Type
Empno Number
Ename Varchar2(20)
Job Varchar2(20)
Mgr Number
Sal Number

a. Add a column commission with domain to the Employee table.
b. Insert any five records into the table.
c. Update the column details of job
d. Rename the column of Employ table using alter command.
e. Delete the employee whose empno is19.

2. Create department table with the following structure.

Name Type
Deptno Number
Deptname Varchar2(20)
location Varchar2(20)

a. Add column designation to the department table.

Mdv
Mdv