Reference no: EM132989610

You must create tables Student, Course, and enrollment with PKs, FKs, unique, not null, and check constraints. Find the relationship between student and course and see if you need the bridge table. The bridge table must have composite PK. You must have at least five columns in Student table, 2 columns in course table, and 3 columns in enrollment table.

Each table must have PK. According to relationship add FK. You must use default, e.g., if user do not enter a value for hire_date then by default today's date will be inserted in hire_date column.

Q1. Add your own and group members information to table Student, add two courses that you are taking this semester into Course table, and Enrollment table.

Q2. List all courses that have been enrolled by student whose student ID is your student number

Q3. List all students who have already enrolled in course 'COMP122'

Q4. Display student first name and last name together and name it as Full Name, course name, and grade on the screen.

Q5. List the number of students in each course

Q6. Find the course that has most students

Q8. Change the course title of course 'COMP122' to 'COMP123'

Q9. Draw ERD for above tables student, course, and enrollment. Add teacher table as well in the ERD. Use crow-foot notation. You must indicate PKs and FKs. Use draw.io tool to draw ERD.