Question
WILL DEFINITELY RATE IF CORRECT! Create an ERD using Lucid Chart for the following description. Be sure to include all necessary entities, attributes, and correct
WILL DEFINITELY RATE IF CORRECT!
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 technology company called TechNow. The company owner needs to keep track of the customers that buy their products, the employees that work at TechNow, the positions offered to employees that work at TechNow, the offices that the employees use, the vendors that provide them with products, and the products themselves. Each vendor interacts with 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 at most one vendor. The owner wants to track employee first names, last name, email addresses, and phone numbers, as well as vendor names, phone numbers, and the name of the contact representative at the vendor. If they perform their duties primarily in person, an employee may share an office at TechNow. No office is vacant. However, some employees work fully remotely and are not assigned a physical office. TechNow tracks each offices capacity and unique room number. When hired, each employee is assigned a specific position during their time at TechNow. When they are promoted, they are assigned a new position and information related to their original position is overwritten. TechNow stores the title, minimum salary, and maximum salary cap of each position. Not every position is held at any given time at TechNow, and several employees may hold a specific position.
Vendors provide products to TechNow, like hard drives, desktop cases, and power sources. Each product they sell comes from only one vendor, although some products are made in house. If a vendor is in the system, they must have provided a product. TechNow tracks product names, prices, and each products unique SKU. Finally, enterprise customers purchase products from TechNow and the data from the transactions 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 first names, last names, and email addresses.
Please show the relationship cardinality between the two entities for each. Example: (VENDOR-|o----|<-EMPLOYEE)
Select all that apply:
SKU is a virtual/artificial key
RoomNumber is a foreign key in the EMPLOYEE entity
SKU is a foreign key in the CUSTOMER entity
RoomNumber is a simple key
EmployeeID is a foreign key in the VENDOR entity
CustomerID is a foreign key in the PRODUCT entity
There are six foreign keys in the diagram
There are six foreign keys in the diagram
PositionID is a foreign key in the EMPLOYEE entity
There are five foreign keys in the diagram
SKU is a foreign key in the VENDOR entity
VendorID is a foreign key in the PRODUCT entity
VendorID is a foreign key in the EMPLOYEE entity
There is at least one composite key in the diagram
WILL DEFINITELY RATE IF CORRECT!
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