Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help adding cardinality to a ER diagram Assumptions: A project can exist before anyone is assigned to it An employee may not be

I need help adding cardinality to a ER diagram

Assumptions:

  • A project can exist before anyone is assigned to it
  • An employee may not be assigned to any projects.
  • An employee may not be assigned to more than 3 projects.
  • An employee is assigned to only one department and must be assigned to a department.
  • If an employee is assigned to a project, they must be assigned to at least one task but no more than 4 tasks.
  • A department could exist and not have any employees.
  • A project must have at least one task and a task could not exist unless there was at least one appropriate project.

(My diagrams maybe off)

image text in transcribedimage text in transcribed

Emp num Project pn() phame Project Task ono ploc tno tno duration ebdate Department dno Task dno tno pno t duration Project Employee Has Have Emp-num Project_Task Has Department Task

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Formal SQL Tuning For Oracle Databases Practical Efficiency Efficient Practice

Authors: Leonid Nossov ,Hanno Ernst ,Victor Chupis

1st Edition

3662570564, 978-3662570562

More Books

Students also viewed these Databases questions

Question

politeness and modesty, as well as indirectness;

Answered: 1 week ago