Answer to Question #173379 in Databases | SQL | Oracle | MS Access for kojo

Question

•Consider the following scenario

•A company provides catering services for clients who need special-occasion, celebratory dinners. For each dinner, a number of dishes are to be offered. The dinner will be held at a venue. The company will provide staff to serve meals at the venue.

•The company needs a database to store data related to this business activity

–Identify a list of entities

–Identify pairs of entities where a direct relationship exist

–For each pair of relationship draw the entity relationship diagram justifying the choice of cardinalities.

Answer 1

The answer to your question is provided in the image: