shared via CourseHero com This study resource was This study source was downloaded by 100000812383137 from CourseHero com on 09 28 2021 01 50 45 GMT 05 00 https www coursehero com file 33882522 Lab3 TanHuynhDangdoc Lab 3Exercise 1 Convert the following Relationship to Relation Data ModelQ6 EMPLOYEES ID Name EMPLOYEES ID ManageID Name Q5 FLIGHTS Flight Date CodeLocationFrom CodeLocationTo LOCATIONS Code Name Q3 EMPLOYEES ID Name PRODUCTS Code Name ID Q3 EMPLOYEES ID Name PRODUCTS Code Name Price Date ID EMPLOYEESManageIDNameFLIGHTSLOCATIONSFlight DateCodeNameFromToEMPLOYEESProcessPRODUCTSIDNameCodeNameEMPLOYEESSalePRODUCTSIDNameCodeNameDatePrice shared via CourseHero com This study resource was This study source was downloaded by 100000812383137 from CourseHero com on 09 28 2021 01 50 45 GMT 05 00 https www coursehero com file 33882522 Lab3 TanHuynhDangdoc Q1 EMPLOYEES EmployeeID Name CUSTOMER CustomerID Name PRODUCTS Code Name Q3 Sale EmployeeID CustomerID Code Quantity Q7 PERSON Code Name TEACHER Code Name Speciality STUDENT Code Name Class Exercise 2 ABC Consulting is a small sized consulting firm in the IT industry ABC s business ismanaging several Systems Development projects by assigning staff consultants to these projects as theirskills are needed Each employee is designated to have one primary skill but there may be other employeesEMPLOYEEPRODUCTEmployeeIDNameCodeNameSaleCUSTOMERQuantityCustomerIDNameTEACHERPERSONSpecialityCodeNameISASTUDENTClassISAspecify the type that you use shared via CourseHero com This study resource was This study source was downloaded by 100000812383137 from CourseHero com on 09 28 2021 01 50 45 GMT 05 00 https www coursehero com file 33882522 Lab3 TanHuynhDangdoc Powered by TCPDF www tcpdf org with the same primary skill A consultant may work on one or more projects or may not yet be assigned to aproject The company charges for each project by billing each consultant s hours worked by the billing rate Thehourly billing rate is dependent on the employee s primary job skill Draw ER model for the problem add the attributes that you deem necessary for each entity in the model Then convert this model to Relation data model SKILL SkillID Name BillRates PROJECT ProjectID Name Time SALARY SkillID ProjectID Workhours EMPLOYEES EmployeeID Name Phone SKILLSALARYPROJECTEMPLOYEESNameSkillIDBillRatesProjectIDNameTimeSkillIDProjectIDWorkhoursEmployeeIDPhoneName