Can anyone answer these questions using the information below after the questions. thank You.

a. is the relation of the 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

b. what tables would you actually implement? explain any denormalization, omissions, or additions of attributes.

the owner of a catering company wants a database to keep track of various aspects of the business. Clients may be individuals or businesses who make arrangements for events such as weddings, dances, corporate dinners, 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 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 must guarantee a minimum of 150 guests, but the hall can accommodate up to 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 several months in advance. the firm provides the food, table settings, 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. 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 date. the firm can also contract for floral arrangements, musicians, entertainers, and photographers, if the client requests. the client pays the catering company, which then pays the contractor. the price charged the customer for each of these is always 10% above the cost to the catering company. assume names are unique. also, assume musicians and entertainers provide only one type of music. Assume the following attributes have been identified: clientName, cFName, cPhone, cCity, cState, cZip, eventDate, eventStartTime, eventDuration, eventType, numberGuests, locationName, locationStreet, locationCity, locationState, locationZip, linenColorRequested, numberWaiters, numberBartenders, totalPrice, floristName, floristPhone, floristCost, floristPrice, musicContact, musicContactPhone, musicType, musicCost, musicPrice, entertainerName, entertainerPhone, entertainerType, entertainerCost, entertainerPrice, photgrapherName, photgrapherPhone, photgrapherCost, photgrapherPrice, menuNumberChosen, menuAppetizer, menuSalad, menuMain, menuDessert.