Question: Examine the REA model for Hera Industrial Supply that appears in Figure. For each of the six entities in the model, list the attributes that

Examine the REA model for Hera Industrial Supply that appears in Figure.

For each of the six entities in the model, list the attributes that a database designer should include in each table. Identify primary key attributes with (PK) and composite primary key attributes with (CPK). State any assumptions you needed to make, and be prepared to defend the rationale for the attributes you havechosen.

Employees (Salesparsons) Sales Orders Inventory Customers Sales Cash Receipts

Step by Step Solution

★★★★★

3.44 Rating (160 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Customers Sales Sales Orders CustomerNumber PK InvoiceNumber PK SalesOr... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

353-B-A-I-S (4500).docx

120 KBs Word File

Students Have Also Explored These Related Accounting Questions!

harry jones, CEO of halifax Inc has recently heard a lot about big data analytics and wants to initiate a data analysis program in the company which has a substantial volume of historic structures...

Examine Figure which contains the REA model for Hera Industrial Supply (HIS). The model is partially completed; it includes all entities and relationships, but it does not include cardinalities or...

State two conditions that indicate when a database designer should consider using supertype/subtype relationships.

Transform the database structure that appears in Figure into 3NF. Be sure to show your intermediate steps of 1NF and2NF. SOFTWARE PACKID TAGNUM COMPID INSTDATE SOFTCOST EMPNUM EMPIAME LOCATION...

Entity Relationship Diagram Practice Examine the following figure. The model is partially completed; it includes all entities and relationship, but it does not include cardinalities or descriptions...

My name is Salam Abdulhussein and I need this to be done as soon as possible. Please follow the steps one by one and make sure everything is correct Global Bike, Inc. ERP for Sales / Collection USING...

Bacteria and other microbes can be used to "clean up" an oil spill by breaking down oil into carbon dioxide and water. Two samples isolated from the Deepwater Horizon leak in the Gulf of Mexico were...

To read the article describing the components of Payn'e CRM Framework The link below also describes the framework and gives you some insights in relation to how to apply it...

Please help me make an Executive Summary. Explain what you will examine in the case study. Write an overview of the field you are researching. Make a thesis statement and sum up the results of your...

CASE STUDY RESEARCH TOPIC SELECTED - INTERNATIONAL FINANCIAL CRISES I choose covid-19 for my international financial crises case study. please answer 1. Context background information, business...

Using the REA model in Figure and your answers to Discussion Questions create a database for HIS in the software package of your choice. This will require that you do the following: a. Create tables...

Wildhorse Co. gathered the following information on power costs and factory machine usage for the last six months: Month Power Cost Factory Machine Hours January $29.020 16,100 February 36,980 22,000...

Robin Limited(Robin)purchased a piece of equipment and it was fully operational as of 1 February 2019. The equipment was purchased for $320,000. In addition to the purchase price, Robinspent $40,000...

Describe the long run behavior of f ( p ) = - 2 ( p - 3 ) ( p - 1 ) ( p + 4 ) ^ 2

Identify the main product of the following chemical reactions. If no reaction occurs, write N.R OH 180C CH3 H* CH3 (0] CH3 CH KMNO,

What is the major product of the following reaction? Hz. Lindlar cat OA OB. OC D.

Valerie Lawson and Clara Norman are the sole equal shareholders in the corporation of Lawson And Norman Enterprises, Inc. The corporation, which is a retail office supplies and stationery store,...

Fe 20 3(s) + 3H 2(g) For the reaction above, calculate the standard Gibbs' Free energy change at 700 K. 2Fe (s) + 3H 20 (g)

A compound with a retention time of 465.7 has a width at half height of 8.8 on a column 17.3 meter long. Calculate the helght of a theoretical plate in mm? Select one: Oa. 1,113 Ob.0,126 Oc.0.039 Od....

Discuss the historical origins and development of criminal homicide into murder and manslaughter. Can you distinguish between murder and manslaughter?

Use the Customers table in the BSN database that accompanies this book and the Report Wizard to create the report in Figure. Note that you will have to reformat and perhaps reposition several labels,...

The BSN Company requires a form with which to view its existing suppliers conveniently and also to create records for new suppliers. Figure contains a suggested format for this form. Requirements: a....

Create the form in Figure and then add a subform to it that shows purchase orders for each vendor. Figure provides a suggested format. To accomplish this task, follow these steps: (1) Start with the...

THIS IS A SOCIAL SECURITY BENEFIT PROBLEM. I ONLY NEED TO KNOW HOW WE FIND THE ACUTAL EARNINGS. BOTH MARY AND BROW ARE 30 YEARS OLD. DAVID MAKES $66,000 A YEAR AND MARY MAKES $26,000 A YEAR. DAVID'S...

QUESTION 46 Which of the following is the lowest rating of a bond from Fitch and Standard and Poor's that is still classified as investment grade? O a.D b. Caa O BBB- d.B QUESTION 47 A bond which was...

Today, you want to sell a $1,000 face value zero coupon bond you currently own. The bond matures in 3.5 years, how much will you receive for your bond if the market yield to maturity is currently...