Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Oracle9i Database Administrator Implementation And Administration

Authors: Carol McCullough-Dieter

1st Edition

0619159006, 978-0619159009

More Books

Students also viewed these Databases questions

Question

6. Name the six virtues, and one related strength for each.

Answered: 1 week ago