An E-R Diagram references

Create an E-R Diagram references the entities shown below (the Consultant, Client and Work Order).
• Make sure to specify the primary key for each entity (reference the entity-relationship (E-R) diagram on page 6 l
Database)
Next, Create a Database named TAL – your first initial and last name using Microsoft Access (ex: TAL – LDavis).
the (Consultant, Client and Work Order ) entities shown below.
WEEK#3 TABLE/ENTITES
Consultant – TABLE/ENTITY
FIELDS:

1. Consultant ID
2. Consultant Name
3. Consultant Client Location
4. Consultant Manager
5. Work ID
   Client– TABLE/ENTITY
   FIELDS:
6. Client ID
7. Work ID
8. Client Name
9. Client Location
10. Client Start Date
    Work Order– TABLE/ENTITY
    FIELDS:
11. Work ID
12. Work order Item No
13. Work Order Desc
    https://books.google.com/books?id=IGj6DwAAQBAJ&pg=PA10&lpg=PA10&dq=ER+diagram+for+the+JCC+database+appears+in+Figure+1-
    7.&source=bl&ots=7cxvxfeY48&sig=ACfU3U3IN5JfmzIONzwQ4hNuOVX33crzwA&hl=en&sa=X&ved=2ahUKEwjw
    AKHU7qD6oQ6AEwCHoECAsQAg#v=onepage&q=ER%20diagram%20for%20the%20JCC%20database%20appears%20in%20Figure%201-7.&f=false

Sample Solution