Consider the Entity-Relationship Diagram for a Small Manufacturing Company . Con
ID: 3713561 • Letter: C
Question
Consider the Entity-Relationship Diagram for a Small Manufacturing Company.
Convert this diagram into a list of relation (table) schemas that capture all of its information. In each schema, underline the primary key attributes.
Entity-Relationship Diagram for a Small Manufacturing Company mentor employeeldemployee ..0.advise name mentored IS hourlyRate skill skilledEmployee skillLevel salary adminEmployee degree hrsPer Wk workOn jobld descr job partofproject title lead ie 1..1 projectld 1.1 jobBudget adminBudgetExplanation / Answer
Tables:
......
employee(employeeID,name,mentorID)
skilledEmployee(employeeID,hourlyRate,skill,skillLevel)
adminEmployee(employeeId,salary,degree)
job(jobId,sescr,jobBudjet,projectID)
workOn(WorkOnID,jobId,employeeID)
project(ProjectId,title,adminBudjet)
lead(LID,projectID,employeeID)