Question

S3. Design an E-R diagram that stores the information of your favorite team. You must keep the matches played, the scores obtained in each match, the players that played in each match, and the statistics that each player has for each match. Statistics summaries should be modeled as derived attributes. S4. Draw the Asset-Relationship Chart of the tables given below. Order Inventory Control Order No Material Order amount Material Kod Min Order Max Order S0001 BM0002 2 BM0001 10 25 S0002 BM0003 5 BM0002 10 20 SOD03 BM0003 1 BM0003 10 30 S0004 BM0004 4 BM0004 5 20 SOD05 BM0001 3 BMCCOS 5 10

Answer 1

The entity Relationship Diagram is shown below : It is having many-to-many relationship since single player can play multiple matches and a single match can be played by multiple players.

There are 3 entities (match , match_player, player ) with attributes as follows:

Match

• ID ( primary key)
• MatchDate
• Stadium
• Opponent
• Own_Score
• Opponent_Score

Match_Player

• Match_ID ( primary key)
• Player_ID( primary key)
• Score

Match_ID and Player_ID is composite Primary key here

Player

• ID( primary key)
• Name
• Age
• Season_score<<derived>>