Create an ER diagram using the following user requirements for a paint store database:

• Customers have a first and last name, and are uniquely identified by their customer id or by address, which contains a street, city, state, and zip. Customers may have more than one phone number.
• Contractors have a unique business name and can have multiple phone numbers. Contractors also receive a discount on purchases, and the percentage discount must be stored in their record.
• Customers may hire contractors for a certain number of hours, and the total number of hours must be kept in the database. Customers may hire more than one contractor. Contractors work for at least one customer.
• A paint color has a unique identifier that is made up of the color name (e.g. orchid) and the color ID (e.g. A123). The combination is unique, but more than one paint color may use the same color name or use the same color ID.
• Which room a customer is painting gets stored in our database, and all rooms have at least one paint color. The room name is unique for that customer, and rooms cannot be entered without an associated customer. Customers may be entered in the database before they paint a room.
• Customers may have a rewards card, which has a unique ID number and the total reward points. Cards can be made in advance of being assigned to a customer.