SALES ORDER Sales order Order Date Value (RM) Customer No. No. A969 14/6/2021 8107.00 16037 S827 16/6/2021 5373.00 15992 S831 23/6/2021 2373.00 15992 (a) Scrutinize the following sets of tables (relations) in Relational Database Manageme Systems (RDBMS). (i) Determine and briefly explain the type of relationship between CAR NO. PLATE an EMPLOYEE tables in the entity relationship diagram below. If Car No. Plate field it the CAR NO. PLATE table is the primary key (PK), then identify and briefly explai the foreign key (FK) field in the same table. CAR NO. PLATE Car No. Plate Parking Lot Employee No. No. WBS 7127 B469 6338 BCS 1325 A405 6007 NAS 3860 C835 6591 EMPLOYEE Employee No. Name Designation Date joined 6007 Wen Jing Business Development 3/4/2012 Manager 6338 6591 Jaffar Moorthy Engineer 5/6/2020 IT Specialist 16/7/2021 (ii) Determine and briefly explain the type of relationship between CUSTOMER and SALES ORDER tables in the entity relationship diagram below. If Customer No. field in the CUSTOMER table is the primary key (PK), then identify and briefly explain the foreign key (FK) field in the SALES ORDER table. CUSTOMER Customer No. Name Location Payment terms 16037 Flexitron Kuala Lumpur 45 days 15992 Sinko Kuching 30 days Tiles 15198 Novotime Bangi 30 days