The Assignment:

Consider the tables given below:

TEACHER (teacherId,T_name,T_address,T_phoneNo,Hometown)

STUDENT (studentId,teacherId,S_name,S_address,S_phoneNo,DOB)    

COURSE (couseCode,CourseName,CreditHours)

STUDENT_COURSE (teacherId,studentId,GPA)

Write SQL queries for the following:

i. List the teachers showing only the Name and Hometown.

ii. List  all the student Id and teacher Id   where GPA is 3 or more than 3.

iii. List all the students of the teacher whose name is 'Asif Masood'.

iv. List studentId,name,address of all the students whose date of birth is 1983.

v. List all the CourseCode  where the credit hours are 4

Objective:

• This assignment has been designed so that you understand the concept of SQL