Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

RB Candy sells its products to customers through a network of company salespeople. Each salesperson services a separate group of customers and is allowed to

RB Candy sells its products to customers through a network of company salespeople. Each salesperson services a separate group of customers and is allowed to offer them various discounts from list to induce sales. Each sale can include one or more types of products and can be paid for (1) on the 15th of the following month, or (2) over the course of six months. When cash is received, a cashier deposits it into a company bank account. Sales are signaled by invoices.

The policies above plus the information elements listed below are relevant to potential users of this data model, and they all should be included in its final structure. Please assume that cashiers and salespeople both belong to an entity called "employee."

Information elements in the model (attributes): -product# -product description -list price -QOH (quantity-on-hand) -bank account# -bank name -account type -employee's highest degree -customer name -A/R amount -customer# -invoice# -sale date -sale amount -inventory quantity sold -actual price of each product -employee name -salesperson quarterly sales -salesperson comm. rate -employee# -bank# -cash receipt date -cash receipt amount -employee category -remittance advice# - bank address -number of employees in category -bank phone number -medical plan for this category -cash account balance -monthly pay of employee -amount of cash receipt applied to a certain sale -unit cost -cash receipt#

Required: Use the information above and the list of data elements to construct an UML Class Diagram for RB Candy. You must include the attributes in the diagram, and indicate the primary key and foreign keys in each table. Please consider generalization (IS-A relationship) and typification for some entities.

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

Intermediate Accounting

Authors: J. David Spiceland, James Sepe, Lawrence A. Tomassini

4th Edition

0072994029, 9780072994025

More Books

Students also viewed these Accounting questions

Question

Date decision to be made (if known)

Answered: 1 week ago

Question

1. Information that is currently accessible (recognition).

Answered: 1 week ago