Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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 #

image text in transcribed

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

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

Financial Accounting

Authors: Jeffrey Waybright, Robert Kemp

1st Edition

013606048X, 9780136060482

More Books

Students also viewed these Accounting questions