Question: 1 . Based on the provided requirements, create an ER Model and draw the corresponding ER Diagram. ( 2 0 % ) The ER Diagram

1. Based on the provided requirements, create an ER Model and draw the corresponding ER Diagram. (20%)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 1 for an example).Use the cardinality symbols provided in Figure 2 to represent relationships.
2. Write an SQL query to find the student ID, student name, and course name for students who scored below 60 in their courses. (10%)
1 . Based on the provided requirements, create an

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!