Question: SQL Question - Visio I need help creating a visio document containing the tables for the company and the information listed below. Please make sure
SQL Question - Visio
I need help creating a visio document containing the tables for the company and the information listed below.
Please make sure it is 1NF, 2NF, and 3NF (do not worry about 4NF and 5NF).
Here's the information on the company:
Fixinyerleaks, 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 Fixinyerleaks many times. For each job, the plumber will record their hours and also record all of the materials used for the job.
Project Requirements:
Database Design: Design a database in 3rd Normal Form using Visio based on the above project description and the following requirements:
Each Job is for a specific customer and there can be more than one job per customer.
The name and address must be tracked for each customer.
Each job is described by up to 2000 characters.
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, hourly 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.
Thanks in advance!
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
