Following on your BIG break to make a database for an… organization that organizes table tennis tournaments (also known as “Tourney”s) at their premises on behalf of clubs, you’ve written down the business rules as follows: One Match belongs to One Tourney, and not none.One Tourney has Many Matches, at least one and a maximum of 128. One Match takes place on One Table, and not none.One Table is used in Many Matches, and possibly none. One Match belongs to one Category, and not none.One Category appears in Many Matches, and possibly none and a max of 32. One Match involves Many Players, minimum 2 and maximum 4.One Player plays Many Matches, and possibly none. You have also been given a small sample of their records (which is not in the least in relational format), which may prove useful. It is below. Match NumberTourneyTourney Start DateDayTime Slot In DayPlayer Names(Team 1)Player Names(Team 2) Player IDs (Team 1)Player IDs(Team 2)Match CategoryMatch Category DescTableTable Name54710102-03-1211J ScottF Florr5026071Singles MenT1Ebenezer54810102-03-1212F FlorrD Duncan6078351Singles MenT2Killarney54910102-03-1211J HicksR Cook2253114Doubles WomenT1EbenezerL LorienW Periperi31678055010102-03-1223J HicksW Periperi2257803Singles WomenT3Sobum.............78010513-05-1211P FredsJ Rodr1414201Singles MenT1Ebenezer78110513-05-1212J ScottY Yuda50210541Singles MenT1Ebenezer78210513-05-1211J HicksW Periperi2257803Singles WomenT4Glons Also note that:“Tourney” is a unique number given to each specific tourney.“Match number” is a unique number given to each match.“Day” refers to the day of the tourney in which a specific match takes place, as counted from the start of the tourney i.e. 1 means a match takes place on day 1 of the tourney, 2 means a match takes place on day 2 of the tourney etc.“Time Slot in Day” refers to the time slot of a specific day in which a match takes place e.g. 2 means that the specific match takes place in time slot 2. The actual time is irrelevant.“Player ID” is a unique number given to each player.“Match Category” is a unique number assigned to each category.“Table” is a unique code given to each table and it always starts with the letter “T”. Use these business rules to draw a nice neat ERD. Please note that if you encounter any Many-to-Many relationships in the business rules, you will need to first break down and resolve these relationships into a set of business rules in which a bridge entity is created as discussed in class. Clearly show your new business rules if this should be the case.

Below are entity relationship tables and ER diagrams that describe the relationships between…

Answered: Following on your BIG break to make a…

A Guide to SQL

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter2: Database Design Fundamentals

Section: Chapter Questions

Problem 11RQ

See similar textbooks

Related questions

Question

Following on your BIG break to make a database for an… organization that organizes table tennis tournaments (also known as “Tourney”s) at their premises on behalf of clubs, you’ve written down the business rules as follows:

One Match belongs to One Tourney, and not none.
One Tourney has Many Matches, at least one and a maximum of 128.

One Match takes place on One Table, and not none.
One Table is used in Many Matches, and possibly none.

One Match belongs to one Category, and not none.
One Category appears in Many Matches, and possibly none and a max of 32.

One Match involves Many Players, minimum 2 and maximum 4.
One Player plays Many Matches, and possibly none.

You have also been given a small sample of their records (which is not in the least in relational format), which may prove useful. It is below.

Match Number	Tourney	Tourney Start Date	Day	Time Slot In Day	Player Names (Team 1)	Player Names (Team 2)	Player IDs (Team 1)	Player IDs (Team 2)	Match Category	Match Category Desc	Table	Table Name
547	101	02-03-12	1	1	J Scott	F Florr	502	607	1	Singles Men	T1	Ebenezer
548	101	02-03-12	1	2	F Florr	D Duncan	607	835	1	Singles Men	T2	Killarney
549	101	02-03-12	1	1	J Hicks	R Cook	225	311	4	Doubles Women	T1	Ebenezer
L Lorien	W Periperi	316	780
550	101	02-03-12	2	3	J Hicks	W Periperi	225	780	3	Singles Women	T3	Sobum
.	.	.	.	.	.	.	.	.	.	.	.	.
780	105	13-05-12	1	1	P Freds	J Rodr	141	420	1	Singles Men	T1	Ebenezer
781	105	13-05-12	1	2	J Scott	Y Yuda	502	1054	1	Singles Men	T1	Ebenezer
782	105	13-05-12	1	1	J Hicks	W Periperi	225	780	3	Singles Women	T4	Glons

Also note that:

“Tourney” is a unique number given to each specific tourney.
“Match number” is a unique number given to each match.
“Day” refers to the day of the tourney in which a specific match takes place, as counted from the start of the tourney i.e. 1 means a match takes place on day 1 of the tourney, 2 means a match takes place on day 2 of the tourney etc.
“Time Slot in Day” refers to the time slot of a specific day in which a match takes place e.g. 2 means that the specific match takes place in time slot 2. The actual time is irrelevant.
“Player ID” is a unique number given to each player.
“Match Category” is a unique number assigned to each category.
“Table” is a unique code given to each table and it always starts with the letter “T”.

Use these business rules to draw a nice neat ERD. Please note that if you encounter any Many-to-Many relationships in the business rules, you will need to first break down and resolve these relationships into a set of business rules in which a bridge entity is created as discussed in class. Clearly show your new business rules if this should be the case.

Expert Solution

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.