Question

Assignment #1 Consider the E-R diagram below. Based on this E-R diagram, answer the following questions: a. How many EMPLOYEES can work on a project? b. What is the degree of the Used_on relationship? c. Do any associative entities appear in this diagram? If so, name them. d. How else could the attribute Skill be modeled? e. What attributes might be attached to the Works_on relationship? f. Could TOOL be modeled as an associative entity? Why or why not? PROJECT Project_ID Works_on EMPLOYEE Employee_ID + Includes TASK Used_on TOOL Task_ID Time Skill Done_at CITY

          Assignment #1
Consider the E-R diagram below. Based on this E-R diagram, answer the following questions:
a. How many EMPLOYEES can work on a project?
b. What is the degree of the Used_on relationship?
c. Do any associative entities appear in this diagram? If so, name them.
d. How else could the attribute Skill be modeled?
e. What attributes might be attached to the Works_on relationship?
f. Could TOOL be modeled as an associative entity? Why or why not?
PROJECT
Project_ID
Works_on
EMPLOYEE
Employee_ID
+
Includes
TASK
Used_on
TOOL
Task_ID
Time
Skill
Done_at
CITY

Assignment #1
Consider the E-R diagram below. Based on this E-R diagram, answer the following questions:
a. How many EMPLOYEES can work on a project?
b. What is the degree of the Usedon relationship?
c. Do any associative entities appear in this diagram? If so, name them.
d. How else could the attribute Skill be modeled?
e. What attributes might be attached to the Workson relationship?
f. Could TOOL be modeled as an associative entity? Why or why not?
PROJECT
ProjectID
Workson
EMPLOYEE
EmployeeID
+
Includes
TASK
Usedon
TOOL
TaskID
Time
Skill
Doneat
CITY

Added by Seth R.

Question

Please give Ace some feedback