Fired Up, Inc., is a small business owned by Curt and Julie Robards. Based in Brisbane, Australia, Fired Up manufacturers and sells Fired Now, a lightweight camping stove the. Recall from Chapter 3 that Curt used his previous experience as an aerospace engineer to invent a burning nozzle that enables the stove to stay lit in very high winds. Using her industrial design training, Julie designed the stove so that it is small, lightweight, easy to set up, and very stable. Curt and Julie sell the stove directly to their customers over the Internet and via phone. The warranty on the stove covers five years of cost free repair for stoves used for recreational purposes.
Fired Up 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 Fired Up will need. Indicate possible fields for each table.
b. Could Fired up 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 Fired Up needs to track. Show the keys and foreign keys for each.
d. Which of the following components of a database application is Fired Up likely to need: data entry forms, reports, queries, or application program? Explain one use for each needed component.
e. Will this application be single-user or multi-user? Will Fired Up need a personal DBMS or an enterprise DBMS? If they need a personal DBMS, which product will it use? If they need an enterprise DBMS, which product can they obtain license-free?