please do part A and B completely. I will upvote. Background

Everwood Furnishings is a Canadian$-$based company that supplies a broad range of high$-$quality furniture to retail outlets and institution customers. The company has built a solid reputation by offering diverse and affordable furniture collections sourced from renowned manufacturers. With its centralized operations and direct customer engagement strategy, Everwood serves businesses and other organizations across the Greater Toronto Area $($GTA$)$ and beyond.

Inventory

Everwood Furnishings offers ten distinct categories of furniture, catering to varying customer needs and preferences. These categories include living room sets, bedroom furniture, dining room collections, office furniture, outdoor pieces, and more. Each category contains a range of products with unique identification numbers and suggested retail prices.

Sales

To streamline customer service and maintain personalized relationships, Everwood assigns every new customer to a dedicated salesperson. Salespersons are responsible for managing all transactions and interactions with their assigned group of customers. This structure ensures consistent communication and enables the sales team to build strong client relationships.

Salespersons also have the authority to negotiate deals on high$-$volume orders or offer discounts on slowermoving inventory. This flexibility helps optimize inventory turnover while rewarding customer loyalty and promoting long$-$term partnerships.

The commission rate for each salesperson is determined through a contractual arrangement, remaining consistent regardless of the items sold.

Payment Methods

Everwood provides customers with flexible payment options to facilitate ease of transactions and encourage repeat business. Clients can choose from two payment methods:

$1.$ Immediate Payment: Full payment is made in cash at the time of purchase.

$2.$ Installment Plan: Payments are made over a six$-$month period.

$3.$ Deferred Payment: Payment is due by the last day of the following month.

This range of options accommodates different customer preferences and financial situations, fostering greater customer satisfaction and loyalty.

Cash Receipts

While the majority of Everwood's cash receipts come from customer transactions, the company also receives funds from other sources, such as interest payments from banks or financial investments. Regardless of the source, each cash receipt is processed by a member of Everwood's cashier team and deposited into one of the company's bank accounts by the end of the day on which the payment is received.

Other Information

Details about furniture, employees, customers, and bank accounts are typically entered into the database prior to any related transactions. For simplicity, sales discounts and Harmonized Sales Tax $($HST$)$ can be ignored. Phase I Instructions

Part A$.$

Based on the information given, prepare a UML class diagram for Everwood Furniture with a MS Office application $($e$.$g$.$ PowerPoint, Word etc.$).$ Use the REA model to help you determine the entities. Assign the attributes listed below to appropriate entities or many$-$to$-$many relationships.

Notes:

a$.$ CR: Cash Receipts

b$.$ DOB: Date of Birth

c$.$ Emp: Employee

d$.$ Cust: Customer

e$.$ AR: Accounts Receivable

Part B: Implementing Your UML Data Model with Access $(6$ marks$)$

$1)$ Based on the UML class diagram you created for Phase I, construct a database using MS Access.

a$.$ Create a table for each class and for each many$-$to$-$many relationship.

b$.$ Establish appropriate relationships among the tables using foreign keys.

$2)$ In your MS Access file, navigate to "Database Tools" and link all the tables.

$3)$ Under "Database Tools$\backslash$Relationships$",$ take a screenshot with all the attributes of each table displayed clearly.

$4)$ Create a new MS Word file, copy and paste the screenshot to the Word file.

$5)$ Save the Access file.