Question $3(10$ points$)$Question $10(10$ points$)$

We consider the following ERD.

A professor works in $0$ or $1$ department.

A depa$$tment has many professors.

What is the cardinality to add on the ERD and the values for $x$ and $Y?$

Worksin is $...$

$x=1$ and $Y=N.$ WorksIn is one$-$to$-$many from Professor to Department.

$x=1$ and $Y=1.$ Worksin is one$-$to$-$one from Professor to Department.

$x=N$ and $Y=1.$ Worksin is one$-$to$-$many from Department to Professor.

$x={?}^{\text{I}}N$ and $Y=M.$ Worksin is many$-$to$-$many from Professor to Department.Question $10(10$ points$)$ Saved

We consider the following ERD.

A professor works in $0$ or $1$ department.

A depa$$tment has many professors.

What is the cardinality to add on the ERD and the values for $x$ and $Y?$

Worksin is $...$

$x=1$ and $Y=N.$ Worksin is one$-$to$-$many from Professor to Department.

$x=1$ and $Y=1.$ Worksin is one$-$to$-$one from Professor to Department.

$x=N$ and $Y=1.$ Worksin is one$-$to$-$many from Department to Professor.

$x=N$ and $Y=M.$ Worksin is many$-$to$-$many from Professor to Department.

We consider the following ERD.

Does it make sense to have an attribute profid in Department?

True

False