Additional info as requested: a.using these assumptions, list all the non-trivia

Question

Additional info as requested:

a.using these assumptions, list all the non-trivial functional dependencies for this relation.

b.what are the candidate keys for this relation? Identify the primary key

c. is the relation in third normal form? if not, find a 3NF lossless join decomposition that preserves dependencies

d. is the relation of resulting set of relations in Boyce-Codd Normal form? if not, find a lossless join decomposition that is in BCNF. identify any functional dependencies that are not preserved

a database to keep track of various aspects of the business. Clients be individuals businesses who make arrangements for events such as weddings, dances, corporate dinners, fundraisers, etc. The Company owns a catering hall in which only one event can take place at a time In addition, clients can use the services of the company to cater events at their homes, places of business, or places that the rents, such as historic mansions. Several of these off-site even can take place at the same time. Clients who rent the catering hall must guarantee a minimum of 150 guests, but the hall can accommodate up to 200. Reservations for the hall are accepted up to two yearsin advance. Clients who provide their own space can have any number of guests. Reservations for off-site events are usually made several months in advance The firm provides the food, table settings (dishes, silverware, and glassware), linens, waiters, and bartenders for the event, regardless of whether it is in the catering hall elsewhere, customers can choose the color of the linen. Thefirm has set menus that are identified by number. For a given men number dessert there is one appetizer, one salad, one main course, and on (For example, menu number 10 cocktail Caesar may include shrimp a tob salad, prime rib, and chocolate mousse.) The firm quote price for its services, based on the number of guests, the on location, and intangible factors such as how busy they are

Explanation / Answer

a. non trivial FD - 1. client-event -->event, where event is subset of client but client is not subset of event thats why client is non trivial. 2. event- location--> location, where location is subset of event but event is not subset of location thats why event is non trivial for this funstion.3.florist, music menu, even type, entertainer, photographer, waiter, bartender all are subset of event but event is not subset for all these thats why event is non trivial.4. menu dishes are subset of menu but menu is not subset of them thatswhy menu is non trivial for dishes.

b.candidate keys are client, event, florist, music, photographer, menu. And primary key for everything is phone.

c.lossless join decomposition preservs dependencies are client is decomposition of name, phone,event, etc information.

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.