Burn-IT Solution Package

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 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

3. 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

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 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

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 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

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.” A C part 0,N 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 0,1 1,N B C A 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 A B C 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 B C 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 A B 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 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

12. 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

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 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

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 A B C 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 B A 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 A B C 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 A B C 16

19. 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