Answered: Data/Database Management system .…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

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.

EMPLOYEE
HAS_PHONE
WORKS IN
PHONE
DEPARTMENT
CONTAINS

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions