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

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
   76   77   78   79   80   81   82   83   84   85   86