Question: 1 . ( 2 0 points ) You are asked to design a database system for the NDHU Open Tennis tournament. We need to keep
points You are asked to design a database system for the NDHU Open Tennis tournament. We need to keep the information of several kinds of entities and relationships. There are human entities such as Players, Judges, Ball Boys and Girls BBGs All human entities have SSN name, gender and country. Players may or may not be seeded. Players can have different seeding positions on different types of matches. Judges also known as empires have ranking. BBGs have age. There are nonhuman entities such as Courts and Matches. Each court has courtID, name, location and capacity. Each match has a matchID, type, date, time, and court. There are five types of matches: Mens Singles, Womens Singles, Mens Doubles, Womens Doubles, and Mix Doubles. All Singles are between two players while Doubles are between two teams of two players each. Each type of matches is divided into seven rounds: Round Round of Quarterfinals, Semifinals, and Finals. With electronic linecalling system, each match needs only one Judge and exactly six BBGs Tennis scoring system is complex so we will skip it for the first version. However, we still need to keep the record of the result of each match the winners
a Draw an EREER diagram to model the above application. Indicate the cardinalities of relationships, as well as the weak entities if any For each entity, designate the primary keys; for weak entities, designate the identifying relationship type and owner.
b Transform the EREER diagram into a relational database schema. Specify all primary keys, foreign keys and the attribute pointed to by each foreign key.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
