Please Answer these two questions especially schema normalized to 3rd Normal Form.

an EER diagram modeling the Best Dream hotel business; a schema based off of the EER diagram that has been normalized to 3NF; Objectives 1. conceptual database design 2. logical database design 3. normalization to 3NF The Best Dreams hotel chain has hired you to design their database to begin optimizing their operations. The following is a data dictionary recorded through interviews by a database designer with the owners of managing Best Dreams, their employees at various locations, and clients that make reservations. Entity Name Aliases Occurrence Resort Hotel A location, with an address, has at least 10 and at most 50 staff Locations owned operating it with at least 5 or more rooms available. The locations by the hotel available are across North America. chain Best Dreams where clients are able to stay. Staff Employee, There are three types of staff at each resort: supervisor, clerk, and The general type Supervisor, attendant. of person Clerk, One supervisor at each location manages up to 50 other staff, and employed by Best Attendant orders furnishings for the rooms (that are not linens) when needed. Dreams. A clerk registers clients that request reservations for a room at some future period of time, with a check-in date and a check-out date. Guests may check in as early as 2 pm on their check-in date or later. Guests must check out by 11 am on their check-out date or earlier. A clerk can also add charges with a comment to log additional re- quests by a guest during their stay toward their total bill. An attendant cleans rooms. Rooms Suite, Unit A room can have 1 to 2 beds of different sizes (beds must match size Units at resorts in each room) for clients to Junior: couch, TV, coffee maker, bathroom. reserve and stay Residential: (in addition to Junior amenities) mini-fridge, snack-bar, in for a period of desk, and recliner. time. Presidential: (in addition to Residential amenities) king-sized beds, kitchinette, and attached suite with study. Each room has reservations made to it over time that cannot overlap with more than one reservation during any time period. Furnishing Items of furniture and decorations in rooms. Clients People that reserve and stay in Best dream hotel rooms. Furniture, Bed, desk, mini-fridge, fridge, stove, coffee-maker, lamps, blankets, Appliances, pillows, sheets, TV, phone. Linens, Decor Each item also should have an age and condition recorded to keep track of when it should be replaced. Note that linens (blankets, pillows, sheets) are always laundered and provided every day by attendants and are logged in bulk for the entire resort instead of logged by room. Linens can be requested by guests, which add to their bill. Traveller, A client could consist of at least one adult, and some number of Visitor, children that stay in one room together over a period of time. Guest, They make the reservation at some date previous to or on the check- Group in date. They will then check in with a credit card and a license plate number at the front desk with a clerk. When they check in, they are given a keycard for access to their room and on the check-out date they give the keycard back. Registration Made by a client via web, or over phone to front desk, on some date before check-in at an agreed price. They must specify the number of adults and the number of children, the check-in date, the check-out date, and which room (if not already reserved). During stay, a guest may make requests that are fulfilled by a clerk and recorded to their total bill that is charged on the check-out date. Tab, A client is charged one bill on their check-out date for the total of the Invoice cost of their room and all services requested during the fulfilment of their reservation. Any number of clerks can each individually make a log with a charge and comment to a bill. Reservations A future period of time for a client to request a room that Best Dream agrees to have ready on check-in date. Bill Accumulation of a client's extra charges during their stay. an EER diagram modeling the Best Dream hotel business; a schema based off of the EER diagram that has been normalized to 3NF; Objectives 1. conceptual database design 2. logical database design 3. normalization to 3NF The Best Dreams hotel chain has hired you to design their database to begin optimizing their operations. The following is a data dictionary recorded through interviews by a database designer with the owners of managing Best Dreams, their employees at various locations, and clients that make reservations. Entity Name Aliases Occurrence Resort Hotel A location, with an address, has at least 10 and at most 50 staff Locations owned operating it with at least 5 or more rooms available. The locations by the hotel available are across North America. chain Best Dreams where clients are able to stay. Staff Employee, There are three types of staff at each resort: supervisor, clerk, and The general type Supervisor, attendant. of person Clerk, One supervisor at each location manages up to 50 other staff, and employed by Best Attendant orders furnishings for the rooms (that are not linens) when needed. Dreams. A clerk registers clients that request reservations for a room at some future period of time, with a check-in date and a check-out date. Guests may check in as early as 2 pm on their check-in date or later. Guests must check out by 11 am on their check-out date or earlier. A clerk can also add charges with a comment to log additional re- quests by a guest during their stay toward their total bill. An attendant cleans rooms. Rooms Suite, Unit A room can have 1 to 2 beds of different sizes (beds must match size Units at resorts in each room) for clients to Junior: couch, TV, coffee maker, bathroom. reserve and stay Residential: (in addition to Junior amenities) mini-fridge, snack-bar, in for a period of desk, and recliner. time. Presidential: (in addition to Residential amenities) king-sized beds, kitchinette, and attached suite with study. Each room has reservations made to it over time that cannot overlap with more than one reservation during any time period. Furnishing Items of furniture and decorations in rooms. Clients People that reserve and stay in Best dream hotel rooms. Furniture, Bed, desk, mini-fridge, fridge, stove, coffee-maker, lamps, blankets, Appliances, pillows, sheets, TV, phone. Linens, Decor Each item also should have an age and condition recorded to keep track of when it should be replaced. Note that linens (blankets, pillows, sheets) are always laundered and provided every day by attendants and are logged in bulk for the entire resort instead of logged by room. Linens can be requested by guests, which add to their bill. Traveller, A client could consist of at least one adult, and some number of Visitor, children that stay in one room together over a period of time. Guest, They make the reservation at some date previous to or on the check- Group in date. They will then check in with a credit card and a license plate number at the front desk with a clerk. When they check in, they are given a keycard for access to their room and on the check-out date they give the keycard back. Registration Made by a client via web, or over phone to front desk, on some date before check-in at an agreed price. They must specify the number of adults and the number of children, the check-in date, the check-out date, and which room (if not already reserved). During stay, a guest may make requests that are fulfilled by a clerk and recorded to their total bill that is charged on the check-out date. Tab, A client is charged one bill on their check-out date for the total of the Invoice cost of their room and all services requested during the fulfilment of their reservation. Any number of clerks can each individually make a log with a charge and comment to a bill. Reservations A future period of time for a client to request a room that Best Dream agrees to have ready on check-in date. Bill Accumulation of a client's extra charges during their stay