Reference no: EM132921584
-You are designing a database for sales inquiries. Prospective customers call or email with questions about various products. Each inquiry is handled by a salesperson.
Customers are identified by their email addresses. They also need to provide their name and cell phone number to receive response.
Salespersons are identified by Employee ID. You also need to store Employee's name, email, cell phone number and designation.
Products are identified by Product ID. You need to store product name, price, and a description.
Inquiries and replies can be stored in the same table. Use a field called Message to store text from both inquiries and replies. This entity should indicate who sent the message and when. This entity, obviously, links to products for which the inquiry is sent, as well as customers and employees.
Create the ERD in Lucid Chart. The ERD must show all attributes of all entities. ERD should show Primary and Foreign keys as well as all relationships with cardinalities and modalities.