Scribd
Upload
11 views4 pages

DBMS Lab View Creation Exercises

The document outlines a series of exercises for a Database Management System (DBMS) lab, focusing on creating and manipulating views in a database. It includes tasks such as displaying records from various tables, updating data through views, and calculating GPA and salaries. The exercises aim to enhance practical skills in SQL and database management concepts.

Uploaded by

razaannas7
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
11 views4 pages

DBMS Lab View Creation Exercises

The document outlines a series of exercises for a Database Management System (DBMS) lab, focusing on creating and manipulating views in a database. It includes tasks such as displaying records from various tables, updating data through views, and calculating GPA and salaries. The exercises aim to enhance practical skills in SQL and database management concepts.

Uploaded by

razaannas7
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

SAAD BIN MUNIR | 02-134222-026 | BS CS 4B | DBMS LAB

Exercises

1. Create a view to display records of Semester having semid greater than 3 from
Semester table with the following attributes:
Semid,Semname,StartDate.
Display all the records from view created.

2. Create a view named as StdInformation_vw to display record from Std table


having following attributes
StdID,StdName,StdDOB,ProgiD,FirstSem
SAAD BIN MUNIR | 02-134222-026 | BS CS 4B | DBMS LAB

3. Through view created in question 2, update the FirstSem of Sudent named Abrar
from 4 to 3 and then display all the records from the same view.

4. Create any simple view using semester, Course and Prog table that displays
followingattributesCourseName,CrediTheory,CrediLab,ProgName,Semname
SAAD BIN MUNIR | 02-134222-026 | BS CS 4B | DBMS LAB

5. Create a view which displays all the information of teacher who teaches semester
4 and 6.

6. Create a Views that displays the sum if salaries based on the status of the teachers.

7. Create a view that displays the percentage obtained by all students based on their
total marks.
SAAD BIN MUNIR | 02-134222-026 | BS CS 4B | DBMS LAB

8. Create a view that calculated the GPA of students based on their percentage
results calculated in the task 7

9. Create a view MY_VU based on the table NewTeacher which does not exists in the
schema. Now create the table NewTeacher from Teacher table having records of
visiting Faculty. Now select all the records from the view MY_VU.

You might also like