Answered step by step
Verified Expert Solution
Link Copied!

Question

00
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 with AI-Powered 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

Entrepreneurship

Authors: Andrew Zacharakis, William D Bygrave

5th Edition

9781119563099

Students also viewed these Accounting questions

Question

Will diversifiable risk be zero if nondiversifiable risk is zero?

Answered: 1 week ago