About Fixenverleaks, LLC:
Fixinverleaks. LLC is a residential service company that does Plumbing. They want you
to design a database that tracks all jobs for their customers.
A "Job" is a single service call to a customer to fix some sort of plumbing issue. Over
the years, a customer can use Fixinverleaks many times.
For each job, the plumber will record their hours and also record all of the materials used
for the job.
Each Job is for a specific customer and there can be more than one job per customer.
Each job has a status of 'open, 'in process', or 'complete'.
Each job has a start date and end date.
Multiple materials can be used on each job.
Multiple quantities of the same material can be used on each job.
A specific type of material can be used on multiple jobs.
Each material is purchased by the company via a Vendor at a fixed cost per unit.
Each Vendor of the materials must be tracked with the vendor name and address
The number of hours worked (they are billing the customer) by each worker on each job
must be tracked.
The name, hire date, billing rate, hourly pay rate, and skills must be tracked for each
worker.
Workers can have more than one skill.
More than one worker can work on the same job.
A job can be only for one service. If a customer has to have more than one service
completed, a new job will be open for each service.
If a worker is currently active, their termination date will be '1/1/2099'