Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Let me know if you think the boxes are correct, they have multiple options each. Thanks in advance. Required: This question should be attempted after

Let me know if you think the boxes are correct, they have multiple options each. Thanks in advance. image text in transcribedimage text in transcribed

Required: This question should be attempted after you complete Exercise Requirement 2. Review the Excel data, prepare the UML class diagram (REA) and then choose the correct fields to complete the table listing below. Resources Finished Inventory Finished Inventory Catalog # (PK), (FK), Color Code (FK), Order # Description, Size, Retail Price, Wholesale Price, Standard Cost (PK), Bank, Account Description, Balance 4/1/18 Cash Events Retailer Orders/Sales Order # (PK), Order Date, Requested Inventory # Date, (FK) Cash receipt # (FK), Order Employee # (FK), Shipping Employee (FK), Shipping Cost Receipt Amount, Cash Receipt # (PK), Cash receipt amount Customer # (FK), Order# (FK), Employee # Check # (FK) (FK), Retailer Cash Receipts Agents Employees Retailer Customers Employee # (PK), Last Name, First Name, Address, City, Zip, Phone, Hire Date, Department, Supervisory Employee # (FK), Salary/Wage, Pay Amount Customer # (PK), Customer Name, Customer Address, Customer City/State/Zip, Customer Phone, Cash receipt # (FK) Sales Rep #, Sales Rep Name, Sales Rep Email Address, Sales Rep Phone, Sales Rep Area Sales Reps Type Images Cobailar Cabriolerade DII Cabrioler Mamae Cabricants Vard HIVIVUIVI Cash (PK), Bank, Account Description, Balance 4/1/18 Events Retailer Order # (PK), Order Date, Requested Inventory # Orders/Sales Date, (FK) Cash receipt # (FK), Order Employee # (FK), Shipping Employee (FK), Shipping Cost Retailer Cash Cash Receipt # (PK), Receipt Amount, Receipts Cash receipt amount Customer # (FK), Order# (FK), Employee # Check # (FK), (FK) Agents Employees Employee # (PK), Last Name, First Name, Address, City, Zip, Phone, Hire Date, Department, Supervisory Employee # (FK), Salary/Wage, Pay Amount Retailer Customers Customer # (PK), Customer Name, Customer Address, Customer City/State/Zip, Customer Phone, Cash (FK) receipt # Sales Reps Sales Rep #, Sales Rep Name, Sales Rep Email Address, Sales Rep Phone, Sales Rep Area Type Images Fabric Colors Fabric Color Code (PK), Fabric Color Name, Fabric Cost per Yard Inventory Types Type Code (PK), Use, Type Description, Yards of Fabric Required Linking Tables Retailer Order/Sales Customer # + Sale (PK), Wholesale Price, Quantity Ordered Items amount Required: This question should be attempted after you complete Exercise Requirement 2. Review the Excel data, prepare the UML class diagram (REA) and then choose the correct fields to complete the table listing below. Resources Finished Inventory Finished Inventory Catalog # (PK), (FK), Color Code (FK), Order # Description, Size, Retail Price, Wholesale Price, Standard Cost (PK), Bank, Account Description, Balance 4/1/18 Cash Events Retailer Orders/Sales Order # (PK), Order Date, Requested Inventory # Date, (FK) Cash receipt # (FK), Order Employee # (FK), Shipping Employee (FK), Shipping Cost Receipt Amount, Cash Receipt # (PK), Cash receipt amount Customer # (FK), Order# (FK), Employee # Check # (FK) (FK), Retailer Cash Receipts Agents Employees Retailer Customers Employee # (PK), Last Name, First Name, Address, City, Zip, Phone, Hire Date, Department, Supervisory Employee # (FK), Salary/Wage, Pay Amount Customer # (PK), Customer Name, Customer Address, Customer City/State/Zip, Customer Phone, Cash receipt # (FK) Sales Rep #, Sales Rep Name, Sales Rep Email Address, Sales Rep Phone, Sales Rep Area Sales Reps Type Images Cobailar Cabriolerade DII Cabrioler Mamae Cabricants Vard HIVIVUIVI Cash (PK), Bank, Account Description, Balance 4/1/18 Events Retailer Order # (PK), Order Date, Requested Inventory # Orders/Sales Date, (FK) Cash receipt # (FK), Order Employee # (FK), Shipping Employee (FK), Shipping Cost Retailer Cash Cash Receipt # (PK), Receipt Amount, Receipts Cash receipt amount Customer # (FK), Order# (FK), Employee # Check # (FK), (FK) Agents Employees Employee # (PK), Last Name, First Name, Address, City, Zip, Phone, Hire Date, Department, Supervisory Employee # (FK), Salary/Wage, Pay Amount Retailer Customers Customer # (PK), Customer Name, Customer Address, Customer City/State/Zip, Customer Phone, Cash (FK) receipt # Sales Reps Sales Rep #, Sales Rep Name, Sales Rep Email Address, Sales Rep Phone, Sales Rep Area Type Images Fabric Colors Fabric Color Code (PK), Fabric Color Name, Fabric Cost per Yard Inventory Types Type Code (PK), Use, Type Description, Yards of Fabric Required Linking Tables Retailer Order/Sales Customer # + Sale (PK), Wholesale Price, Quantity Ordered Items amount

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_2

Step: 3

blur-text-image_3

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

Accounting What The Numbers Mean

Authors: David Marshall

13th Edition

1264126743, 9781264126743

More Books

Students also viewed these Accounting questions

Question

input from elected / appointed officials is import because

Answered: 1 week ago

Question

I need to solve and sketch this problem Sketch g(x) = x 3

Answered: 1 week ago

Question

2. Ask questions, listen rather than attempt to persuade.

Answered: 1 week ago

Question

1. Background knowledge of the subject and

Answered: 1 week ago