Question: 3. You have been asked to develop a preliminary ER. diagram for the final exams of information systems courses. You discover the following entity types

 3. You have been asked to develop a preliminary ER. diagram

3. You have been asked to develop a preliminary ER. diagram for the final exams of information systems courses. You discover the following entity types that should be included: . EXAM PERIOD: The period that all final exams are conducted. Identifier is the start date, including Month, Day, and Year. Another attribute is the end date, including Month, Day, and Year. EXAM: Identifier is the Exam_ID. Other attributes include Exam_date, which consists of the following: Month, Day, Year, and Time; Exam_location, which consists of the following: Building_Name, Room_Number, and Room_Capacity. Each exam can have one or more Exam_location. COURSE: Courses that the exams 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. EXAM INVIGILATOR: people who will invigilate exams. Identifier is Invigilator_ID. Another attribute is Invigilator_Name. STUDENT: students who will take the exam. Identifier is Student_ID. Other attributes are Student_Name, Student_Major. Student can have more than one major. Students can take multiple exams. INSTRUCTOR: instructors of courses. Instructor is identified by instructor_ID. Other attributes 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 exam period schedules one or more exams. A particular exam is scheduled for only one exam period. A course can schedule no or multiple exams, while one specific exam can only be assigned to one course. Each exam can have one or more invigilators, and one invigilator can invigilate one or more exams. Each exam needs one or more students to take, and a student can take one or more exams. Draw an ER. diagram to represent what you have discovered

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 Mathematics Questions!