BurnIT

1
Burn-IT Solution Package
2
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
name
description
id
ssn
HL
takes
1,1
HL
0,1
1,N
Item
Packing Event
Employee
0,1
0,N
1,1
0,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
Transportation
id
HL
code
Distributor
end- time
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
0,N
1,1
1,1
date
1,1
3
A
I further classify each item as being of category
CD, box, or pallet
B
I dont have any items of category container yet.
C
Obviously, most of our items are CDs.
Item
Item Category
1,1
0,N
C
A
B
1
4
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 dont
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.
We expect more than 85 of our items being packed.
G
A
C
D
G
takes
0,1
1,N
Item
Packing Event
HL
0,1
1,1
puts-into
2
B
E
F
5
A
. we assign exactly one supervising employee
to each packing event
B
While we assign exactly one supervising
employee to each packing event, we dont 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
C
A
D
3
6
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.
C
A
0,N
part
Item Category
can_be_put_into
0,N
whole
B
C
4
7
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
1,N
0,1
A
B
C
5
8
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
C
B
A
6
9
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
C
B
7
10
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
B
A
C
8
11
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 dont 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.
amount
D
Loading Event
Distributor
1,N
0,N
B
A
C
9
12
A
We also have to know which pallet goes to which
distributor and this information needs to be
recorded in the database. We dont 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 dont do business with us.
C
D
Many pallets are of course assigned to the same
distributor.
Only pallets are assigned to distributors
E
E
LL
Item
Distributor
0,1
0,N
B
A
D
C
10
13
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
14
Finally, we like to record all distribution
centers in the North-East and Mid-Atlantic, even
when they dont 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
1,1
0,N
A
B
C
12
15
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
B
C
A
13
16
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
A
B
14
17
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
B
C
A
15
18
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
B
C
A
16
19
4
S
2
S
id
description
ITEMCATEGORY
PACKING EVENT (takes)
S

Item
1
ITEMCATEGORY (whole)
ITEMCATEGORY (part)
S
ItemCategory-ItemCategory (can-be-put-into)
S
code
description
DISTRIBUTOR
ITEM
4
Item-Distributor
S
ItemCategory
3
id
start-time
1
E
ITEM (puts-into)
end-time
EMPLOYEE
ssn
name
S

PackingEvent
Employee
5
id
start-time
end-time
E
2
TRUCK
CARRIER
LOADINGEVENT
ITEM
LoadingEvent
S
S
E
id
capacity
code
name
CARRIER
E
id
start-time
end-time
LOADINGEVENT
CASHDISBURSEMENT

Truck
Carrier
Transportation
S
3
6
S
name
A/R
S
code
number
amount
accountnumber
description
date
balance
CASH
Distributor
Cash Disbursement
Cash
S
E
5
S
number
amount
date
CASH
DISTRIBUTOR
S
6
LOADINGEVENT
DISTRIBUTOR
amount
Cash Disbursement