q:

a. A Basketball game is played between two TEAMS, the entity TEAM has TeamID(Identifier), TeamName, TeamCountry and Ranking as attributes. Each team can play any no of GAMES, the attributes of GAME are GameID(Identifier), DatePlayed, Score and TournamentName. TeamID and GameID are identifiers for TEAM and GAME respectively. A TEAM can employ any number of PLAYERS, the attributes of PLAYER are PlayerID(Identifier). PlayerName, PlayerHeight and Number_of_Games_Played. PlayerID is the identifier. Every time a match is played, winning date and vemie is recorded, if a PLAYER is employed contract date is recorded Identify and write the entities and attributes on relationship in the given box. Draw the Entity Relationship Diagram in the given box. Entities Attributes on Relationships Draw Entity Relationship Diagram: b. Write the Scenario for the below Entity Relationship Diagram. ISBNNO BTitle Pub_Year GSM Author PUBLISHER Publish BOOK Price PubName Borrow_Date Borrow 1 PUDID Stulb Address STUDENT SName Mobile Scenario: