Business Applications of Database Management. Please perform Normalization on this form. Normalize

Payments and Billing Landscape designers and contractors purchase items for other customers. As a result, Orange Blossom maintains accounts for its major clients. Ultimately, the contractors and designers are responsible for payment, but it takes time to install a project and collect money from the end customers. Orange Blossom allows clients to identify a project when making a payment, and tracks their spending for them. Consequently, the accounting manager tracks payments based on projects and be able to send billing notices to the contractors. Additionally, expensive plants, special orders, and large orders require down payments. Some clients make payments over time-particularly as a project progresses. As shown in Figure 2, Orange Blossom sends a monthly billing statement that lists the balance at the start of the period, new purchases, and any payments received. The Balance of the payment is the difference between the cost of the project and the amount that has already been paid. Finally, the employees at Orange Blossom have multiple specialties, therefore the company wants to keep track on the database of all specialties each employee has. Furthermore, to save the amount of data stored on the database, Orange Blossom requested that no computed values should be stored. Figure 2: Orange Blossom Billing Form Orange Blossom Billing Form Billing Date Time Period Employee Name Client Name Phone Email Fax Address City, State ZIP Payments Received Project Total Cost Payment Date Project Description Installed Amount Paid Balance Date Total Received Outstanding Balance Ending Balance Payments and Billing Landscape designers and contractors purchase items for other customers. As a result, Orange Blossom maintains accounts for its major clients. Ultimately, the contractors and designers are responsible for payment, but it takes time to install a project and collect money from the end customers. Orange Blossom allows clients to identify a project when making a payment, and tracks their spending for them. Consequently, the accounting manager tracks payments based on projects and be able to send billing notices to the contractors. Additionally, expensive plants, special orders, and large orders require down payments. Some clients make payments over time-particularly as a project progresses. As shown in Figure 2, Orange Blossom sends a monthly billing statement that lists the balance at the start of the period, new purchases, and any payments received. The Balance of the payment is the difference between the cost of the project and the amount that has already been paid. Finally, the employees at Orange Blossom have multiple specialties, therefore the company wants to keep track on the database of all specialties each employee has. Furthermore, to save the amount of data stored on the database, Orange Blossom requested that no computed values should be stored. Figure 2: Orange Blossom Billing Form Orange Blossom Billing Form Billing Date Time Period Employee Name Client Name Phone Email Fax Address City, State ZIP Payments Received Project Total Cost Payment Date Project Description Installed Amount Paid Balance Date Total Received Outstanding Balance Ending Balance