Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

a. Below are 12 pieces of data an organisation captures for their operations. Supplier Employee tax file number Item description Invoice number Employee name Purchase

image text in transcribed

a. Below are 12 pieces of data an organisation captures for their operations. Supplier Employee tax file number Item description Invoice number Employee name Purchase order number Total amount sold Quantity on hand Date Item number Customer number Customer name i. Apply the relational data base design requirements to create the appropriate relational database tables to capture data for the revenue cycle. You need to clearly identify the primary key (PK), the foreign key(s) (FK) and non-key (NK) items. (3 marks) ii. Name two other items that you would add to each of the tables. What type of key would these items be? (3 marks) b. Henry Harris Pty Ltd (HH) is expanding its operations interstate and their current accounting system is off the shelf, storing all data on a local server. As they are rapidly growing, HH are looking to implement an enterprise resource planning (ERP) system. Would you also recommend they implement a database? Why or why not? Discuss. (4 marks) In the answer box below, write the letter and your

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_2

Step: 3

blur-text-image_3

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

Computerized Accounting With Quickbooks 2018

Authors: James B. Rosa, Kathleen Villani

1st Edition

0763882674, 9780763882679

More Books

Students also viewed these Accounting questions

Question

1. Let a, b R, a Answered: 1 week ago

Answered: 1 week ago

Question

2. How is communication defi ned?

Answered: 1 week ago

Question

=+Understand the different types of personal brands in social media

Answered: 1 week ago