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