database design

ctical Assignments. Design an ERD (20 points) and map it into the relational model (15 points) for each ignment. A consulting firm manages employment of consultants by different companies: Each company is identified by Company ID and is described by Company Name and Industry Type. Each company has a specific Profile, and more than one company can have the same Profile. Profile is identif by the Profile Name and is described by the Profile Description Consultants have Consultant ID, Consultant Name and Specialty. A consultant can have more than one Specialty. A Consultant can work for different Companies while being associated with the consulting firm and ca work for some particular company mo Contract with unique Contract Number, and employment Date Start and Date End. For each employm of a consultant we need to track his/her Hourly Rate. re than once. For each Consultant's employment the firm issues