Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Beautiful Intimate Gatherings (BiG) provides a variety of services for couples looking to get married Couples can discuss the various options with a BG wedding

image text in transcribed
image text in transcribed
Beautiful Intimate Gatherings (BiG) provides a variety of services for couples looking to get married Couples can discuss the various options with a BG wedding consultant, who will help them to choose the BIG services that meet their needs and their budget. When a couple contracts with BIG to provide wedding services that is referred to as a "wedding. For each wedding, the name of the wedding and the initial date that the couple contracts with BiG is recorded. The name of the wedding is usually the last names of the couple. For example, when Lisa Lopez and Antony Cruz contract with BIG, that would be named the "Lopez-Cruz Wedding. Every wedding must have at least two people associated with it the couple being married. Due to death or divorce, it is possible for a person to be a member in more than one wedding couple over time. For each person in the wedding couple, the person's name, address (street, city, state, zip code), phone number are recorded BiG offers many services such as, the marriage ceremony, reception, rehearsal dinners, dressmaking limousine, carriage, and others. For each service available, the name of the service, the type of service (ceremony, gathering, transportation, etc ) and a description are kept. Some services are provided by only one contractor, but for most services BiG has several contractors that can provide that service Some contractors can provide more than one service. A contractor must provide at least one service to be in the system. BiG will always have at least one contractor for every service. Different contractors can provide a given service in slightly different ways For esample, BIG has two contractors that can provide low-cost, basic catering for a reception and one contractor that can offer high-cost, fine dining for a reception. To help potential clients understand the differences in each contractor providing a service, a description of each contractor's capabMes providing each service are kept in the system Therefore, there is a description for the generic service, regardless of which contractor provides the service, plus a separate description of how the service is provided by each specific contractor. For each contractor, the contractor's company name, address, and phone number are recorded While some weddings involve only a single service, most couples contract with BIG to provide many services. The services that are provided for a particular wedding are organized into "events". Each event is associated with one and only one wedding Every wedding must include at least one event Some events involve several services but others involve only one service. For example, the Lopez-Cruz wedding includes three events: wedding ceremony reception, and after-reception transportation. The reception involves catering, flora, and valet parking services, while the after-reception transportation involves only limousine service. It is possible for BiG to offer a service that no couple has ever chosen but most services have been provided for many different weddings For each event, an event name is assigned, often with the help of the couple Forexample.hthe Lopez.cruz weddirthey chose toca the reception the "Post wedding Gala In addton to the event name, the begnrw date and time. ending date and time, and a description are entered into the system Every event must occur at some place, although the event can be entered into the system before the couple decides on a location for the Beautiful Intimate Gatherings (BiG) provides a variety of services for couples looking to get married Couples can discuss the various options with a BG wedding consultant, who will help them to choose the BIG services that meet their needs and their budget. When a couple contracts with BIG to provide wedding services that is referred to as a "wedding. For each wedding, the name of the wedding and the initial date that the couple contracts with BiG is recorded. The name of the wedding is usually the last names of the couple. For example, when Lisa Lopez and Antony Cruz contract with BIG, that would be named the "Lopez-Cruz Wedding. Every wedding must have at least two people associated with it the couple being married. Due to death or divorce, it is possible for a person to be a member in more than one wedding couple over time. For each person in the wedding couple, the person's name, address (street, city, state, zip code), phone number are recorded BiG offers many services such as, the marriage ceremony, reception, rehearsal dinners, dressmaking limousine, carriage, and others. For each service available, the name of the service, the type of service (ceremony, gathering, transportation, etc ) and a description are kept. Some services are provided by only one contractor, but for most services BiG has several contractors that can provide that service Some contractors can provide more than one service. A contractor must provide at least one service to be in the system. BiG will always have at least one contractor for every service. Different contractors can provide a given service in slightly different ways For esample, BIG has two contractors that can provide low-cost, basic catering for a reception and one contractor that can offer high-cost, fine dining for a reception. To help potential clients understand the differences in each contractor providing a service, a description of each contractor's capabMes providing each service are kept in the system Therefore, there is a description for the generic service, regardless of which contractor provides the service, plus a separate description of how the service is provided by each specific contractor. For each contractor, the contractor's company name, address, and phone number are recorded While some weddings involve only a single service, most couples contract with BIG to provide many services. The services that are provided for a particular wedding are organized into "events". Each event is associated with one and only one wedding Every wedding must include at least one event Some events involve several services but others involve only one service. For example, the Lopez-Cruz wedding includes three events: wedding ceremony reception, and after-reception transportation. The reception involves catering, flora, and valet parking services, while the after-reception transportation involves only limousine service. It is possible for BiG to offer a service that no couple has ever chosen but most services have been provided for many different weddings For each event, an event name is assigned, often with the help of the couple Forexample.hthe Lopez.cruz weddirthey chose toca the reception the "Post wedding Gala In addton to the event name, the begnrw date and time. ending date and time, and a description are entered into the system Every event must occur at some place, although the event can be entered into the system before the couple decides on a location for the

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books