A bridal company called Lilacs would like a database for their clients and the weddings they coordinate. The weddings have the following details: wedding date, maximum budget, start time, an automatically generated ID and the marriage officer that will preside over the wedding. Lilacs does all types of weddings such as civil ceremonies, religious weddings, non-denominational, out of town, and themed weddings. 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 name of the hotel that will house the guests. It is possible for Lilacs to have a themed out of town wedding, as well as an in town un-themed wedding. 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. Lilacs would like all weddings to indicate the caterer before the wedding is booked. Each wedding occurs at a venue and hence details such as the name of the venue, capacity and address (street, town, city) is required. Bridal Partys information is also important. Each bridal party has a groom, groomsmen, bride and bridesmaids. Each Bridal Party member is uniquely identified by an email, and Lilacs would also like to store their name (firstname, lastname), gender, dob (in order to calculate age), address and mobile number. A bridal party member can be involved in other weddings; however, whenever any bridal party member participates in a wedding, Lilacs would like to know what position they played. Separately, no wedding should be booked unless one of the bridal party members acts as the owner of the wedding or main contact. Lilacs would also like to track their employees, such as name, employment date, address and job description. Whenever a bridal party is involved in a wedding, Lilacs would like to know the lead wedding planner who is responsible for the wedding as well as the employee assigned to the bridal party to assist in their dress preparation for the wedding such as their fitting and makeup etc.

Create an Entity Relationship Diagram (ERD) to show the conceptual design of the relational database. Create actual diagram

DATABASE MANAGEMENT