logo

Database Design for Sports Teams

   

Added on  2019-09-22

4 Pages146 Words250 Views
 | 
 | 
 | 
DAT604 DATABASEDESIGN ANDIMPLEMENTATIONSOLUTIONSTUDENT
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
|6
|281
|128

Designing a Database for Food Delivery Service
|10
|990
|410

Database Design and Implementation
|14
|1070
|119

Enhanced Business Rules and ERDs
|7
|498
|238

Designing a Database for Food Delivery Service
|8
|646
|458

Data Structure and Algorithms - Tournament Players
|9
|2102
|311