Question: 1 . Based on the provided requirements, create an ER Model and draw the corresponding ER Diagram. ( 2 0 % ) The ER Diagram
Based on the provided requirements, create an ER Model and draw the corresponding ER Diagram. The ER Diagram should include the following entities: COLLEGE, DEPARTMENT, STUDENT, TEACHER, COURSE.The relationships between the entities are as follows:
COLLEGE, DEPARTMENT: A college has multiple departments.
DEPARTMENT, STUDENT: A department has multiple students.
DEPARTMENT, TEACHER: A department has multiple teachers.
DEPARTMENT, COURSE: A department offers multiple courses.
STUDENT, COURSE: Each semester, every student must enroll in at least one course. A course records grades for the students.
TEACHER, COURSE: A teacher can teach multiple courses, and a course can be taught by multiple teachers.
Define the attributes for each entity and use a relationship representation refer to Figure for an exampleUse the cardinality symbols provided in Figure to represent relationships.
Write an SQL query to find the student ID student name, and course name for students who scored below in their courses.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
