Data/Database Management system . Consider the ER diagram shown below. Supply the relationship constraints using cardinality ratios and participation constraints on this diagram based on the following assumptions (you may use (min, max) notation if you prefer): An employee may work in up to two departments or may not be assigned to any department. Each department must have one and may have up to three phone numbers. Each department can have anywhere between 1 and 10 employees. Each phone is used by one, and only one, department. Each phone is assigned to at least one, and may be assigned to up to 10 employees. Each employee is assigned at least one, but no more than 6 phones.
Data/
. Consider the ER diagram shown below. Supply the relationship constraints using cardinality ratios
and participation constraints on this diagram based on the following assumptions (you may use (min,
max) notation if you prefer):
An employee may work in up to two departments or may not be assigned to any department.
Each department must have one and may have up to three phone numbers.
Each department can have anywhere between 1 and 10 employees.
Each phone is used by one, and only one, department.
Each phone is assigned to at least one, and may be assigned to up to 10 employees.
Each employee is assigned at least one, but no more than 6 phones.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
