Question

Draw an EER diagram for the following situation using the traditional EER notation or anyone of your choosing.

Insid Inc. is a small career development services company for young professionals. They provide career consultations to applicants looking for entry-level jobs. They offer three services, resume, interview practice and A-to-Z mentorship. Their process is simple. A career advisor talks with a customer to determine their background, challenges and career needs. The customer purchases the service/services that best fits their needs and signs a contract. When the contract is signed, the client department assigns the customer a client manager. The client manager contacts an industry consultant who will be responsible for delivering the services to the customer.

(I put in bold some key words that could be used as entities (subtype/supertype) but it's up to you how you decide to come up with the model)

You can come up with your own set of entitities and attributes, examples are:

Customer = Attributes of customer are Customer ID (identifier), Name, Address, and Telephone.

Service = Attributes of service are Service ID (identifier), Service Type, Service Date and Coverage.

And so on and so forth. I most importantly just need the diagram that shows the relationship.

Thanks!

Answer 1

E-R diadram

Last Name Lst Name FusN seiv phon Servia-0alz ZL CD customer Cov Sevue -ID Cut-ID hast-Nam an mount cons Lusk Name

***************** END ******************** PLS GIVE ME GOOD RATING*********************