$2.$ The Invoice Database $(12$ points$)$ You are building a database for an apparel company that sells designer clothes and accessories to clothing stores. The requirements are listed below:

$$ An invoice is written by a single sales representative $($SALESREP$).$ Each salesrep can write many invoices.

$$ Each customer can have many invoices. An invoice must have a customer on it$.$

$$ An invoice includes one to many detail line items $($LINE$).$ A line item describes one product sold to the customer and its quantity. $($Several products can be included in one invoice.$)$

$$ Each product must have one vendor, and each vendor may supply several products. Some vendors$$ data is still needed even the vendor does not sell any products to your company.

$$ An ID is needed for each entity. Data needed in the database includes $($separate the attributes into smaller attributes when appropriate$)$:

$$ A sales representative$$s first name and last name,

$$ A customer$$s store name, address, and phone number

$$ A vendor$$s name, address, and phone number

$$ Invoice total amount, date

$$ A product$$s name and description