a) You will need to track data about booth components, equipment, shippers and shipments. List typical fields for each type of data.
b) Could you use a spreadsheet to keep track of this data? What would be the advantages and disadvantages of doing so?
c) Using your answer to part a) give an example of two relationships that you need to track. Show the keys and foreign keys for each.
d) Which of the following components of a database application are you likely to need: data entry form, reports, queries or application programs? Explain one use for each that you will need.
e) Will your application be for one user or for multiple users? Will you need a personal DBMS or an enterprise DBMS? If a personal DBMS which product will you use?

Students will be marked according to the following criteria:
• Answer to the above questions = (16 points)
• Quality of the report = (2 points)
• Mechanics (no misspelling or grammatical errors) = (2 points)

marketing manager

a) You will need to track data about booth components, equipment, shippers and shipments. List typical fields for each type of data.
b) Could you use a spreadsheet to keep track of this data? What would be the advantages and disadvantages of doing so?
c) Using your answer to part a) give an example of two relationships that you need to track. Show the keys and foreign keys for each.
d) Which of the following components of a database application are you likely to need: data entry form, reports, queries or application programs? Explain one use for each that you will need.
e) Will your application be for one user or for multiple users? Will you need a personal DBMS or an enterprise DBMS? If a personal DBMS which product will you use?

Students will be marked according to the following criteria:
• Answer to the above questions = (16 points)
• Quality of the report = (2 points)
• Mechanics (no misspelling or grammatical errors) = (2 points)