Question: 3. You have been asked to develop a preliminary ER diagram for the final quiz of information systems courses. You discover the following entity types
3. You have been asked to develop a preliminary ER diagram for the final quiz of information systems courses. You discover the following entity types that should be included: quiz PERIOD: The period that all final quiz are conducted. Identifier is the start date, including Month, Day, and Year. Another attribute is the end date, including Month, Day, and Year. quiz: Identifier is the quiz_ID. Other attributes include quiz_date, which consists of the following: Month, Day, Year, and Time; quiz_location, which consists of the following: Building_Name, Room_Number, and Room_Capacity. Each quiz can have one or more quiz_location. COURSE: Courses that the quiz are held for. Identifier is Course_ID. Course has an attribute: Course_Name. Another attribute is Section, which includes Section_Number, and Section_student_number. Many, but not all, courses have multiple sections. A course can have many instructors. quiz INVIGILATOR: people who will invigilate quiz. Identifier is Invigilator_ID. Another attribute is Invigilator_Name. STUDENT: students who will take the quiz. Identifier is Student_ID. Other attributes are Student_Name, Student_Major. Student can have more than one major. Students can take multiple quiz. INSTRUCTOR: instructors of courses. Instructor is identified by instructor_ID. Other attrtibutes are Instructor_Name, Instructor_Gender, Instructor_Title, Instructor_Major. Instructor can have more than one title and can teach multiple courses. Instructor can only have one major. During further discussions you discover the following: An quiz period schedules one or more quiz. A particular quiz is scheduled for only one quiz period. A course can schedule no or multiple quiz, while one specific quiz can only be assigned to one course. Each quiz can have one or more invigilators, and one invigilator can invigilate one or more quiz. Each quiz needs one or more students to take, and a student can take one or more quiz. Draw an ER diagram to represent what you have discovered.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
