EER (Enhanced Entity Relationship) diagram: E Employee o date_hired: date works in Person o person_ID: int name : string address string birth_date date phone_number : string is a is a (v) Volunteer o skill: string (N) Nurse o certificate : string is a (C) CareCentre o location : string isAppointedNurselnCharge is a P Physician o specialty : string o pager_number : string refers <<(Pt, #FF7700) >> Patient o contact_date: date I) Item o item_number: int description : string unit_cost: decimal consumes/isConsumed T Technician o skill : string L Laboratory o location : string performs performs «(Tr, #FF7700)>> Treatment o treatment_ID: string B Bed o bed_number: int room_number: int s Staff o job_class: string « (Vt, #FF7700) >> Visit o date : date comments: string

EER (Enhanced Entity Relationship) diagram: E Employee o date_hired: date works in Person o person_ID: int name : string address string birth_date date phone_number : string is a is a (v) Volunteer o skill: string (N) Nurse o certificate : string is a (C) CareCentre o location : string isAppointedNurselnCharge is a P Physician o specialty : string o pager_number : string refers <<(Pt, #FF7700) >> Patient o contact_date: date I) Item o item_number: int description : string unit_cost: decimal consumes/isConsumed T Technician o skill : string L Laboratory o location : string performs performs «(Tr, #FF7700)>> Treatment o treatment_ID: string B Bed o bed_number: int room_number: int s Staff o job_class: string « (Vt, #FF7700) >> Visit o date : date comments: string

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

Identify FIVE properties that a relation must have in the relational model.
Will functional connections be retained if a relation is transformed into a temporal relation by adding a time attribute? In a temporal database, how is the problem handled?
a. Provide the relation (relational notation) that represents the user view for the school advising system.b. Transform the user view into the third normal form. Show the intermediate steps in the normalization process, i.e. 1NF, 2NF, 3NF.
which rules apply to desigining table with less redundancy? a) Binary Relationship b) Reflective Relationship c) Weak entity d) Normal form
1)write requirement and analysis to make university database.2) write relation tables and relation between it for this university .3) make er-diagram for this university.4)make mapping for this university .5)implement this tables in program oracle.
Three instances in which a surrogate key should be constructed for the relation's primary key
Explain three cases when a surrogate key should be generated in place of the main key of a relation.
CONVERT ER DIAGRAM TO RELATIONAL MODEL MAPPING ONE-TO-ONE RELATIONSHIP
how to map ERR model to relational model
What are three cases when a surrogate key might be used in place of a relation's main key?
Solve with explanation
Explanation of three circumstances in which a surrogate key should be generated for the main key of a relation is appropriate