Answered: Draw the class diagram for these…

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

Draw the class diagram for these scenarios for entities it should have primary key.

Scenario 1

A hotel caters mainly to company retreat groups, and wants to model this information to use in a management system. A retreat group consists of a number of that company’s employees as hotel guests. The system needs to track which room each guest stayed in, as well as which group the guest is part of.

Scenario 2

A library wants to model information about its inventory, and which patrons have which books checked out. The library can have multiple copies of a single title, and the model needs to indicate which copy of the title is checked out by a particular patron.

Scenario 3

A doctor's office providing health services needs to track all of its patient visits. The date of the visit, along with any diagnoses needs to be stored. Keep in mind that a patient can have more than one diagnosis per visit, and that any particular diagnosis can be made to multiple patients.

Expert Solution

Trending now

This is a popular solution!

Step by step

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