Question Details

[solution] » Normalization The shipping department at Helen's Natural

Brief item decscription

Step-by-step solution file


Item details:

Normalization The shipping department at Helen's Natural
More:

Normalization

The shipping department at Helen?s Natural Spices, LLC would like to create an information system to track shipments that come into and leave from the loading docks. Before the system can be built, a database must be designed to support the system. The systems analyst conveyed to you a few of the business requirements for the system and provided the sample data below.

· Currently, all data is stored in an Excel spreadsheet

· A record of who packed each sent package must be maintained and who double-checked each package before it was sent. A record of who unpacked all received packages must be maintained as well for auditing purposes. The employee that packs each sent package and the employee that unpacks each received package are referred to as a handler (see columns labeled handled_by_employee and handled_by_employee_id). The employee that double-checks each sent package is referred to as a checker (see columns labeled checked_by_employee_id and checked_by_employee). One employee cannot both pack and double-check a package. All employees that work on a package and the task they performed (e.g., handler, checker) should be stored.

· All products are sold in tins of varying sizes.

Use the information provided to develop normalized data tables in MS Word (through 3NF). After developing the data tables, create the corresponding logical ER model in MS Visio.

package_carrier

tracking_no

weight

ship_type

handled_by_employee_id

handled_by_employee

checked_by_
employee_id

checked_by_employee

contents (name and ID) and quantity of each

date_recorded

UPS

1Z993

2.1

sent

3

Alan Meyer

6

Katherine Powell

2 cumin #1, 4 cinnamon #7

10-10-13

FedEx

73491

received

9

Maggie Ingram

2 black pepper #2, 1 white pepper #3

10-10-13

UPS

1Z234

7.6

sent

6

Katherine Powell

9

Maggie Ingram

1 oregano #4, 1 salt #8

10-10-13

FedEx

39401

8.5

sent

9

Maggie Ingram

3

Alan Meyer

9 black pepper #2, 3 salt #8

10-11-13

USPS

43212

received

3

Alan Meyer

50 cinnamon #7

10-11-13

 







About this question:
STATUS
Answered
QUALITY
Approved
ANSWER RATING

This question was answered on: Feb 21, 2020

PRICE: $24

Solution~00066612969.zip (18.37 KB)

Buy this answer for only: $24

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free copy (Deadline assured. Flexible pricing. TurnItIn Report provided)

Pay using PayPal (No PayPal account Required) or your credit card. All your purchases are securely protected by PayPal.
SiteLock

Need a similar solution fast, written anew from scratch? Place your own custom order

We have top-notch tutors who can help you with your essay at a reasonable cost and then you can simply use that essay as a template to build your own arguments. This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student. New solution orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

Order Now