Can someone help with cardinality and participation status? Below is an E-R (Ent

Question

Can someone help with cardinality and participation status? Below is an E-R (Entity Relationship) Diagram that I am working on.

Section PK c code PK sec no PK year complete date offered by format Person Position PK per id PK pos code emp mode required skill pay rate pay type cate code name Compan zip code comp id zip code phone primary_sector Additional relationships hires comp id, per id) has(comp id, cate code) PK g code requires level description status Job_category Knowled PK ks code itie pay range high pay range low (core skill) description

Explanation / Answer

Solution:

The cardinalities are given below:

Between Person and Section===========> One to many

Person to Position========> One to one

Company to Person=========> One to many

Company to job cateogry======> One to many

Person to knowledge========> One to many

Position to Knowledge========> Many to many

Course to Knowledge======> One to many

I hope this helps if you find any problem. Please comment below. Don't forget to give a thumbs up if you liked it. :)

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

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