Create an ER diagram to represent the conceptual schema described by the Universe of Discourse. 1 Universe of Discourse The Commonwealth Games (CWG) is an international multi-sport event that involves athletes from the Commonwealth of Nations. These games were started in 1930 and take place every four years. In April this year, the 2018 Commonwealth Games will be hosted on the Gold Coast, welcoming over 6000 athletes and team officials from 70 Commonwealth nations and territories. The Games will be the largest sporting event to be staged in Australia this decade and will feature the largest integrated sports program in Commonwealth Games history. You have been tasked with the planning and development of a system for the effective management of the Games. The following description provides a specification for this system. There are a number of athletes who participate in the Commonwealth Games. When athletes are registered in the system, each athlete is given a unique athlete ID. Basic information about each athlete is also stored, including their full name (first name, middle name, last name), representing country, gender, date of birth, contact details (phone number(s), email, and emergency contact (name and phone number)). There are two categories of athletes, paraplegic and non-paraplegic. For paraplegic athletes, a list of additional medical details will also be stored. 2 Figure 1: Snapshot of an Event Schedule in the Games A number of details are kept for each country participating in the CWG. See https://www.gc2018.com/games/nations-and-territories for an indication of these details. There are over 20 different sports at the CWG (see https://www.gc2018.com/thesport ). Every sport also has a world record associated with it. Some are team sports and others are individual competitions. Some very talented athletes may also compete in multiple sports during the Games. When athletes are required to compete in teams, their team name is stored, which may be different from their country name. In addition to the basic information on the sports, information for the events associated with each sport during the games is also maintained. All events are hosted in at least one venue, and are identified by a unique event ID. They also have a name, description, and are held on a certain date and time (both the start and end times are recorded). Figure 1 shows an example of the schedule for Athletics Final to identify what data needs to be stored to create event schedules. This snapshot was available from www.gc2018.com/sport/athletics. Some events also have sponsors, that is, corporations, groups or individual people who support the event in exchange for advertising throughout the event. Sponsors are able to sponsor specific as well as multiple events. Every sponsor is uniquely named. Due to the different ways in which performance in events are recorded, each event can either be timed or scored. For timed events, the athletes/teams performance time is recorded; whereas for scored events, the score is recorded instead. Teams and individual athletes with the best performances will be awarded medals (gold, silver and bronze). Venues can host many different types of events. Every venue has a unique name within the Games. Each venue also has a maximum capacity and location. Each venue is either indoor or outdoor. For indoor venues, the facilities available (PA system, Data projection, and Internet) are Boolean values which are recorded. For outdoor venues, the dimensions (length and width) in meters are recorded instead. 3 In order to attend an event, customers need to buy tickets. Each ticket is identified by a unique ticket ID and has a price associated with it. Most tickets allow access to a single event; however, some tickets are multi-passes, allowing access to several events. All events (even free ones) require tickets in order to control crowd numbers. When a customer buys a ticket, their name and billing address is stored.