INST327-Assignment 3 Practice (Not Graded) Normalize the un-normalized dataset given below through 1NF, 2NF, and 3NF. Show the normalization process in a file (e.g., creating tables and drawing relationship lines in MS Word or MS Excel), save it as a PDF file, and submit it through the link available on Canvas. Name your file according to this scheme:yourlastname_A3_normalize.pdf. Do not protect your .pdf file. The presentation of your normalization process should mimic the normalization class exercise and the example provided on Canvas. To complete this assignment successfully, please keep in mind the following points as you work on the normalization case. You may lose points if you do not follow these: - Include the names of every participating team member on the submission file. Make sure that you cover each normalization step (1NF, 2NF, 3NF) separately, explicitly, and in sequence. Do not skip any normalization steps. In each normalization step, you should only resolve the issue(s) that pertain to the given step (for example, do not resolve transitive dependencies in 1NF or 2NF, as transitive dependencies are 3NF business.) - In each step, list all of the tables, including those that do not change in the given step. Identify and show primary keys and foreign keys in each step. For each step, describe the changes you made in a short paragraph summary. This does not need to be long but should outline the changes you made and why you did them (in this step). Show the relationships between the tables in each form (by drawing lines/arrows between corresponding PKs and FKs). The sample records are for your reference only to help you understand the nature of each field. You should not include them in your work. QuickBites Database Things to note for this database - The sample data is provided for you to help you understand what kind of information is in each column, but you do not need to include it in your normalization. Assume one customer places many orders but one order belongs to only one customer. - Note groups of repeating fields in this table Resources for help in this assignment is allowed. Used the database below for the assignment QuickBites Database - Customers Table Customer ID Customer Name Customer Address Customer Phone Number Order 1 Date Order 1 Restaurant ID Order 1 Restaurant Name Order 1 Restaurant Phone Number Order 1 Restaurant Website Order 1 Item 1 Name Order 1 Item 2 Name Order 1 Item 3 Name Order 1 Total Amount Order 1 Payment Method Order 1 Delivery Person Name Order 2 Date Order 2 Restaurant ID Order 2 Restaurant Name Order 2 Restaurant Phone Number Order 2 Restaurant Website Order 2 Item 1 Name Order 2 Item 2 Name Order 2 Item 3 Name Order 2 Total Amount Order 2 Payment Method Order 2 Delivery Person Name Order 3 Date Order 3 Restaurant ID Order 3 Restaurant Name Order 3 Restaurant Phone Number Order 3 Restaurant Website Order 3 Item 1 Name Order 3 Item 2 Name Order 3 Item 3 Name Order 3 Total Amount Order 3 Payment Method Order 3 Delivery Person Name Sample Data (do not include in solution) 3128 Carlo Garibaldi 125 State Str. #402 Centerville NJ 12987 555-789-4567 09/15/2025 376 Burgers and More 555-295-9777 burgersandmorenj.com Double cheeseburger French fries Ginger ale -20 oz. can $12.87 Mastercard Zack Fastway 09/25/2025 193 Tom's Seafood 555-927-8121 seafoodbytom.com Fish fillet sandwich Onion rings $9.56 Mastercard Alex Dorfer 09/28/2025 224 Midtown Grill 555-781-3535 realmidtowngrill.com Mixed grill platter Grilled vegetables bowl Greek salad $22.72 Zelle Zack Fastway

INST327-Assignment 3 Practice (Not Graded) Normalize the un-normalized dataset given below through 1NF, 2NF, and 3NF. Show the normalization process in a file (e.g., creating tables and drawing relationship lines in MS Word or MS Excel), save it as a PDF file, and submit it through the link available on Canvas. Name your file according to this scheme:yourlastname_A3_normalize.pdf. Do not protect your .pdf file. The presentation of your normalization process should mimic the normalization class exercise and the example provided on Canvas. To complete this assignment successfully, please keep in mind the following points as you work on the normalization case. You may lose points if you do not follow these: - Include the names of every participating team member on the submission file. Make sure that you cover each normalization step (1NF, 2NF, 3NF) separately, explicitly, and in sequence. Do not skip any normalization steps. In each normalization step, you should only resolve the issue(s) that pertain to the given step (for example, do not resolve transitive dependencies in 1NF or 2NF, as transitive dependencies are 3NF business.) - In each step, list all of the tables, including those that do not change in the given step. Identify and show primary keys and foreign keys in each step. For each step, describe the changes you made in a short paragraph summary. This does not need to be long but should outline the changes you made and why you did them (in this step). Show the relationships between the tables in each form (by drawing lines/arrows between corresponding PKs and FKs). The sample records are for your reference only to help you understand the nature of each field. You should not include them in your work. QuickBites Database Things to note for this database - The sample data is provided for you to help you understand what kind of information is in each column, but you do not need to include it in your normalization. Assume one customer places many orders but one order belongs to only one customer. - Note groups of repeating fields in this table Resources for help in this assignment is allowed. Used the database below for the assignment QuickBites Database - Customers Table Customer ID Customer Name Customer Address Customer Phone Number Order 1 Date Order 1 Restaurant ID Order 1 Restaurant Name Order 1 Restaurant Phone Number Order 1 Restaurant Website Order 1 Item 1 Name Order 1 Item 2 Name Order 1 Item 3 Name Order 1 Total Amount Order 1 Payment Method Order 1 Delivery Person Name Order 2 Date Order 2 Restaurant ID Order 2 Restaurant Name Order 2 Restaurant Phone Number Order 2 Restaurant Website Order 2 Item 1 Name Order 2 Item 2 Name Order 2 Item 3 Name Order 2 Total Amount Order 2 Payment Method Order 2 Delivery Person Name Order 3 Date Order 3 Restaurant ID Order 3 Restaurant Name Order 3 Restaurant Phone Number Order 3 Restaurant Website Order 3 Item 1 Name Order 3 Item 2 Name Order 3 Item 3 Name Order 3 Total Amount Order 3 Payment Method Order 3 Delivery Person Name Sample Data (do not include in solution) 3128 Carlo Garibaldi 125 State Str. #402 Centerville NJ 12987 555-789-4567 09/15/2025 376 Burgers and More 555-295-9777 burgersandmorenj.com Double cheeseburger French fries Ginger ale -20 oz. can $12.87 Mastercard Zack Fastway 09/25/2025 193 Tom's Seafood 555-927-8121 seafoodbytom.com Fish fillet sandwich Onion rings $9.56 Mastercard Alex Dorfer 09/28/2025 224 Midtown Grill 555-781-3535 realmidtowngrill.com Mixed grill platter Grilled vegetables bowl Greek salad $22.72 Zelle Zack Fastway