4.5 An Example of Patient EER Schema Consider the following information about a patient database: A patient is identified by patient id, and admission date. • A patient must be either an Emergency patient or a resident patient. We must record the checkback date for Emergency patient. Only resident patient is assigned to one room. Room has a unique number, degree, and floor number. • For each room there are a number of beds each of which has a bed number, specification. If a room is deleted, you need not keep track of its beds any longer. Both emergency patient and resident are cared for by a responsible Doctor. Doctor is identified by Doctor number. For each Doctor, the name, several specialty, and years of experience must be recorded. Doctors prescribe medicine for patients. Medicine is identified by trade name that has scientific name and formula. The medicine depends on another medicine to be taking before. • A doctor could prescribe one or more drugs for several patients, and a patient could obtain prescriptions from several doctors. Each prescription has a date and a quantity of medicine. Draw an ER/EER diagram that captures the above information.

4.5 An Example of Patient EER Schema Consider the following information about a patient database: A patient is identified by patient id, and admission date. • A patient must be either an Emergency patient or a resident patient. We must record the checkback date for Emergency patient. Only resident patient is assigned to one room. Room has a unique number, degree, and floor number. • For each room there are a number of beds each of which has a bed number, specification. If a room is deleted, you need not keep track of its beds any longer. Both emergency patient and resident are cared for by a responsible Doctor. Doctor is identified by Doctor number. For each Doctor, the name, several specialty, and years of experience must be recorded. Doctors prescribe medicine for patients. Medicine is identified by trade name that has scientific name and formula. The medicine depends on another medicine to be taking before. • A doctor could prescribe one or more drugs for several patients, and a patient could obtain prescriptions from several doctors. Each prescription has a date and a quantity of medicine. Draw an ER/EER diagram that captures the above information.

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

Similar questions

Explain the concept of scalability
Suppose a database system is without concurrency control. Describe an example that the concurrency of multiple transactions results in inconsistency in the database. You can take the banking system, ticket booking system or any other database system for example. Please explain the outer-schema, schema, inner-schema structure of database system.
Explain the use cases and benefits of graph databases. Provide an example scenario where a graph database would be ideal.
Assume that a database system is installed on a server with 3 core processors. You want your query to run on multiple processors so that each processor accesses in parallel a subset of the database. Or, you might set up your system in a way that partitions your query so that each part of the same query runs on a different processor. Explain, with an example, how a query might be broken apart so that each parallel processor handles a subset of the query
Compare and contrast five (5) Database programming languages (e.g. Python, C++, SQL; but don't use these examples as your answer) by signifying each of the following for the abovementioned concepts: a) Function/Purpose b) Sample Input (Process; Coding) c) Sample Output (In relation to input) Note: Answer this thoroughly.
Differentiate linear from a nonlinear data structure.
Explain how data binding differs in server-side and client-side applications. What challenges may arise in each approach?
Imagine a straightforward database that contains data on student grades.Provide a SQL query that will return a list of the honour roll students (the top 10%), sorted by their grade point average, and design how this database might look.
A database has been designed to display a list of popular movies and also a list of actors acting in these movies. The relationship that would exist between the related tables would be: O many to many one to many O many to one O one to one
In a built-in spreadsheet function, if a certain parameter does not apply, under what circumstances can it be left blank and when must a comma be entered in its place?
Why is it sometimes better for a data model to exclude a certain data item from its representation?