Databases Question

a. Using these assumptions and stating any others you need to make, list all the non-trivial functional dependencies for this relation

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

c. Is this relation in third normal form? if not find a 3NF lossless join decomposition of College that preserves dependencies.

d.Is the relation or the resulting set of the relations in BCNF? if not find a lossless join decomposition that in BCNF. identify any functional dependencies that are not preserved.

e. What tables would you actually implement? Explain any denormalization, omissions, or additions of attributes.

database to keep track of various aspects of the business. Clients may be individuals or businesses who make arrangements for events such as weddings corporate dinners, fundraisers, etc. The compan 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 client rents, such as historic mansions. Several of these off-site events can take place at the same time. Clients who rent the catering hall guarantee a minimum of 150 guests, but the hall can accommodate 200. Reservations for the hall are accepted up to two years in advance. Clients who provide their own space can have any number of guests. Reservations for off-site events are usually made seve 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 or elsewhere. Customers can choose the color of the linen. The firm has set menus that are identified by number. For a given menu number, there is one appetizer, one salad, one main course, and one dessert. (For example, menu number 10 may include shrimp cocktail, Caesar salad, prime rib, and chocolate mousse.) The firm quotes a total price for its services, based on the number of guests, the menu, the location, and intangible factors such as how busy they are on that database to keep track of various aspects of the business. Clients may be individuals or businesses who make arrangements for events such as weddings corporate dinners, fundraisers, etc. The compan 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 client rents, such as historic mansions. Several of these off-site events can take place at the same time. Clients who rent the catering hall guarantee a minimum of 150 guests, but the hall can accommodate 200. Reservations for the hall are accepted up to two years in advance. Clients who provide their own space can have any number of guests. Reservations for off-site events are usually made seve 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 or elsewhere. Customers can choose the color of the linen. The firm has set menus that are identified by number. For a given menu number, there is one appetizer, one salad, one main course, and one dessert. (For example, menu number 10 may include shrimp cocktail, Caesar salad, prime rib, and chocolate mousse.) The firm quotes a total price for its services, based on the number of guests, the menu, the location, and intangible factors such as how busy they are on that