To record the competition of college teams in specific sports (such as swimming, rowing orwrestling) the following design has been proposed with tables COLLEGE, TEAM, and STUDENT:MSTUDENTMCOLLEGETEAMCOLLEGE (CollegelD, CollegeName, CollegeAddress, ContactPhone)TEAM (TeamID, TeamName, TeamColors)STUDENT (StudentID, FirstName, LastName, DateOfBirth, GraduationDate, TeamID, CollegelD)CollegelD foreign key to COLLEGETeamID foreign key to TEAMWe assume that each college has its own team, in each sport included in the database.Is this design correct, or some issues could arise? How would you correct the design?

With the given design following problems can arise: The sports played by the team is unknown. The…

Answered: To record the competition of college…

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

See similar textbooks

Related questions

Question

100%

To record the competition of college teams in specific sports (such as swimming, rowing or
wrestling) the following design has been proposed with tables COLLEGE, TEAM, and STUDENT:
M
STUDENT
M
COLLEGE
TEAM
COLLEGE (CollegelD, CollegeName, CollegeAddress, ContactPhone)
TEAM (TeamID, TeamName, TeamColors)
STUDENT (StudentID, FirstName, LastName, DateOfBirth, GraduationDate, TeamID, CollegelD)
CollegelD foreign key to COLLEGE
TeamID foreign key to TEAM
We assume that each college has its own team, in each sport included in the database.
Is this design correct, or some issues could arise? How would you correct the design?

Expert Solution

Step 1

With the given design following problems can arise:

The sports played by the team is unknown.
The result of the game (win or loss) is also unknown.

To prevent this from happening 2 new tables can be added as follows:

Sports (SportID, SportName, IndoorOutdoor, NumPlayersRequired, TeamID)
- `TeamID foreign key to Team
Result (GameID, LocationOfGame, Date, Duration, WinLoss, TeamID1, TeamID2)
- TeamID1 foreign key to Team
- TeamID2 foreign key to Team

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.

Similar questions