Management System CS403Assignment # 4
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:
List the teachers showing only the Name and Hometown.
List all the student Id and teacher Id where GPA is 3 or more than 3.
List all the students of the teacher whose name is ‘John Eric’.
List student Id, name, and address of all the students whose date of birth is 1983.
List all the Course Code where the credit hours are 4
Objective
- This assignment has been designed so that you understand the concept of SQL
Note: Try to solve assignment your self if it is found that your assignment is copied with other student. Then both assignments marked as zero. Submit assignment in proper way as mentioned above submission in proper way also hold marks. Don’t put assignment related question on MDB. For any further quarries about assignments mail to your concerned Teacher
