The "Customer" table in the "dsci_504" database schema does not meet the requirements for

Second Normal Form (2NF) or Third Normal Form (3NF).

• Provide a description of why that is based on the requirements for EACH normalization step.

• THEN write the query to correct the issue.

Hint: You may be required to make a new table to satisfactorily correct the violation

The attached images illustrate:

• Image 1 - The "Customer" table and the columns within the customers table
• Image 2 - The other tables and columns in the DSCI 504 database

Transcribed Image Text:

dsci_504.component 2 comp_id ABC comp_name 123 comp_cost 123 comp_supplier ABC comp_cat 123 sup_id 8 dsci_504.rac 12 rac_id 123 tot_ret_item_cnt 123 tot_ret_amnt 123 cus_id 123 warehouse_id 123 prod_id 123 comp_id 123 ord_id dsci_504.supplier 123 cus_id 123 warehouse_id 123 ord_id 123 rac_id 12 sup_id ADC Sup_name ABC Sup_ctry dsci_504.customerwarehousereturn 12 prod_id ABC prod_cat_name ABC prod_manufacturer ABC prod_name ABC prod_description dsci_504.product 123 prod_price ABC prod_class ABC Country_origin 123 sup_id dsci_504.warehouse 12 warehouse_id ABC warehouse_name 123 warehouse_state dsci_504."order" 12 ord_id ord_date ABC ord_tax_loc 123 ord_tot ABC ord_ship_add ord_ship_date ABC ord_track_num 123 prod_id 123 warehouse_id 123 cus_id dsci_504.productbuild 12 cus_id 12 warehouse_id 12 ord_id 12 prod_id 123 build_id dsci_504.customer 12 cus_id ADC Cus_num ABC cus_last_name ABC cus_first_name 123 cus_add_num ABC cus_address ABC Cus_city 123 cus_state 123 cus_zip 123 cus_phone cus_join_date 123 cus_app_cd ABC cus_app_num 123 tot_ord_qty 123 tot_ord_value dsci_504.customerwarehouseorder dsci_504.build 12 build_id ABC comp_hbar ABC Comp_brake ABC comp_wheels ABC comp_fork ABC comp_shock ABC comp_shifter ABC comp_cassette ABC comp_derail ABC comp_dropper ABC comp_crank ABC comp_chain_ring ADC build_name dsci_504.tax 12tax_id ABC tax_location 123 tax rate dsci_504.ordertax 123 ord_id ord_date 123 tax rate dsci_504.state 12 state_id ABC state dsci_504.component 2 comp_id ABC comp_name 123 comp_cost 123 comp_supplier ABC comp_cat 123 sup_id 8 dsci_504.rac 12 rac_id 123 tot_ret_item_cnt 123 tot_ret_amnt 123 cus_id 123 warehouse_id 123 prod_id 123 comp_id 123 ord_id dsci_504.supplier 123 cus_id 123 warehouse_id 123 ord_id 123 rac_id 12 sup_id ADC Sup_name ABC Sup_ctry dsci_504.customerwarehousereturn 12 prod_id ABC prod_cat_name ABC prod_manufacturer ABC prod_name ABC prod_description dsci_504.product 123 prod_price ABC prod_class ABC Country_origin 123 sup_id dsci_504.warehouse 12 warehouse_id ABC warehouse_name 123 warehouse_state dsci_504."order" 12 ord_id ord_date ABC ord_tax_loc 123 ord_tot ABC ord_ship_add ord_ship_date ABC ord_track_num 123 prod_id 123 warehouse_id 123 cus_id dsci_504.productbuild 12 cus_id 12 warehouse_id 12 ord_id 12 prod_id 123 build_id dsci_504.customer 12 cus_id ADC Cus_num ABC cus_last_name ABC cus_first_name 123 cus_add_num ABC cus_address ABC Cus_city 123 cus_state 123 cus_zip 123 cus_phone cus_join_date 123 cus_app_cd ABC cus_app_num 123 tot_ord_qty 123 tot_ord_value dsci_504.customerwarehouseorder dsci_504.build 12 build_id ABC comp_hbar ABC Comp_brake ABC comp_wheels ABC comp_fork ABC comp_shock ABC comp_shifter ABC comp_cassette ABC comp_derail ABC comp_dropper ABC comp_crank ABC comp_chain_ring ADC build_name dsci_504.tax 12tax_id ABC tax_location 123 tax rate dsci_504.ordertax 123 ord_id ord_date 123 tax rate dsci_504.state 12 state_id ABC state