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 TTechnician 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 TTechnician 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

Because an EER discussion nearly always produces a normalised set of relations, what is the point of normalisation?
What is an unnormalized relation? Is it a relation according to the definition of the word relation?
Normalization Show all the steps as you perform normalization for each problem up to 3NF. State your final relation to schemas in 3NF.
Give an SQL schema definition for the employee database of Figure 3.19.Choose an appropriate domain for each attribute and an appropriate primarykey for each relation schema. Include any foreign-key constraints that might beappropriate.
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.
Convert any E-R diagram in a Relation.
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.