Identify all cardinality for every relationship. Be certain to complete two way

Question

Identify all cardinality for every relationship.

Be certain to complete two way cardinality.

Each cardinality must have a degree of cardinality constraint. For example, the cardinality from Employee to Works_on to Project is 1, m (0,3). This means that 1 employee can work on many projects but may not be working on any projects and may not work on more than 3 projects.

Employee Entity Project Entity Pno pname phours Department Entity dno dname dmangno ame eno edate eadd dno ploc tno pno Task Entity tno tname tduration ttool emp works Relationship Project task Entity tno pno tduration tno dno

Explanation / Answer

Cardinality is applicable at the Queries.
Employee entity has two degree constraints for project
entity and emp works relationship.
In employee entity eno is the cardinality for project entity
pno.
Project entity has one way cardnalities i.e, employee entity
and department entity.
Department entity has one way cardinality i.e, department entity
and task entity.
task entity has one way cardinality i.e, department entity and
project task entity.
Emp works relationship has two way cardinality of employee
entity and one way cardinality of project task entity.
Project has one way cardinality of task entity and project task entity.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

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