Overview

Create an ERD using Lucid Chart for the following description. Be sure to include all necessary entities, attributes, and correct cardinality in relationships between entities. Dont forget foreign keys. This is an individual assignment. Good luck!

Specifications

You have been asked to build a database for a pet store called WeKnowPets. The company owner needs to keep track of the customers that buy their products, the employees that work at WeKnowPets, the offices that the employees use, the vendors that provide them with products, and the products themselves.

Each vendor is supported by at most one employee representative and requires this support. Employees in their first year usually dont have vendors to support, as they are learning the ropes, but as they work there longer and more vendors are reached, they may be assigned one or more vendors. The owner wants to track employee names and email addresses, as well as vendor names and locations.

Employees may share offices at WeKnowPets. Some offices are vacant. Each office has a unique office number, and each employee is assigned to one office.

Vendors provide products to WeKnowPets, like habitats, food, and toys. Each product they sell comes from only one vendor. No products are made in house. The owner wants to track product names and each products unique SKU.

Finally, customers purchase products from WeKnowPets and the data needs to be recorded. Each pet product is often purchased by lots of customers, especially if it is popular. Customers are only put in the system if they have made a purchase, but a product does not need to have been purchased to be stored. The owner wants to keep track of customer names and email addresses.

P.S. please show a diagram for this question.