I have an MISC assignment

ThudTruckers, Inc. Data Requirements Description

My name is Rick Romano. I own a truck rental business here in Spokane. The way my business

works is this:

We don't actually own any trucks. What we do is match up customers (who have different

requirements for size of trucks) with independent local truckers. The customers all have different

requirements as to size of truck needed and pickup/delivery points. The truckers each own their

own truck (different sizes) and are available on different dates. We have standard rates for each

size of truck, and we make our money by taking a small slice of that before we pass it on to the

truck owner. I need a way to keep track of both sides of my business – the trucks for hire and the

customers who hire them.

Based on the description above, and the sample forms on the next page, your assignment is to

produce the following. DON”T DO ANY DRAWINGS. I JUST WANT TYPED LISTS:

1. (5 points) What's in the Context Data Flow Diagram. LIST the external agents and say what their interaction is. Example: Librarian. Inputs book ID and user ID. Gets back

printed checkout card.

2. (5 points) DFD. One possible process for this system is “Select a truck for the customer and notify the owner”. LIST the agents, processes, and data stores that directly interact

with this process.

3. (5 points) ERD. LIST the entities and their key fields

Instructors Note: Some forms used by the firm are shown on the back of this sheet. Note that

forms are not tables. They might contain too much or not enough information. They are

certainly not in 3NF.

Sample Customer Form

Date: June 10 2014

Cust Number Order No 12891 342-2014

Customer Name: Ms. Normandie Pike, BAB (MIS)

127 North 17th Street Cheney, WA 99004

Size and type of truck: Small moving van

Start date 14 June 2014

End date 16 June 2014

Special

instructions

To support move from student dorms to new job

in Omak

Truck Rental ID 342-2-2014

Sample Truck Form

Truck owner

Ralph Simpson

Address 2486 First Street

Sprague, WA

99064

Truck type Small moving van

Truck 343

Availability I use it for personal business M-W, but it's available from 6PM

Wednesday night to 6PM Sunday night. If it's a local rental, I

can make it available 6Pm-10PM on M-W, as well

Standard Rate $30.00 per hour

Sample Rental Form

Truck owner

Ralph Simpson

Customer N. Pike

127 North 17th Street Cheney, WA 99004

Rental dates Step van

Truck rental ID 343

Start date 14 June 2014

End date 16 June 2014

Truck Rental ID 342-2-2014