Need final form table for BILLING form.

I already done 1nf, 2nf, 3nf.

1NF:

Billing (billing_id, billing_date, time_period, client_first_name, client_last_name, employee_first_name, employee_last_name, phone, email, fax, address, city, state, zip)

Payment (payment_id, billing_id, project, date, description, amount)

Project (project_id, project_total_cost, installed, total_received, outstanding_balance, ending_balance)

Employee (employee_id, employee_specialty)

2NF:

Billing (billing_id, billing_date, time_period, client_id, employee_id)

Client (client_id, client_first_name, client_last_name, phone, email, fax, address, city, state, zip)

Employee (employee_id, employee_first_name, employee_last_name)

Payment (payment_id, billing_id, project_id, date, description, amount)

Project (project_id, project_total_cost, installed, total_received, outstanding_balance, ending_balance)

EmployeeSpecialty (employee_id, specialty)

3NF:

Billing (billing_id, billing_date, time_period, client_id, employee_id)

Client (client_id, client_first_name, client_last_name, phone, email, fax, address_id)

Address (address_id, address, city, state, zip)

Employee (employee_id, employee_first_name, employee_last_name)

Payment (payment_id, billing_id, project_id, date, description, amount)

Project (project_id, project_total_cost, installed, total_received, outstanding_balance, ending_balance)

EmployeeSpecialty (employee_id, specialty)

*****just make final form table. below is EXAMPLE of final form table.

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 project total cost 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 Final Ticket Sales Form Tables: 1. Sale (sale\#, salesdate, employeeID, customerID, showingID) 2. Sale Ticket (sale\#, ticketiD, quantity) 3. Ticket (ticketID, tickettype, ticketprice) 4. Employee (employeeID, firstname, lastname, address, city, state, zip, datehired position) 5. Customer (customerID, firstname lastname, address, city, state, zip, phone, email, DoB) 6. Showing (showingID, showingtime, movieID, auditoriumID) 7. Movie (movieID title, description, director, ratingID) 8. Auditorium (auditoriumID \#ofseats) 9. Rating (ratingID, description)