Apply 1st, 2nd and 3rd Normalization form on the below table product_id prod_desc whse_id 167 Shovel...

Transcribed Image Text:

Apply 1st, 2nd and 3rd Normalization form on the below table product_id prod_desc whse_id 167 Shovel 111 222 111 222 448 302 Hammer Rake client_id c_name property_id CR76 CR56 John Kay Aline Stewart Apply 1st, 2nd and 3rd Normalization form on the below table PG4 PG16 PG4 PG36 bin 150 244 PG16 883 212 address 6 lawrence St, Glasgow 5 Novar Dr. Glasgow 6 lawrence St, Glasgow 2 Manor Rd, Glasgow qty whse_address 19 26 5 Novar Dr. Glasgow 20 18 1511 Central Ave. 6803 Alder St. 1511 Central Ave. 6803 Alder St. rent_start rent_finish rent 1-Jul-00 1-Sep-02 1-Sep-99 10-Oct-00 1-Nov-02 city Detroit Dallas Detroit Dallas 31-Aug-01 350 CO40 10-Jun-00 1-Sep-02 450 CO93 1-Dec-01 350 owner_id 1-Aug-03 450 CO40 370 CO93 state MI TX MI TX CO93 zip 48220 97338 48220 97338 o_name Tina Murphy Tony Shaw Tina Murphy Tony Shaw Tony Shaw Apply 1st, 2nd and 3rd Normalization form on the below table product_id prod_desc whse_id 167 Shovel 111 222 111 222 448 302 Hammer Rake client_id c_name property_id CR76 CR56 John Kay Aline Stewart Apply 1st, 2nd and 3rd Normalization form on the below table PG4 PG16 PG4 PG36 bin 150 244 PG16 883 212 address 6 lawrence St, Glasgow 5 Novar Dr. Glasgow 6 lawrence St, Glasgow 2 Manor Rd, Glasgow qty whse_address 19 26 5 Novar Dr. Glasgow 20 18 1511 Central Ave. 6803 Alder St. 1511 Central Ave. 6803 Alder St. rent_start rent_finish rent 1-Jul-00 1-Sep-02 1-Sep-99 10-Oct-00 1-Nov-02 city Detroit Dallas Detroit Dallas 31-Aug-01 350 CO40 10-Jun-00 1-Sep-02 450 CO93 1-Dec-01 350 owner_id 1-Aug-03 450 CO40 370 CO93 state MI TX MI TX CO93 zip 48220 97338 48220 97338 o_name Tina Murphy Tony Shaw Tina Murphy Tony Shaw Tony Shaw