Question
Use the following summary of the Revenue cycle for Smetz Tire Co. to prepare an REA Data Model for the Revenue Cycle, including cardinalities using
Use the following summary of the Revenue cycle for Smetz Tire Co. to prepare an REA Data Model for the Revenue Cycle, including cardinalities using LucidChart. ALSO, create the appropriate table structures which would be implemented in a relational database for this model.
Smetz Tire Co. serves individual and corporate customers by selling tires, installation and brake repair services. All customers schedule appointments for tire installations and/or brake repair services with a customer service representative who sets up the appointment. The tire installations and/or brake repair services are completed by one of the tire/brake services professional. Individual customers pay for sales and services when the customer comes in at their scheduled appointment time. Corporate customer sales are made on account and corporate customers receive a statement each month for all sales and services during the month. Payment from corporate customers is due within 30 days of the date of the statement. All customer cash receipts are handled by a cash receipts clerk.
Step 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