Samantha Green owns and operates Twigs Tree Trimming Service. Recall from Chapter 3 that Samantha has a degree from a forestry program, and recently opened her business in Winnipeg. Her business consists of many one-time operations (e.g., removing a tree or stump), as well as recurring services (e.g., trimming customers’ trees every year or two). When business is slow, Samantha calls former clients to remind them of her services and of the need to trim their trees on a regular basis.
a. Name and describe the tables of data that Samantha will need in order to run her business. Indicate possible fields for each table.
b. Could Samantha 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 Samantha needs to track. Show the keys and foreign keys for each.
d. Which of the following components of a database application is Samantha likely to need: data entry forms, reports, queries, or application program? Explain one use for each that she needs.
e. Will this application be single-user or multi-user? Will she need a personal DBMS or an enterprise DBMS? If she needs a personal DBMS, which product will she use?