Draw the dependency diagram, then transfer this table into 3NF using the listed attributes

Q2. Normalization (30 pts) A local hotel invites you to improve their database system. They only have one large table with the following attributes: Customer Name, Customer Driver License Number, Customer Phone Number, Customer Bill Address, Checkin Stuff Name, Checkin Stuff Phone Number, Booking Time, Checkin Status, Checkin Time, Room Number, Room Price, Floor, Building Name, Building Address, Total Price, Payment Status, Checkout Time Draw the dependency diagram, transfer this table into 3NF(You may need to add necessary attributes.) Extra Credits (5 pts, out of 100pts) After normalization, compose a sample SQL query to list all available rooms for a reservation from '2022-04-06 to 2022-04-11. *Checkin Status is a control variable, if status is 1, means booked, but not check in; if 2, means checked in, but not check out; if 3, checked out and paid; if 0, cancelled. Q2. Normalization (30 pts) A local hotel invites you to improve their database system. They only have one large table with the following attributes: Customer Name, Customer Driver License Number, Customer Phone Number, Customer Bill Address, Checkin Stuff Name, Checkin Stuff Phone Number, Booking Time, Checkin Status, Checkin Time, Room Number, Room Price, Floor, Building Name, Building Address, Total Price, Payment Status, Checkout Time Draw the dependency diagram, transfer this table into 3NF(You may need to add necessary attributes.) Extra Credits (5 pts, out of 100pts) After normalization, compose a sample SQL query to list all available rooms for a reservation from '2022-04-06 to 2022-04-11. *Checkin Status is a control variable, if status is 1, means booked, but not check in; if 2, means checked in, but not check out; if 3, checked out and paid; if 0, cancelled