FiredUp wants to track every stove and the customer who purchased it. They want to know which customers own which stoves in case they need to notify customers of safety problems or need to order a stove recall. Curt and Julie also want to keep track of any repairs they have performed.

a. Name and describe tables of data that FiredUp will need. Indicate possible fields for each table.

b. Could FiredUp use a spreadsheet to keep track of this data? What would be the advantages and disadvantages of doing so?

c. Using your answer to question

a, give an example of two relationships that FiredUp needs to track.

Show the keys and foreign keys for each.

d. Which of the following components of a database application is FiredUp likely to need: data entry forms, reports, queries, or application program? Explain one use for each needed component.

e. Will this application be for one user or for multiple users? Will FiredUp need a personal DBMS or an enterprise DBMS? If a personal DBMS, which product will it use? If an enterprise DBMS, which product can they obtain license-free?