Burn-IT
This presentation is the property of its rightful owner.
Sponsored Links
1 / 19

Burn-IT Solution Package PowerPoint PPT Presentation


  • 53 Views
  • Uploaded on
  • Presentation posted in: General

Burn-IT Solution Package. Integrated Solution. part. LL. 0,N. Item Category. 0,N. 0,1. can-be-put-into. 0,N. code. whole. start- time. end- time. 0,N. description. name. id. ssn. HL. takes. 1,1. HL. 0,1. 1,N. Item. Packing Event. Employee. 0,1. 0,N. 0,1. 1,1.

Download Presentation

Burn-IT Solution Package

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Burn it solution package

Burn-IT

Solution Package


Burn it solution package

Integrated Solution

part

LL

0,N

Item

Category

0,N

0,1

can-be-put-into

0,N

code

whole

start-

time

end-

time

0,N

description

name

id

ssn

HL

takes

1,1

HL

0,1

1,N

Item

Packing

Event

Employee

0,1

0,N

0,1

1,1

puts_into

start-time

id

end-

time

id

id

capacity

description

1,1

LL

Truck

Loading

Event

1,1

0,N

0,1

1,N

1,N

1,1

code

Carrier

1,1

0,N

name

1,1

start-

time

id

Transportation

HL

code

end-

time

Distributor

1,N

0,N

0,1

name

description

balance

amount

date

A/R

number

0,N

accountnumber

amount

1,1

number

Cash

Disbursement

Cash

Cash

Receipt

amount

0,N

0,N

0,N

1,1

0,N

1,1

date

1,1


Burn it solution package

A

I further classify each item as being of category CD, box, or pallet

B

I don’t have any items of category container yet.

C

Obviously, most of our items are CD’s.

Item

Item

Category

1,1

0,N

A

B

C

1


Burn it solution package

First, a packing event takes one or more items … .

Each packing event takes one or more items (at least one).

A

B

First, a packing event … and puts them into another item.

A packing event puts items into exactly one item (logistic unit).

C

Not all items are packed. For example, we don’t pack pallets.

D

An item can be packed only once.

E

A CD cannot be used as a logistic unit.

F

Logistic units such as boxes and pallets are packed at once; i.e,. they participate in one ‘packing event’ only.

G

We expect more than 85% of our items being packed.

A

C

D

G

takes

0,1

1,N

Item

Packing

Event

HL

0,1

1,1

puts-into

2

E

F

B


Burn it solution package

A

…. we assign exactly one ‘supervising’ employee to each packing event …

B

While we assign exactly one ‘supervising’ employee to each packing event, we don’t always record that information. I would be happy if we could record a supervising employee for 90% of our packing events.

C

Todd, one of our employees, supervised more than 100 packing events yesterday.

Melissa, our accountant (and thus an employee) never gets involved with packing events.

D

Packing

Event

Employee

HL

0,1

0,N

B

A

D

C

3


Burn it solution package

A

Not all item categories can be put into other item categories. For example, ‘Pallet’ does not occur in the left column of the ‘can-be-put-into’ table.

B

Not all item categories can be logistic units. For example, ‘CD’ does not occur in the right clumn of the ‘can-be-put-into’ table.

C

“ … an item category can be put into more than one (other) item category and vice versa.”

A

C

part

0,N

Item

Category

can_be_put_into

0,N

whole

B

C

4


Burn it solution package

A

In essence, a loading event puts a number of pallets (at least one) on a truck.

B

“In essence, a loading event puts a number of pallets (at least one) on a truck.” Other items, such as CDs and boxes, do not participate in the relationship with “loading event”; we are only interested in recording which pallets are loaded.

C

A pallet can be loaded only once.

Only pallets are loaded; so, we expect to record a loading event for less than 10% of our items.

D

D

LL

Item

Loading

Event

0,1

1,N

B

C

A

5


Burn it solution package

A

There is exactly one truck per loading event.

B

We ask all carriers to provide us with a list of their truck IDs. A new carrier needs to submit this information (truck IDs) to us at least one week before we schedule a first loading event with that carrier.

C

Most trucks participate in hundreds of loading events.

Loading

Event

Truck

1,1

0,N

A

B

C

6


Burn it solution package

A

There is exactly one carrier per loading event.

B

We ask all carriers to provide us with a list of their truck IDs. A new carrier needs to submit this information (truck IDs) to us at least one week before we schedule a first loading event with that carrier.

