I have an MISC assignment

1- Look at the ThudTruckers file, and based on that description, draw the Context Data Flow

Diagram. Include all external agents and say what their interaction is.

2- Look at the ThudTruckers file, and based on that description, draw me a DFD for the process

“Select a truck for the customer and notify the owner”. Include the agents,

processes, and data stores that directly interact with this process.

3- Look at the ThudTruckers file, and based on that description, draw a 3NF ERD

on a separate piece of paper.

4- Shown below is a proposed table structure for a different part of the ThudTruckers information system. Is this table in second normal form? If it is, what makes you think

so? If it is not, list a table layout that will make it 2NF. (you don't have to include any of

the data, just column names and key fields)

Emp_ID

(PK)

Name Dept Salary Date of Hire

987 Mustrum Ridcully Sales $32,000 14 Oct 1995

598 Esmeralda

Weatherwax

Sales $36,000 14 July 1988

248 Artemesia Scud Sales $33,000 20 Feb 2000 5-