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. 

 ii. Name two other items that you would add to each of the tables. What type of key would these items be:

 

. Below are 12 pieces of data an organisation captures for their operations. Supplier Employee tax file number Invoice number Item description Employee name Total amount sold Purchase order number Quantity on hand Date Item number Customer number Customer name