**NEED HELP MAKING ERD PLEASE FOR THE INFORMATION BELOW**

You are working for a software consulting firm that specializes in writing custom applications for small businesses. Recently your boss assigned you to the Unique Bath Designs account, who needs an application that will be available on a Windows PC, web site and mobile devise. The application needs a database and that is where you come in.

Your boss knows you are taking a database class and needs you to assist the database design and implementation team with the building of the database that will be at the center of this project. Your team has their first meeting with the owner and business manager for Unique Bath Designs and you are excited to attend.

At the meeting the owner and business manager are thrilled your team is starting work on the project. The owner of Unique Bath explains to you what the database needs to do and how the company operates. Unique Bath Design remodels bathrooms. They offer full redesigns or partial redesigns. Meaning that if a customer wishes to have a whole new bathroom, they will do that. Or if a customer wishes to just replace a cabinet or replace a tub, they can do that as well. They offer stock cabinets and custom cabinets.

When they get a call for a quote, a sales representative is sent out to the site. The sales representative speaks with the customer to get an idea of what they want done. Based on these requirements a quote is generated. This quote is very general and does not include particulars such as what type of tile, fixtures, etc. This initial visit is to just provide a ball park estimate for the job. These quotes are stored in the database for future reference and follow-up. They are not directly connected to the orders. When a customer decides to go forward with a sale, the database needs to keep track of the sale, items on the sale and which employees assisted with completed project. Your team asks for a sample copy of what the quote would look like and a sample copy of what an invoice looks like.

As you review the invoice you notice how labor is calculated. On the quote it is estimated. You ask how they calculate labor on the invoice since you see it represented as a line item. The owner clarifies this for you and explains that the labor is included with the installation of the various items. For instance, if a job calls for the installation of white, ceramic subway tile, the cost for the tile is $4.00 per square foot. The labor attached to the installation of that tile is $10.00 per square foot. All products are handled that way. Additionally for each product there is an estimation of how long it will take to complete a particular installation. For instance in tiling our wall, it should take 30 minutes to install one square foot. This helps with scheduling.

As your meeting draws to a close, the business manager begins to describe the reports their system will need. The database needs to show which workers went on which jobs. You can see that many workers can be assigned to many jobs and a job can contain many workers. The business manager also needs to run quarterly reports to see which products and services are selling the most. Finally, since the sales team works on commission, the database needs to track the monthly sales of the different sales representatives.

You and your team leave the meeting with Unique Bath and head back to the office. Your team then meets to discuss the materials they gathered and to go over some notes. Your team summarizes the data requirements to be the following:

Customers: contact data (first name, last name, address, city, etc.)

Products: This includes bath fixtures, lights, doors tile, etc. The database needs to store the name of the product, its description, retail price and wholesale price. It also needs to track who the vendor is.

Vendors: contact data and the main person who is called or consulted.

Quotes: the date the quote was taken, the customer and the sales rep. who took the quote. Additionally the quote will have projected start dates and the various items being quoted.

Orders: order date, start date, end date, sales rep. and items on the order.

Employees: contact data