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 Jul 1988 |
| 248 |
Aetemesia Scud |
Sales |
$33,000 |
20 Feb 200 |
Attachment:- ThudTruckers Inc.rar