Below figure shows the ER diagram that captures important information about customers, supplier and orders in car parts business.   Convert the ER diagram into a relational database schema. Be certain to indicate primary keys                                     Eg. Suppliers (SupplierID:Number(PK); Supp_contact: Number)

 b.      Briefly describe the term "Bridging table" and explain the use of bridging tables in database development, with a suitable example.

Transcribed Image Text:

Data model for Customer and Car parts Customer ID Name Contact OrderID Date Staff_ID Deepani | March 13, 2019 Suppliers Supplier_ID Supp_Contact Orders PartID Parts Part_description Data model for Customer and Car parts Customer ID Name Contact OrderID Date Staff_ID Deepani | March 13, 2019 Suppliers Supplier_ID Supp_Contact Orders PartID Parts Part_description