1. The Problem: Keeping Track of a Stack of Invoices Consider a typical invoice (refer Figure 1). This document, or something like it, is the basis of the order fulfillment process of almost any business. Every piece of information you see here is important. For this assignment, you will be doing normalization (1NF until 3NF) and drawing entity relationship diagram (ERD) based on the normalized relations PVFC Customer Invoice Customer ID 2 Customer Name Value Furniture Address 15145 S.W. 17th St. Plano TX 75022 Order ID Order Date 1006 10/24/2010 Product ID Product Description Finish Quantity Unit Price Extended Price 7 5 4 Dining Table Natural Ash Writer's Desk Cherry Entertainment Center Natural Maple 2 $800.00 2 $325.00 1 $650.00 $1,600.00 $650.00 $650.00 Total $2,900.00 Figure 1: Invoice (Pine Valley Furniture Company) 1. The Problem: Keeping Track of a Stack of Invoices Consider a typical invoice (refer Figure 1). This document, or something like it, is the basis of the order fulfillment process of almost any business. Every piece of information you see here is important. For this assignment, you will be doing normalization (1NF until 3NF) and drawing entity relationship diagram (ERD) based on the normalized relations PVFC Customer Invoice Customer ID 2 Customer Name Value Furniture Address 15145 S.W. 17th St. Plano TX 75022 Order ID Order Date 1006 10/24/2010 Product ID Product Description Finish Quantity Unit Price Extended Price 7 5 4 Dining Table Natural Ash Writer's Desk Cherry Entertainment Center Natural Maple 2 $800.00 2 $325.00 1 $650.00 $1,600.00 $650.00 $650.00 Total $2,900.00 Figure 1: Invoice (Pine Valley Furniture Company)