FiredUp, Inc is a small business owned by Curt and Julie Robards.Based in Brisba
ID: 653303 • Letter: F
Question
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. Indicatepossible fields for each table.b.Could FiredUp use a spreadsheet to keep track of this data? Whatwould 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 andforeign keys for each.d.Which of the following components of a database application isFiredUp likely to need: data entry forms, reports, queries, or application program? Explain one use for each neededcomponent.e.Will this application be for one user or for multiple users? WillFiredUp need a personal DBMS, which product will it use? If anenterprise DBMS, which product cant they obtain licence-free?
Explanation / Answer
The question deals with severals areas of a unique application. Let us start discuss with each part in detail.
(a) How can we design tables and fields based on certain application.
For completing this application at least we need 3 tables.
Table 1: purchase_table:
Bill_No, Model_No, Date_Purchase, Expiry_Date, Customer_Id,Customer_Name,Customer_Address,
where Bill_No and Customer_Id together or individually keep primary key.
Table 2: Complaint_Table
Customer_Id, Complaint_number, Complaint,Under_Warrenty_or_Not
where Customer_id is the primary key for Table 2 and foreign key for Table1
Table 3:Expired_Customers
Customer_Id,Expiration_Date
(b) Obviously we can keep a spreadsheet to follow the data. Proper documentation is the primary step for biggners.
(c) By considering the above tables mensioned,
(1) We can track the customers that have expired date. (Customer_id is the foreign Key)
(2) Also can track how many maintanances a given customer done for a specific product. (Customer_id is the foreign Key)
(d) It should need minimum a query form and report generation to view the status.
The customers need to contact the firm via enquiry form for customer querries.
The firm need a report generation procedure to view the status of the firm at any point of time.
Defenitly the system can be operated under multi user environment.
PostgreSql is an open source DBMS for a small to medium sized organization.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.