Question
Martha Green owns and operates Twigs Tree Trimming Service. Martha graduated from the forestry program and worked for a large landscape design firm that performs
Martha Green owns and operates Twigs Tree Trimming Service. Martha graduated from the forestry program and worked for a large landscape design firm that performs tree trimming and removal. After several years of experience, she bought her own truck, stump grinder, and other equipment and then opened her own business in St. Paul, Minnesota.
Although many of her jobs are one-time operations to remove a tree or stump, others are recurring: trimming a tree or group of trees every year or every other year. When business is slow, she calls former clients to remind them of her service and of the need to trim their trees on a regular basis.
Martha keeps the following data about each of her jobs:
OwnerName, Phone, Street Address, City, State, Zip, DateOfService, Description, AmountBilled, AmountPaid, DateOfPayment.
Assume that Martha stores this data as a list in a spreadsheet. The following is just a sample of her more than 600 job records.
Bob Black | 612 6578900 | 670 Pine Tree Road | St. Paul | MN | 55113 | 3/4/19 | 5 trees removed | $400 | $200 | 5/10/19 |
Bob Black |
|
|
|
|
|
|
|
| $100 | 6/10/19 |
Bob Black |
|
|
|
|
|
|
|
| $100 | 7/20/19 |
Jenny Love | 612 2349032 | 234 A Street | St. Paul | MN | 55118 | 1/7/20 | 3 tree trimmed | $120 | $120 | 2/1/20 |
Chris Winter | 320 4536789 | 267 4th Ave. | St. Paul | MN | 55103 | 8/4/20 | 2 stumps removed | $78 | $78 | 9/15/20 |
Jenny Love | 612 2349032 | 234 A Street | ST. Paul | MN | 55118 | 10/2/20 | 2 trees trimmed | $126 | $50 | 10/2/20 |
Jenny Love |
|
|
|
|
|
|
|
| $76 | 11/5/20 |
Dan Tan | 320 6564568 | 2345 Oak Tree Street | St. Paul | MN | 55103 | 12/7/20 | 5 tree stumps removed | $300 | $100 | 12/7/20 |
Dan Tan |
|
|
|
|
|
|
|
| $200 | 1/10/21 |
- Describe potential problems Martha can have when storing the data in this manner.
- If you develop a relational database for Martha, how many tables would you use in order to eliminate the problems? Draw the table structures you would recommend. And show records in each table.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started