You are an analyst for the national home improvement chain business Home Garden DIY, which is now creating an online presence One method to better serve clients is to provide them the option to put products in a virtual shopping cart and have them ready for pick up or delivery By offering a more convenient shopping experience, management intends to decrease foot traffic in stores and enhance sales Requirements List One customer can place an order for many products at a time Many different customers may order any particular product Workers at the warehouse keep track of orders while they fulfill and ship them Customer service representatives should be able to review any customer's orders, whether they are being fulfilled, in transit, or delivered All orders include the date the order was placed by the customer, the date the order shipped, and the date the order was delivered Five warehouses are available for shipping The warehouses are located in Chicago, Denver, Los Angeles, Miami, and New York Merchandise is always in stock Zip code proximity determines warehouse association Customer can only order from the closest warehouse to the receiving address Orders ship by weight and size Weight of any package cannot exceed 70 pounds Size cannot exceed 3 meters square Customers can cancel orders and return products up to four times a month Different systems are used to process customer payments and manage inventory Employee job types include warehouse worker, customer service representative, administrative staff, or management Employees are assigned to a single warehouse Only warehouse workers must work in the warehouse, all other employees have the option of working remotely from any location Complete the following tasks In the list of needs, identify 5 8 entities Make sure the entities you choose permit you to store all required data Keep in mind that entities are things about which you must record data in the database Whether you require more than five to eight entities, you must examine them to see if any can be com For each entity you chose, make a list of its properties To satisfy the system data requirements, attributes describe the information you must include in each entity Always keep in mind that characteristics represent information about entities, not actual entities Include a documented justification outlining how the given scenario's data needs are met by the list of entities and characteristics The Employee entity and recommended attributes are presented below as a starting point If you feel that they are required to meet the scenario's data needs, you may add more attributes One of the entities you identify from the criteria listing will be this one Employee Emp Last Name Emp First Name Emp Street Addr Emp Street Name Emp City Emp State Emp Zip Emp Job Code Emp PayRate Emp Start Date Emp Warehouse ID

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jan 30, 2024

You are an analyst for the national home improvement chain business Home & Garden DIY, which is now creating an online presence. One method to

You are an analyst for the national home improvement chain business Home & Garden DIY, which is now creating an online presence. One method to better serve clients is to provide them the option to put products in a virtual shopping cart and have them ready for pick-up or delivery. By offering a more convenient shopping experience, management intends to decrease foot traffic in stores and enhance sales.

Requirements List

One customer can place an order for many products at a time.
Many different customers may order any particular product.
Workers at the warehouse keep track of orders while they fulfill and ship them.
Customer service representatives should be able to review any customer's orders, whether they are being fulfilled, in transit, or delivered. All orders include the date the order was placed by the customer, the date the order shipped, and the date the order was delivered.
Five warehouses are available for shipping. The warehouses are located in Chicago, Denver, Los Angeles, Miami, and New York.
Merchandise is always in stock. Zip code proximity determines warehouse association. Customer can only order from the closest warehouse to the receiving address.
Orders ship by weight and size. Weight of any package cannot exceed 70 pounds. Size cannot exceed 3 meters square.
Customers can cancel orders and return products up to four times a month.
Different systems are used to process customer payments and manage inventory.
Employee job types include warehouse worker, customer service representative, administrative staff, or management.
Employees are assigned to a single warehouse. Only warehouse workers must work in the warehouse, all other employees have the option of working remotely from any location.

Complete the following tasks:

In the list of needs, identify 5-8 entities. Make sure the entities you choose permit you to store all required data.

Keep in mind that entities are things about which you must record data in the database.
Whether you require more than five to eight entities, you must examine them to see if any can be com

For each entity you chose, make a list of its properties. To satisfy the system data requirements, attributes describe the information you must include in each entity. Always keep in mind that characteristics represent information about entities, not actual entities.
Include a documented justification outlining how the given scenario's data needs are met by the list of entities and characteristics.
The Employee entity and recommended attributes are presented below as a starting point. If you feel that they are required to meet the scenario's data needs, you may add more attributes. One of the entities you identify from the criteria listing will be this one.

Employee

Emp_Last_Name

Emp_First_Name

Emp_Street_Addr

Emp_Street_Name

Emp_City

Emp_State

Emp_Zip

Emp_Job_Code

Emp_PayRate

Emp_Start_Date

Emp_Warehouse_ID