Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Question 5 During the first meeting of the preliminary investigation, there were parts of the database which were not included or discussed because of time

image text in transcribed

Question 5 During the first meeting of the preliminary investigation, there were parts of the database which were not included or discussed because of time constraints. Since the games will play more than once a year. It is said that different sports (e.g. Soccer, Swimming, athletics, etc) will be involved, and each sport will have a responsible manager who will ensure participation from individual or teams. Sports will have many events (e.g. Boys under 15, Butterfly, 800m, etc), T. Lebovak Assessor: Moderator: and each event will have an organiser who will ensure smooth organisation of events. Event organiser can organise maximum of three related events per sports games. tblSport (SportName, SportManager, Phone, DOB, Email, (EventID, EventName, EventOrganiser, Phone, DOB, Email, Results)) *DOB = Date of Birth 5. Apply normalisation concepts to normalise tblsport so that it qualifies to be on the 3NF. (Indicate all steps clearly to avoid losing marks). (20)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database And Expert Systems Applications 31st International Conference Dexa 2020 Bratislava Slovakia September 14 17 2020 Proceedings Part 1 Lncs 12391

Authors: Sven Hartmann ,Josef Kung ,Gabriele Kotsis ,A Min Tjoa ,Ismail Khalil

1st Edition

303059002X, 978-3030590024

More Books

Students also viewed these Databases questions

Question

Understand the concept and implementation of a confusion matrix

Answered: 1 week ago

Question

Explain the importance of effective communication

Answered: 1 week ago

Question

* What is the importance of soil testing in civil engineering?

Answered: 1 week ago

Question

Explain the concept of shear force and bending moment in beams.

Answered: 1 week ago