A bridal company called Petals would like to create a database for their clients and the weddings they coordinate. The weddings they would like to track have the following details: The date of the wedding, the address, the wedding’s start time, an automatically generated ID and the marriage officer that will preside over the wedding. In more detail they would like to track the theme name and descriptions of “themed” weddings and if the wedding is an “out of town” wedding they would like to track the hotel name that will put up the guests. It is possible foe petals to have a themed out of town wedding, as well in town un-themed weddings. Each wedding is catered by a caterer that has a caterer-id, name, various phone numbers and an email address. The caterer can be re-used to cater for several weddings, even if more than one wedding is on the same day. Petals would like all weddings to indicate the cater before the wedding is booked. Draw an Entity Relationship Diagram for the scenario above. Your diagram should include generalization/specialization.
Computer Science
A bridal company called Petals would like to create a
Draw an Entity Relationship Diagram for the scenario above. Your diagram should include generalization/specialization.
Step by step
Solved in 2 steps with 1 images
