List the tables with primary keys, attributes, and foreign keys that implement the following UML Class diagram given the accompanying list of attributes. Identify primary keys with PK and foreign keys with FK.
Attributes:Field IDField LocationField NameGame DateGame NumberLeague IDLeague NameLeague SportNumber of fields assigned to this leagueNumber of players on teamPlayer AgePlayer AveragePlayer IDPlayer NameScore of this team in this gameTeam IDTeam Name
What will be an ideal response?
Fields = Field ID (PK), Field Location, Field Name
Games = Game Number (PK), Field ID (FK), Game Date
Teams = Team ID (PK), League ID (FK), Team Name, Number of Players on this Team
Players = Player ID (PK), Player Name, Player Age, Player Average
Leagues = League ID (PK), League Name, League Sport
(Linking Tables)
Games - Teams = Game Number/Identifier + Team ID (PK), Score of this team in this game
Leagues - Fields = League ID + Field ID (PK), Number of fields assigned to this league
Players-Teams = Player ID + Team ID (PK)
You might also like to view...
Which of the following established the tone and the writer's relationship with the audience?
A) The introduction B) The body C) The conclusions and recommendations D) The close E) The work plan
A truck that cost $12,000 and on which $9,000 of accumulated depreciation has been recorded was disposed of on January 1 . Assume that the truck was traded for a similar truck having a price of $13,000, that an $1,800 trade-in was allowed, and that the balance was paid in cash. The amount of the gain or loss recognized on this transaction would be
a. a $1,200 loss. b. a $1,200 gain. c. no gain recognized. d. no loss recognized.
If the recognized losses resulting from involuntary conversions arising from casualty or theft exceed the recognized gains from such events (i.e., a net loss from the casualty), all of the involuntary conversions are treated as ordinary gains and losses.
Answer the following statement true (T) or false (F)
Accountants record ________
A) economic recessions B) estimated future transactions C) a transaction or any event that affects the financial position of the business and can be measured with faithful representation D) the $20,000 increase in value of a building that actually cost $50,000 but could be sold for $70,000