FiredUp, Inc is a small business owned by Curt and Julie Robards.Based in Brisbane, Australia, FiredUp manufactures and sellsFiredUp, a light-weight camping stove. Recall that Curt used hisprevious experience as an aerospace engineer to invent a burningnozzle 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 thestove directly to their customers over the Internet and via phone.The warranty on the stove covers 5 years of cost-free repair for stoves used for recreational purposes.
FiredUp wants to track every stove and the customer who purchasedit. They want to know which customers own which stoves in casethey need notify customers of safety problems or need to order astove recall. Curt and Julie also want to keep track of any repairsthey 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 tworelationships that FiredUp 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 for one user or for multiple users? Will FiredUp need a personal DBMS, which product will it use? If an enterprise DBMS, which product can't they obtain licence-free?