don't waste my question please answer correctly

ERD Hotel Database Themed Hotel! Objectives 1. Produce an ERD in 3NF from source documents and client input 2. Demonstrate initial table, first, second, and third normal forms by showing the database tables as they exist in each of the three normal forms 3. Merge ERDs from different views to create one final merged ERD of the final database design Requirements Given the source documents for 4 different views and company description, create a database design demonstrating the concept of normalization, showing all the attributes as they exist in the initial table, 1NF, 2NF, and 3NF. You will do this for each of the three views and create an ERD for each view in 3NF, as well as the final merged ERD. The Company ERD Hotel is a hotel with a distinctive Database them to it. Guests can choose from a number of rooms that share different database themes! Room Booking Summary View(5 Marks) Booking ID: 125 Date: June 4, 2022 Price $120.00 $120.00 $120.00 CUSTOMER Name: Jason Normal Form Email:3NF@sql.com Phone: 780-555-1234 Booking Details Room Number 123 124 125 Additional Booking Notes: Arriving late Subtotal: $360.00 Hospitality Tax: $28.80 $ 19.44 GST: Total: $ 408.24 A customer books a set of rooms for a number of guests but does not have to be one of the guests Hospitality tax of 8% is added on to each booking as well as 5% GST Each booking can have Additional Booking Notes should they be needed Floor First First First Booking Guests View(4 Marks) Booking ID: 125 Date: June 4, 2022 GuestID Name 432 Room# Address 123 Phone 555123456 Special Requests Extra Pillows Relational Dave 62 Atomic Drive, SQL, AB T8E1G3 412 Frank Key 124 555654321 SQL songs sung to 162 Composite Drive, guest at bedtime SQL, AB T8R1D3 1 ERD Lane, 112 Dave Dependency 125 5558881122 No Room Service SQL, AB A1BC2D 1 ERD Lane, 126 May Dependency 125 5558881122 No Room Service SQL, AB A1BC2D Each Room can have a number of registered guests. All guests in a room must be registered Each guest(s) are assigned to a room and special requests can be made by each guest to make their stay more enjoyable Room Description View(6 Marks) Room Number: 124 RoomTypeID: 1 RoomPriceRangeID:3 RoomTypeDescription: Entity and Attribute Theme Room Lower Range: $100.00 Upper Range: $200.00 AmenityID Amenity Description 132 121 Relational Database Fruit Basket Normalization Obstacle Course ERD Puzzles 12 Each of our rooms has a current price as well as a price range that we stay in when we change the room prices for different parts of the year. Each room can have special amenities and a particular type or theme One room is only one Room Type but can have many amenities in it to make the guests stay a more enjoyable one Booking Payment View(5 Marks) Booking ID: 125 Date: June 4, 2022 Total: $408.24 PaymentID Payment MethodID Payment MethodDesc Amount 132 1 Visa $100.00 121 1 $150.00 Visa MasterCard 12 2 $100.00 A customer can make multiple payments to pay off Booking Payments can be either Cash, Visa, MC, or ETransfer Merged ERD: (2 marks) Create a merged ERD of your final database design for Stuff B Gone. Customer ID: 125 Name: Jason Normalform Notes ERD Hotel Database Themed Hotel! Objectives 1. Produce an ERD in 3NF from source documents and client input 2. Demonstrate initial table, first, second, and third normal forms by showing the database tables as they exist in each of the three normal forms 3. Merge ERDs from different views to create one final merged ERD of the final database design Requirements Given the source documents for 4 different views and company description, create a database design demonstrating the concept of normalization, showing all the attributes as they exist in the initial table, 1NF, 2NF, and 3NF. You will do this for each of the three views and create an ERD for each view in 3NF, as well as the final merged ERD. The Company ERD Hotel is a hotel with a distinctive Database them to it. Guests can choose from a number of rooms that share different database themes! Room Booking Summary View(5 Marks) Booking ID: 125 Date: June 4, 2022 Price $120.00 $120.00 $120.00 CUSTOMER Name: Jason Normal Form Email:3NF@sql.com Phone: 780-555-1234 Booking Details Room Number 123 124 125 Additional Booking Notes: Arriving late Subtotal: $360.00 Hospitality Tax: $28.80 $ 19.44 GST: Total: $ 408.24 A customer books a set of rooms for a number of guests but does not have to be one of the guests Hospitality tax of 8% is added on to each booking as well as 5% GST Each booking can have Additional Booking Notes should they be needed Floor First First First Booking Guests View(4 Marks) Booking ID: 125 Date: June 4, 2022 GuestID Name 432 Room# Address 123 Phone 555123456 Special Requests Extra Pillows Relational Dave 62 Atomic Drive, SQL, AB T8E1G3 412 Frank Key 124 555654321 SQL songs sung to 162 Composite Drive, guest at bedtime SQL, AB T8R1D3 1 ERD Lane, 112 Dave Dependency 125 5558881122 No Room Service SQL, AB A1BC2D 1 ERD Lane, 126 May Dependency 125 5558881122 No Room Service SQL, AB A1BC2D Each Room can have a number of registered guests. All guests in a room must be registered Each guest(s) are assigned to a room and special requests can be made by each guest to make their stay more enjoyable Room Description View(6 Marks) Room Number: 124 RoomTypeID: 1 RoomPriceRangeID:3 RoomTypeDescription: Entity and Attribute Theme Room Lower Range: $100.00 Upper Range: $200.00 AmenityID Amenity Description 132 121 Relational Database Fruit Basket Normalization Obstacle Course ERD Puzzles 12 Each of our rooms has a current price as well as a price range that we stay in when we change the room prices for different parts of the year. Each room can have special amenities and a particular type or theme One room is only one Room Type but can have many amenities in it to make the guests stay a more enjoyable one Booking Payment View(5 Marks) Booking ID: 125 Date: June 4, 2022 Total: $408.24 PaymentID Payment MethodID Payment MethodDesc Amount 132 1 Visa $100.00 121 1 $150.00 Visa MasterCard 12 2 $100.00 A customer can make multiple payments to pay off Booking Payments can be either Cash, Visa, MC, or ETransfer Merged ERD: (2 marks) Create a merged ERD of your final database design for Stuff B Gone. Customer ID: 125 Name: Jason Normalform Notes