Describe Some Typical Pairs Of Entities

Describe some typical pairs of entities that you think might be common in business, and describe their relationships, whether many-to-many, one-to-many, many-to-one, or one-to-one and be sure to explain why you think that a particular relationship applies to that pair of entities. Cite your sources.Solutiuon :Typical pairs of entities that you think might be common in business:Let ‘s examine a portion of a database design for a car dealership. We will focus on car maintenance program:A CUSTOMER may own one or more cars. So there is one –to-many relationship between entities CUSTOMER and CAR.A CAR may require maintenance, thus causing the car data to be entered into a maintenance log. If the car requires maintenance , this log , named maintenance log is written before the car is put in the maintenance shop. This log allows the car dealer to track the maintenance summary for any car. So there is one –to-many relationship between entities CAR and MAINT_LOG.Each MAINT_LOG contains at least one repair entry in MAINT_LINE. The MAINT_LOG and MAINT_LINE entities will generate the car dealership’s invoice contents. In this case one-to-many relationship exist between MAINT_LOG and MAINT_LINE.Each MAINT_LINE may reference