Question: Question 1 . [ 2 3 points ] A system is to be created to manage the calendar of campus events. Each event has a

Question 1.[23 points] A system is to be created to manage the calendar of campus events. Each event has a descriptive name and has a single start date and time (when the event begins) and ending date and time. Each event can be classified as sports, social, religious or academic. Depending on the classification, specific event information is stored. Each event takes place at a specific venue on campus. A venue is a sports area (such as an athletic field), a lecture hall, a conference hall, or a public space. The venue information differs depending on the type of venue. Each event is sponsored by an academic department. Each academic department has a person responsible for the event. a. Design an EER diagram for the following database. Your diagram should have all the needed details. You may make any reasonable assumptions but you must state them clearly. b. Convert the EER model to a set of relations using EER to Relational mapping rules.

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!