Question

Given the following business rules, create an entity relationship diagram.

A booking is placed for one or more travelers. e.g. A mom may place a booking for herself and her two kids. A traveler may place many bookings. e.g. you may place many bookings over the years.

Requirements: draw the ERD with crow-foot notation Provide at least two attributes for each entity identify the PK for each entity Label the FK for each entity determine the relationship type with the cardinalities between entities.

Answer 1

According to the given business rules, the entities are as follows:-

Treveler

Booking

The relationship among entities is as follows:-

Treveler placed Bookings

The cardinality of the entities in the relationship is as follows:-

1 treveler can placed n Bookings and 1 Booking can be placed by n treveler, therefore the cardinality in the relationship Treveler placed Booking is m:n.

The ER diagram in crow's foot notation is as follows:-

In above ER diagram the primary key is represented by * and foreign key by (fk)