QUESTION 6 Design an ER diagram for the scenario below, showing all attributes, keys, cardinalities and participation constraints clearly. Note any unspecified requirements, and make appropriate assumptions to make the specification complete. Do not add any attributes of your own. Upload your ER model below, please note: Make sure that the image is clear. Accepted File formats are: JPEG, PNG, or PDF, Other formats are not accepted. Do not include links to external resources. Clearly write your name and ID on the ER image. Otherwise, it will not be accepted. Question: Consider the following requirements for a hospital database to store information about the hospital departments and employees. The hospital has several departments. Each department has a unique name, unique telephone number, and a specific employee managing the department. Each department is related to one or more divisions, and the division-no is unique within the department. Each division has a telephone-number and may have many specialized devices. Each device has a number (unique), type and related to exactly one division and used by at least one employee. For each employee in the hospital, it is important to record employee’s name, unique ID, address, age, birth date, and the department working for. It is also required to keep track employees’ special needs of each employee (if any).

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

QUESTION 6

Design an ER diagram for the scenario below, showing all attributes, keys, cardinalities and participation constraints clearly. Note any unspecified requirements, and make appropriate assumptions to make the specification complete. Do not add any attributes of your own.

Upload your ER model below, please note:

Make sure that the image is clear.
Accepted File formats are: JPEG, PNG, or PDF, Other formats are not accepted.
Do not include links to external resources.
Clearly write your name and ID on the ER image. Otherwise, it will not be accepted.

Question:

Consider the following requirements for a hospital database to store information about the hospital departments and employees. The hospital has several departments. Each department has a unique name, unique telephone number, and a specific employee managing the department. Each department is related to one or more divisions, and the division-no is unique within the department. Each division has a telephone-number and may have many specialized devices. Each device has a number (unique), type and related to exactly one division and used by at least one employee. For each employee in the hospital, it is important to record employee’s name, unique ID, address, age, birth date, and the department working for. It is also required to keep track employees’ special needs of each employee (if any).

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 2 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