The jobs are flowing thick and fast, and you get a 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 identified the following entities: Match, Tourney, Table, Category, Player, Club. No others. Below is the info you were previously given. Use it to infer which entities have relationships with each other, as well as the types of those relationships, and constraints if any. All that you should submit is a set of the relevant business rules. Once again, remember that entities don't necessarily directly connect, unless the information collected specifies that they are connected. Tourney Tourney Start Date Day 101 02/03/2012 1 101 02/03/2012 1 101 02/03/2012 1 101 02/03/2012 105 105 105 13/05/2012 13/05/2012 13/05/2012 2 1 1 1 Time Player(s) Player(s) Match Slot Player(s) Player(s) 2 1 Club Club 1 2 Category 1 J Scott F Florr Singles Men Durbanville Bellville 2 F Florr J Hicks R Cook Doubles 1 L Lorien W Periperi Women Edgemead Durbanville J Hicks W Periperi 3 1 2 1 D Duncan Singles Men Bellville Edgemead P Freds J Rodr Y Yuda J Scott J Hicks P Plor Singles Women Singles Men Milnerton Durbanville Singles Men Goodwood Edgemead Singles Women Milnerton Table Bellville T1 Edgemead Durbanville T3 T2 T1 T1 T1 T4
The jobs are flowing thick and fast, and you get a 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 identified the following entities: Match, Tourney, Table, Category, Player, Club. No others. Below is the info you were previously given. Use it to infer which entities have relationships with each other, as well as the types of those relationships, and constraints if any. All that you should submit is a set of the relevant business rules. Once again, remember that entities don't necessarily directly connect, unless the information collected specifies that they are connected. Tourney Tourney Start Date Day 101 02/03/2012 1 101 02/03/2012 1 101 02/03/2012 1 101 02/03/2012 105 105 105 13/05/2012 13/05/2012 13/05/2012 2 1 1 1 Time Player(s) Player(s) Match Slot Player(s) Player(s) 2 1 Club Club 1 2 Category 1 J Scott F Florr Singles Men Durbanville Bellville 2 F Florr J Hicks R Cook Doubles 1 L Lorien W Periperi Women Edgemead Durbanville J Hicks W Periperi 3 1 2 1 D Duncan Singles Men Bellville Edgemead P Freds J Rodr Y Yuda J Scott J Hicks P Plor Singles Women Singles Men Milnerton Durbanville Singles Men Goodwood Edgemead Singles Women Milnerton Table Bellville T1 Edgemead Durbanville T3 T2 T1 T1 T1 T4
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
Related questions
Question
Transcribed Image Text:The jobs are flowing thick and fast, and you get a 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 identified the following entities: Match, Tourney, Table, Category, Player, Club. No
others.
Below is the info you were previously given. Use it to infer which entities have relationships with
each other, as well as the types of those relationships, and constraints if any.
All that you should submit is a set of the relevant business rules. Once again, remember
that entities don't necessarily directly connect, unless the information collected specifies that
they are connected.
Tourney
Tourney Start Date
Day
101 02/03/2012 1
101 02/03/2012 1
101 02/03/2012 1
101 02/03/2012
105
105
105
13/05/2012
13/05/2012
13/05/2012
2
1
1
1
Time Player(s) Player(s) Match
Slot
Player(s) Player(s) 2
1 Club
Club
1
2 Category
1
J Scott F Florr Singles Men Durbanville Bellville
2
F Florr
J Hicks R Cook
Doubles
1
L Lorien W Periperi Women Edgemead Durbanville
J Hicks W Periperi
3
1
2
1
D Duncan Singles Men Bellville Edgemead
P Freds J Rodr
Y Yuda
J Scott
J Hicks
P Plor
Singles
Women
Singles Men Milnerton Durbanville
Singles Men Goodwood
Edgemead
Singles
Women
Milnerton
Table
Bellville
T1
Edgemead Durbanville T3
T2
T1
T1
T1
T4
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 1 images
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.Recommended textbooks for you
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education