Consider the Entity-Relationship Diagram for a Small Manufacturing Company . Con

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 adminBudget

Explanation / 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)

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.