Question: i need a drawn tables . not sql queries or explanation A soccer team has 22 players. Every player has a rating, namely Beginner, Intermediate

i need a drawn tables . not sql queries or explanation

A soccer team has 22 players. Every player has a rating, namely Beginner, Intermediate and Advanced. Rating levels have dedicated skill levels. For Beginner level, 1, 2 and 3; for Intermediate level, 4,5,6,7 and for Advanced level, 8,9 and 10 are skill levels. We need to store Teams (name, city, players, total points in the season and standing in the season), Players (name, surname, number, scored goal in the season, rating level and skill level) and Matches (date, time, place, teams, winner and score) in a database. 1. Araw the tables with attributes by highlighting primary keys. If you think that there are more tables needed because of normalization, create and provide justification. Show all of the functional dependencies. Start from non-normalized form and progress towards 3NF form for better design. Draw the tables for INF, 2NF and 3NF

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Please DO NOT copy and paste the same answer on Chegg because it is WRONG!! A soccer team has 22 players. Every player has a rating, namely Beginner, Intermediate and Advanced. Rating levels have...

Term Assignment A soccer team has 22 players. Every player has a rating, namely Beginner, Intermediate and Advanced. Rating levels have dedicated skill levels. For Beginner level, 1, 2 and 3 ; for...

Please also draw diagrams when you answer. A soccer team has 22 players. Every player has a rating, namely Beginner, Intermediate and Advanced. Rating levels have dedicated skill levels. For Beginner...

please do the second question by drawing the table A soccer team has 22 players. Every player has a rating, namely Beginner, Intermediate and Advanced. Rating levels have dedicated skill levels. For...

SEN235 INTRODUCTION TO DATABASE SYSTEMS A soccer team has 22 players. Every player has a rating, namely Beginner, Intermediate and Advanced. Rating levels have dedicated skill levels. For Beginner...

please Draw the E-R diagram relationship on a paper by hand and take picture after that A soccer team has 22 players. Every player has a rating, namely Beginner, Intermediate and Advanced. Rating...

Write a detailed paper on the Theory of Offensive Realism and the Rise of China.

A 1 Ci source of radiation is a significant source. 238U is an alpha emitter. What mass of 238U has an activity of 2 Ci? Express your answer to two significant figures and include the appropriate...

You just bought equipment from Blue square hardware. You will receive a cash rebate of $ 2 7 0 0 from Blue square hardware in 3 years, pay $ 2 6 7 0 0 to blue square hardware in 9 years, receive a...

Capacity is _________________. A. Impossible if a party is at all intoxicated. B. Assumed for all minors over the age of 12. C. Not present in a party adjudged insane. D. Less important than legality.

2-8 Fulbert Timber Merchants in Brixton, UK features a large selection of building supplies, including timber, fencing and decking, mouldings, hardwood flooring, sheet materials, windows, doors,...

2-7 Use the Time/Space Collaboration and Social Tool Matrix to classify the collaboration and social technologies used by BASF..

2-6 Identify the steps that are performed in the process of selecting and checking out a book from your college library and the information that flows among these activities. Diagram the process. Are...