Due in 8 hours
ecilaDo Problem #3 from the Problems section of the chapter 4. Remember to use Visio where necessary. Ignore question f; for question e use crows foot and ignore Chen; ignore question c and instead show all connectivity and cardinality. WARNING: the solution to the problem is identical to that of a professional team or an amateur league like NCAA . For example, your design should be able to find answers to the following questions: who plays on what team, who coaches which team, the score for each team per game, where the game was played, the number of points a player scored in a given game, the average number of rebounds for a player’s career, what position does a player play, etc. These are just some examples of questions. One or more relationships may not be explicitly mentioned because the DB designer is expected to know these relationships exist. Therefore, you should investigate the relationship between tables to identify this (or these) relationships that may not pop out at you. There is one relationship that most students miss and there are two the some students miss. Let’s see if you could find it/them. Make sure to include all of the necessary fields to store all of the information for each table.
Deliverables:
You are handing in one complete ERD where information from a, b,… e are represented in a single diagram. In summary, it is a DB design where all P-Keys, Fkeys, Fields, connectivities, and cardinalities are shown.
- 9 years ago
- 10
- Analyze Key Elements of a Work System
- FIN/571 Week 5 Team Assignment / Cost of Capital Video
- DB1
- Hospitality exam
- Financial Accounting Exam
- POL 310 Week 2 Assignment ( Air Quality and Climate Change as Integrated Policy ) ~ ( Latest Syllabus - Updated Dec, 2014 - Perfect Tutorial - Scored 100% )
- International Business (4)
- Finance Homework Help
- Business Research Response Paper
- You are the chief of payroll and need to forward a very important spreadsheet prepared by your junior payroll clerk to the chief financial officer concerning employees who are about to be released from employment. The spreadsheet shows the following field