Question
Create a data model using the REA framework that captures the key economic give and get relationships described in the story below. SGAPS (http://www.sga.net/) is
Create a data model using the REA framework that captures the key economic give and get relationships described in the story below.
SGAPS (http://www.sga.net/) is the largest setting and staging company in the US. It was formed in 2009.
Their business consists of designing, installing, and removing temporary seating and staging. Examples of jobs include the staging for the San Francisco Opera during the renovation of their hall, the seating for the Mormon choir during the Salt Lake Olympics, a formula one race track in Shanghai, 4500 seats at the Preakness in 2008, the platform for a dinner/dance Allstate?s top 3000 salespeople on the beach at Maui, the platform on which the ice is frozen when games are played in the football stadium, extra seats under the score boards for the Super Bowl, etc..
Samples invoices and class receipts have been provided by the client. Use these invoices and cash receipts to develop a data model that allows all of the data on these documents to be stored in the database. Every class (box representing resource, event, or agent) must have at least one attribute. You will need to identify the appropriate attributes by looking at these documents.
Since the only information you have are these two sets of documents, you do not have a complete picture of all of the attributes that might be necessary to include in the database. In addition to attributes you identify from the documents, also add whatever additional attributes would be needed to have the necessary information to identify and bill for overdue customer payment amounts.
Your consulting company has already informed SGA that you will be adding attributes to their database to help improve their ability to track information. Specifically, you will need to include the following in your data model:
Employee #, Account #, Customer #
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