Question 3 1 pts nane ssn lot age pnare Enployees olicy Dependents since In the

Question

Question 3 1 pts nane ssn lot age pnare Enployees olicy Dependents since In the ER diagram shown above, we want to represent the fact that an employee of a company can have medical insurance dependents. Assuming that all the errors were fixed as per question 1, which of the following is FALSE? O pname is not a key. O ssn, name, lot) is a super key in Employee table. O A dependent can have more than one employee to buy insurance policy O since is a descriptive attribute. O An employee can have more than one dependent.

Explanation / Answer

C is false.
- Here one employee can have more than one dependents. hence 5th is true.
- since is attribute of relationship policy. Hence it is called descriptive attribute. So 4th is also true.
- dependents is a weak entity. So it doesnt have any key. So pname is not a key. Hence 1st is also true.
- Here candidate key of Employees is ssn. So (ssn, name, lot) is a super key in employee table. hence 2nd is also true.

3rd(c) is false. as dependents can not have more than one employee as employee is a parent entity of weak entity dependents.

if you have any doubts then you can ask in comment section if you find the solution helpful then upvote the answer. Thank you.

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

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