Answered step by step
Verified Expert Solution
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
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
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