Draw an ER Model using Visio

Draw an ER Model using Visio for the following. Make sure you assign appropriate attributes for entities/tables, including the Primary Key (PK) and Foreign Key (FK):

A consulting firm, ‘Boston Datacorp’ based in Boston, Massachusetts, USA hires partners to manage several client projects, but each project requires the involvement of only one partner. Each partner supervises several data scientists and each data scientist is managed by only one partner. Data scientists use high-end statistical applications (such as SAS) to run analytic models to do their work; a data scientist uses a preferred statistical application, while each application could be utilized by several data scientists. Boston Datacorp keeps track of the ‘utility value’ of every statistical application. At ‘Boston Corp’ partners need to make additional intellectual contributions by writing papers (referred to as white papers) to get promoted to senior partners. A partner may write several white papers, while a white paper can only be written by one partner. (Note: each table/entity in your ER model must have at least two attributes including the ones specified in the problem. Note that these do not include PK and FK)

(25 points)