Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help make class diagram. below is final table Final Table: 1. Billing (billing_ID, billing_Date, time_Period) 2. Payment (payment_ID, billing_ID, project_ID, payment_Date, project_Descript, balance, amount)

Please help make class diagram. below is final table

image text in transcribed

Final Table:

1. Billing (billing_ID, billing_Date, time_Period)

2. Payment (payment_ID, billing_ID, project_ID, payment_Date, project_Descript, balance, amount)

3. Project (project_ID, project_Total_Cost, date_Installed)

4. Client (client_ID, client_First_Name, client_Last_Name, phone, email, fax)

5. Address (address_ID, address, city, state, zip)

6. Employee (employee_ID, employee_First_Name, employee_Last_Name)

7. EmployeeSpecialty (employee_ID, specialty)

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Matching Supply with Demand An Introduction to Operations Management

Authors: Gerard Cachon, Christian Terwiesch

3rd edition

73525200, 978-0073525204

More Books

Students also viewed these General Management questions

Question

Find the unit vector in the opposite direction of (1,2,3)

Answered: 1 week ago