CPE 210: DATABASE MANAGEMENT SYSTEM ASSIGNMENT-I Construct an E-R diagram for the registrar’s office Document all assumption that you make about the A King Khalid University ‘s office maintained the following entities a Course, including number, title, credit, syllabus, and prerequis Course offering dige mber, year, semest e r s c) Students, including de-idame, and program and c h ing defic e re department ince and grade warded to tradents in accounthey a lyde Further, the commento re for the The dusch Apo t he Ape in which the p lace. The other acha m the A delity. The A by The fly the Themed by the fre e deprimidwive . Passer’s book find e s The power CPE 210: DATABASE MANAGEMENT SYSTEM ASSIGNMENT-1 1. Construct an E-R diagram for the registrar’s office. Document all assumptions that you make about the mapping constraints. A King Khalid University registrar’s office maintains data about the following entities: (a) Courses, including number, title, credits, syllabus, and prerequisites; (b) Course offerings, including course number, year, semester, section number, instructor(s), timings, and classroom; (c) Students, including student-id, name, and program; and (d) Instructors, including identification number, name, department, and title. Further, the enrollment of students in courses and grades awarded to students in each course they are enrolled for must be appropriately modeled. 2) Design an ER diagram for an airline reservation system. Document all assumptions that you make about the mapping constraints. The database represents each Airport, keeping its unique Airport Code, the Airport Name, and the City and country in which the Airport is located. The airplane flies from / to an Airport. Each airplane has a unique registration number, the Airline name, model, capacity. The Airport is identified by number, name, city, country. The airplanes fly flights. The flights are characterized by flight number, from, to, departure date, departure time, arrival date, arrival time. Passenger’s book flight and get ticket number, seat number, class. The passengers attributes are ID, given name, surname, email, mobile. His book was sent

order now