Exercise 1: SQL Introduction
Create student table with the attributes SName, RegNo, Dept, Mobile, Place, M1, M2,
Display the structure of the table
Rename the Mobile attribute as MobileNo
Modify the table by removing Pl
1. Find the names of all branches in loan relation.
2. Find the names of all branches in loan relation, eliminate duplicates.
3. Display the loan relation with the attributes amount is multiplied by 100.
4. Find all loan no's for loan's made at perryridge
LAB EXERCISE -3
Q1. Consider the following relations concerning a driving school. The primary key
of each relation is in underlined :
STUDENT : (St_RegNo, St_Name, Class#, Th_Mark, Dr_Mark)
Movie ( mID, title, year, director )
Description: There is a movie with ID number mID, a title, a release year, and a director.
Reviewer ( rID, rname )
Description: The reviewer with ID number and reviewer n