Normalize the above table by splitting up the data into separate tables that are related via keys. Using the notation below in the example section, show the tables you have created after normalizing. Ensure each table does not contain any unnecessary repetition and errors. Make sure each table has a unique identifier (Primary key or Composite key) Use the following notation to identify each table. Underline the primary or composite key 

Example: 

Tablename (fieldname1, fieldname2, fieldname3, fieldname4)

Transcribed Image Text:

Hotel_name City Room_type Price Guest_name Guest_addr 123 Madison Chk_in_dt Chk out dt 03/10/14 03/13/14 New York 02/02/14 02/07/14 04/19/14 04/24/14 03/10/14 03/15/14 New York 04/10/14 04/12/14 New York 02/10/14 02/13/14 05/1/14 05/04/14 State New York NY City Hilton Hilton Hilton Hilton Hilton Hilton 140 140 140 NY Regular Smith 4433 W4th NY NY NY Regular Regular Jones 123 Madison NY NY New York NY Smith 4433 W4th 4433 W4th 33 E3rd NY Regular 140 Jones Regular Jones 1230 McCally NY NY 140 NYC NY Suite 44433 W4th NY New Yor 1230 Jones 200 McCally Hilton NJ Suite 33 E3rd 4433 W4th Hilton Hilton Double PA NYC NY Regular 140 JOne 05/21/14 05/22/14 PA NY Hotel_name City Room_type Price Guest_name Guest_addr 123 Madison Chk_in_dt Chk out dt 03/10/14 03/13/14 New York 02/02/14 02/07/14 04/19/14 04/24/14 03/10/14 03/15/14 New York 04/10/14 04/12/14 New York 02/10/14 02/13/14 05/1/14 05/04/14 State New York NY City Hilton Hilton Hilton Hilton Hilton Hilton 140 140 140 NY Regular Smith 4433 W4th NY NY NY Regular Regular Jones 123 Madison NY NY New York NY Smith 4433 W4th 4433 W4th 33 E3rd NY Regular 140 Jones Regular Jones 1230 McCally NY NY 140 NYC NY Suite 44433 W4th NY New Yor 1230 Jones 200 McCally Hilton NJ Suite 33 E3rd 4433 W4th Hilton Hilton Double PA NYC NY Regular 140 JOne 05/21/14 05/22/14 PA NY

Answer rating: 100% (QA)

A first step to normalize a database table is to try to avoid redundancies To achieve this it is abo... View the full answer