database

undefined

Name: ID: Based on you reviews 3, you requested to answer the following questions : Part I: The college database stores details about university students, courses, the semester a student took a particular course and what degree program each student is enrolled in. Part III - Assume we have the following application that models soccer teams, the games they play, and the players in each team. In the design, we want to capture the following: . We have a set of teams, each team has an ID (unique identifier), name, main stadium, and to which city this team belongs. Each team has many players, and each player belongs to one team. Each player has a number (unique identifier), name, DoB. start year, and shirt number that he uses. Teams play matches, in each match there is a host team and a guest team. The match takes place in the stadium of the host team. For each match we need to keep track of the following: o The date on which the game is played o The final result of the match o The players participated in the match. For each player, we want to keer, how many goals he scored, whether or not he took yellow card, and whether or not he took red card, and the number of played matches. Design an ER diagram to capture the above requirements. State any assumptions you have that affects your design. Make sure cardinalities and primary keys are cleared. The college has many departments. Each department has name and number. Consider the following requirements list: . Part IV: The World Health Organization maintains a set of data on the global situation for Covid-19, Consider the following requirements list: The department offers one or more programs. A program is made up of one or more courses. A student must enrol in a program. A student takes the courses that are part of her program. A program has a name, a program identifier, the total credit points required to graduate, and the year it commenced. A course has a name, a course identifier, a credit point value, and the year it commenced. Student has name, a surname, a student identifier, a date of birth, and the year they first enrolled Draw The ER diagram that derived from the above requirements. State any assumptions you have that affects your design. Make sure cardinalities and primary keys are cleared 1-The global situation can be described by Region D. TypeOfCases), The Type of cases consists of these values Confirmed Cases. Death Cases. ActiveCases. Recover Cases). 2- The region must send weakly report to the global situation. The region has (Unique ID, Covid- 19ActiveCases, Covid-19DeathCases, Covid-19confirmed Cases, Covid-19Recovery Cases, Alarmo Danger), The Alarmo Danger has several values( Green, Yellow, Red). Part II: 3-The World Health Organization Funds Global Research Center, this center can be described by (unique Center-ID, Center Name. IyRestResearch Fund Amount). 4-This Global Research Center provides the Region with the updated information of covid-19 Draw The ER diagram that derived from the above requirements. State any assumptions you have that affects your design, Make sure of cardinalities ratio, participation constraints and primary keys are cleared. (In need you can use the back of the exam pages). The flight database stores details about an airline's fleet, flights, and seat bookings. . Consider the following requirements list: The airline has one or more airplanes. An airplane has a model number, a unique registration number, and the capacity to take one or more passengers. An airplane flight has a unique flight number, a departure airport, a destination airport, a departure date and time, and an arrival date and time. . Each flight is carried out by a single airplane. A passenger has given names, a surname, and a unique email address. A passenger can book a seat on a flight. Draw The ER diagram that derived from the above requirements. State any assumptions you have that affects your design Make sure cardinalities and primary keys are cleared