C

“Most trucks participate in hundreds of loading events. There is exactly one carrier per truck.” So, most carriers participate in many loading events.

Loading

Event

Carrier

1,1

0,N

A

B

C

7


Burn it solution package

A

There is exactly one carrier per truck.

B

Only carriers for which we know at least one truck are recorded in our database.

C

All carriers we work with have a large fleet of trucks; at least 25 trucks.

Truck

Carrier

1,1

1,N

A

B

C

8


Burn it solution package

A

We also want to record the distribution centers for each of the loading events. So, more than one distribution center can be associated with the same loading event.

B

Finally, we would like to record all distribution centers in the North-East and Mid-Atlantic, even when they don’t do business with us.

C

We have 15 loading events scheduled this week for our biggest distributor; Rock-And-More (located in New Jersey).

D

We record the total ($) amount per loading event per distributor.

D

amount

Loading

Event

Distributor

1,N

0,N

A

B

C

9


Burn it solution package

A

We also have to know which pallet goes to which distributor and this information needs to be recorded in the database. We don’t record distributor information for CDs and boxes (optional participation)

B

There is only one distributor per pallet.

Finally, we would like to record all distribution centers in the North-East and Mid-Atlantic, even when they don’t do business with us.

C

D

Many pallets are of course assigned to the same distributor.

Only pallets are assigned to distributors

E

LL

E

Item

Distributor

0,1

0,N

A

B

C

D

10


Burn it solution package

A

There is exactly one loading event per transportation event.

B

There is exactly one transportation event per loading event.

Transportation

Loading

Event

1,1

1,1

B

B

11


Burn it solution package

Finally, we like to record all distribution centers in the North-East and Mid-Atlantic, even when they don’t do business with us.

A

B

We have received five payments from Rock-And-More this month.

C

We record exactly one distributor for each cash receipt.

Distributor

Cash

Receipt

0,N

1,1

A

B

C

12


Burn it solution package

A

We record exactly one account for each cash receipt.

B

We created a new account yesterday but did not deposit any money in it yet.

C

We put all payments from distributors into the same account.

Cash

Receipt

Cash

1,1

0,N

A

B

C

13


Burn it solution package

A

We pay each of the carriers at the end of the month for all transportation services they have provided during the month. We send them a (one) check at the end of the month.

B

Not al cash disbursements (payments) are for transportation services.

C

More than 95% of the transportation events have been paid.

C

Transportation

Cash

Disbursement

HL

0,1

0,N

A

B

A

14


Burn it solution package

A

There is exactly one account for each cash disbursement.

We created a new account yesterday but did not deposit any money in it yet.

B

C

We currently use one account for all our payments (cash disbursements).

Cash

Disbursement

Cash

1,1

0,N

A

B

C

15


Burn it solution package

A

There is exactly one carrier for each cash disbursement.

We ask all carriers to provide us with a list of their truck IDs (and that information needs to be recorded into the database). A new carrier needs to submit this information (truck IDs) to us at least one week before we schedule a first loading event with that carrier.

B

C

Obviously, we need to record many payments for most of our carriers.

Cash

Disbursement

Carrier

1,1

0,N

A

B

C

16


Burn it solution package

S

4

2

S

S

id

description

ITEMCATEGORY

PACKING EVENT (takes)

Item

1

ITEMCATEGORY

(part)

ITEMCATEGORY

(whole)

S

ItemCategory-ItemCategory

(can-be-put-into)

S

code

description

4

ITEM

DISTRIBUTOR

S

Item-Distributor

ItemCategory

3

1

E

id

start-time

ITEM (puts-into)

end-time

EMPLOYEE

S

ssn

name

PackingEvent

Employee

5

id

start-time

2

E

end-time

TRUCK

CARRIER

ITEM

LOADINGEVENT

LoadingEvent

S

S

E

id

start-time

LOADINGEVENT

CASHDISBURSEMENT

id

capacity

CARRIER

E

code

name

end-time

Truck

Carrier

Transportation

S

3

6

S

S

code

name

A/R

number

amount

accountnumber

description

date

CASH

balance

Distributor

Cash Disbursement

Cash

S

S

E

5

number

amount

DISTRIBUTOR

S

6

date

CASH

DISTRIBUTOR

LOADINGEVENT

amount

Cash Disbursement


  • Login