Question 1 Project Proposed Design Database Record Information Activities Organized School Q43802133
Question 1 A project is proposed to design a database to record information about activities organized in a school. Each activity has name, type, date, at least three students as participants, a supervisor and organized by exactly one department. An activity is identified by its name and date. A supervisor of a given activity is one of the staff in the school. Each staff in the school has a unique ID, name, telephone number and works for one department. A department has a unique name, unique ID and a head of department. Students can participate in many activities. For each student, student’s ID and name are recorded. A student may rate an activity, where a rating has a score of 0 to 10. The system needs to record the number of participants and the average rating for each activity. Design an ER diagram for the above scenario, showing all attributes, keys, cardinalities and participation constraints clearly. Note any unspecified requirements, and make appropriate assumptions to make the specification complete. Do not add any attributes of your own. Show transcribed image text Question 1 A project is proposed to design a database to record information about activities organized in a school. Each activity has name, type, date, at least three students as participants, a supervisor and organized by exactly one department. An activity is identified by its name and date. A supervisor of a given activity is one of the staff in the school. Each staff in the school has a unique ID, name, telephone number and works for one department. A department has a unique name, unique ID and a head of department. Students can participate in many activities. For each student, student’s ID and name are recorded. A student may rate an activity, where a rating has a score of 0 to 10. The system needs to record the number of participants and the average rating for each activity. Design an ER diagram for the above scenario, showing all attributes, keys, cardinalities and participation constraints clearly. Note any unspecified requirements, and make appropriate assumptions to make the specification complete. Do not add any attributes of your own.
Expert Answer
Answer to Question 1 A project is proposed to design a database to record information about activities organized in a school. Each…
OR