Question

Question 4. ER model (5 points). You are asked to design the ER diagram for a database to manage data for athletes athletic game. Requirements are as follows: Each participating team has a name and a manager. Each athlete has a unique athlete ID, and is also described by first name and last name, gender and age. A team has many athletes but an athlete only belongs to one team. Each sport has a unique code and some sport name. A sport usually has one or more events. For example, "Men 50 metre Freestyle" is a swimming event and "4 x 100 metre Mixed Medley Relay is another swimming event. An athlete may compete in several sport events and an event usually have many competing athletes. The result for an athlete competing in an event is also kept, together with his/her medal if any According to the given description, state any a Relationship (ER) diagram for the database. You must represent entities, relationships and their attributes, and all applicable constraints in your ER diagram. Explain any concepts in the description that cannot be expressed in the ER diagram. · Your ER diagram must only use the UML class diagram notations from the lecture notes. you make and construct an Entity You are encouraged to use LucidChart to complete your ER diagram. You can use create a free student account at: http://www.lucidchart.com/

Answer 1

ER Diagram

sport name sport id event id team manager eam name event name Sport has Event Team first name last_name athlete id ((athlete_nameathlete_gender athlete_age participate Athlete has sport_result tlete_medal