Answered step by step
Verified Expert Solution
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.
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 amountStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started