FUNCTIONAL DEPENDENCIES - (Employee_Id , Specialization)...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
FUNCTIONAL DEPENDENCIES ** Star entities represent ISA entities 1. Drugs (Drug_Code , DIN , GP Flag, Accession Number, last Update, Number of Active ingredients, and AI Group Number) Drug_Code, DIN GP Flag, Accession Number, last Update, Number of Active ingredients, and AI Group Number 2. Active Ingredients (Drug_Code , Active_Ingredient_Code , Ingredient) Drug_Code, Active_Ingredient_Code Ingredient 3. Usage notes ( Drug_Name , Common_uses, How_to_use, side_effects) Drug_Name Common_uses, How_to_use, side_effects 4. **Asthma Patients (Health_card_Id , Symptoms , Number_of_previous_attacks) Health_Card_Id, Symptoms, Number_of_previous_attacks Health_Card_Id First_Name, Last_Name 5. **Diabetic Patient (Health_card_Id , Symptoms , Sugar_level) Health_Card_Id, Symptoms Sugar_level 6. Employees (Employee_Id , First_Name, Last_Name) Employee_Id First_Name, Last_Name 7. **Anesthesiologist
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: (Employee_Id , Specialization) Employee_Id Specialization 8. **Nurse (Employee_Id , Surgery_Certification) Employee_Id Surgery_Certification 9. **Doctor (Employee_Id , Specialization) Employee_Id Specialization 10. OfStatus (Drug_Code , Status) Drug_Code Status 11. **WorksIn ( Hospital_Id, Employee_Id ) Employee_Id Hospital_Id 12. **Accepts ( Hospital_Id , Health_Card_Id ) Hospital_Id, Health_Card_Id Hospital_Id, Health_Card_Id 13. **Reports ( Statement_Id , Hospital_Id, Accidental_Report_Key ) Statement_Id, Hospital_Id, Accidental_Report_Key Statement_Id, Hospital_Id, Accidental_Report_Key 14. **Have Applied ( Hospital_Id , Scenerio_Id ) Hospital_Id, Scenerio_Id Hospital_Id, Scenerio_Id 15. **Diagnoses ( Employee_Id, Health_Card_Id ) Health_Card_Id Employee_Id...
View Full Document

This note was uploaded on 07/06/2008 for the course MIE 253 taught by Professor Consens during the Winter '08 term at University of Toronto- Toronto.

Page1 / 2

FUNCTIONAL DEPENDENCIES - (Employee_Id , Specialization)...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online