Question
Can you create an ERD using Lucid Chart for the following description. Be sure to include all necessary entities, attributes, and correct cardinality in relationships
Can you 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. You have been asked to build a database for a sportswear company called AthFleet. The company owner needs to keep track of the customers that buy their products, the employees that work at AthFleet, the vendors that provide them with products, and the products themselves. Each vendor has contact with one employee representative and needs 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 their only vendor. The owner wants to track employee names and email addresses, as well as vendor names and locations. Vendors provide products to AthFleet, like shoes, apparel, and equipment. Each product they sell comes from only one vendor. Some products are made in house, but if a vendor is in the system they must have provided a product. The owner wants to track product names and each products unique SKU. Finally, customers purchase products from AthFleet and that transactional data needs to be recorded. Each 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. Can you do with nice and clearly.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started