Database Design for Sports Teams


Added on  2019-09-22

4 Pages146 Words250 Views
Database Design for Sports Teams_1

ASSUMPTIONSThe assumptions that have been made for the scenario are:1.Each coach will have a unique id.2.Each team will have a unique id to identify it3.Each player will have a unique id.4.Unique codes are given to identify cities and countries.5.Each player’s basic info will be stored.6.Each coach’s basic info will be stored.7. Each country has 1 or more cities8.Each city has one team and each team represents one city only.9.Each team has one or more players and each player plays for only one team10.Each team has one more or more coaches and each coach belongs to only one team. 11.Each team plays one or more games.
Database Design for Sports Teams_2

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Database Design for Business Concepts

Designing a Database for Food Delivery Service

Database Design and Implementation

Enhanced Business Rules and ERDs

Designing a Database for Food Delivery Service

Data Structure and Algorithms - Tournament Players