Below are 12 pieces of data an organisation captures for their operations. Supplier Employee tax file number Date Item description Invoice number Item number Employee name Purchase order number Customer number Total amount sold Quantity on hand 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) 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)