A. Draw an Entity-Relationship Diagram using the Information…

Question Answered step-by-step A. Draw an Entity-Relationship Diagram using the Information… A. Draw an Entity-Relationship Diagram using the Information Engineering Style notation based on the business rules below: A salesperson may manage many other salespeople. A salesperson is managed by only one salespeople. A salesperson can be an agent for many customers. A customer is managed by one salespeople. A customer can place many orders. An order can be placed by one customer. An order lists many inventory items. An inventory item may be listed on many orders. An inventory item is assembled from many parts. A part may be assembled into many inventory items. Many employees assemble an inventory item from many parts. A supplier supplies many parts. A part may be supplied by many suppliers.Requirements:Identify the different entities with their respective relationships and cardinalities.No attributes needed. B. Draw an Entity-Relationship Diagram using the Information Engineering Style notation based on the business rules below: Suppose you are given the following requirements for a simple database for the National Hockey League (NHL):the NHL has many teams,each team has a name, a city, a coach, a captain, and a set of players,each player belongs to only one team,each player has a name, a position (such as left wing or goalie), a skill level, and a set of injury records,a team captain is also a player,a game is played between two teams (referred to as host_team and guest_team) and has a date (such as May 11th, 2017) and a score (such as 4 to 2).Requirements:Identify the different entities with their appropriate attributes.Identify the entities’ relationships.Identify the cardinalities relating to all relationships/entities.  Engineering & Technology Computer Science Share QuestionEmailCopy link Comments (0)