Design an ERD and SQL for the following situation. Express any many to many relationships with an associative entity.A retailer wants to maintain a database with the following business rules:

a$.$ All people in the database must have basic demographics attached to them $($name$,$

mailing address, email address, and phone number$)$

b$.$ A CUSTOMER must be tracked by shipping information

c$.$ A SALESREP has an employee number and is given a company email address

Page $3$ of $3$

d$.$ An INVOICE is written by a SALESREP. Each sales representative can write many invoices,

but each invoice is written by a single sales representative. Each invoice also includes

sales information like date, tax and total.

e$.$ The INVOICE is written for a single CUSTOMER. However, each customer can have many

invoices.

f$.$ An INVOICE can include many detail lines $($LINE$),$ each of which describes one product

bought by the customer. That line indicates quantity purchased in the sale.

g$.$ The product information is stored in a PRODUCT entity. Products must include a

description, the price of the product and the quantity on hand for the retailer.

h$.$ The product$$s vendor information is found in a VENDOR entity. It includes the vendor$$s

name and a contact person at the vendor.