Assignment title: Management
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-