Purchase Invoice Invoice Number: Date: Staff Name: PH-00001 11/12/2021 Mohd Al-Amin Supplier Number: 400001 Supplier Name: Eco Gym Sdn Bhd Address: 17-13 Jalan Tengah 68200 Postcode: City: Batu Caves State: Selangor Darul Ehsan Mobile Number: 010-686-9898 Item Number Description Quantity T-24 Treadmill SM24 S75 Junge DM75 Unit Price 2400 1,400 Amount 2.400.00 2.800.00 TOTAL 5,200.00 Based on the above purchase invoice. You are required to answer the following questions: a. Identify the tables you will need to design the purchase invoice. (4 marks) b. List the attributes for each table from the list of tables you have identified in Question 3(a). Determine the data type as well as the primary key, foreign key (if any) or composite key (if any). Present your answers in the following format: Tables Attributes Key Data Type (6 marks) c. Design a relational database model in third normal form (3NF) based on your answers in Question 3(a) and 3(b), showing the relationship between tables for the purchase invoice. Clearly show the association and the cardinalities (Ignore the 'Amount' and 'Total' attributes)