Make an entity relationship diagram with the following data: Patient Entity: RUT (Primary Key): Integer Name: String Last name: String Date of Birth: Date Email: String Address: String Telephone numbers: String Pension System: String Health Insurance Entity: Code (primary key): Integer Type: String Medical entity: RUT (Primary Key): Integer Name: String Last name: String Date of Birth: Date Specialties: String Years of practice: Integer Medical Specialty Entity: Code (primary key): Integer Specialty Name: String Pharmaceutical company entity: Code (primary key): Integer Name: String Phone number: String Medication Entity: Business name (primary key): String Formula: String Pharmaceutical company code (foreign key): Integer Pharmacy Entity: Code (primary key): Integer Name: String Address: String Phone number: String Patient-Physician Assignment Entity: Assignment ID (primary key): Integer Patient RUT (foreign key): Integer Doctor RUT (Foreign Key): Integer Start date: Date End date: Date Purchase Registration Entity: Purchase ID (primary key): Integer Patient RUT (foreign key): Integer Drug trade name (foreign key): String Prescription requirement: boolean Drug pricing entity: Price ID (Primary Key): Integer Pharmacy code (foreign key): Integer Drug trade name (foreign key): String Price: float Prescription Entity: Prescription ID (primary key): Integer Doctor RUT (Foreign Key): Integer Patient RUT (foreign key): Integer Prescription date: Date Drug List: Array Quantity: Integer Contracting entity: Contract ID (primary key): Integer Pharmaceutical company code (foreign key): Integer Pharmacy code (foreign key): Integer Start date: Date End date: Date Full text: String Contract Supervisor Assigning Entity: Assignment ID (primary key): Integer Contract ID (foreign key): Integer Supervisor Name or ID: String Task start date: Date Task completion date: Date

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

Make an entity relationship diagram with the following data: Patient Entity: RUT (Primary Key): Integer Name: String Last name: String Date of Birth: Date Email: String Address: String Telephone numbers: String Pension System: String Health Insurance Entity: Code (primary key): Integer Type: String Medical entity: RUT (Primary Key): Integer Name: String Last name: String Date of Birth: Date Specialties: String Years of practice: Integer Medical Specialty Entity: Code (primary key): Integer Specialty Name: String Pharmaceutical company entity: Code (primary key): Integer Name: String Phone number: String Medication Entity: Business name (primary key): String Formula: String Pharmaceutical company code (foreign key): Integer Pharmacy Entity: Code (primary key): Integer Name: String Address: String Phone number: String Patient-Physician Assignment Entity: Assignment ID (primary key): Integer Patient RUT (foreign key): Integer Doctor RUT (Foreign Key): Integer Start date: Date End date: Date Purchase Registration Entity: Purchase ID (primary key): Integer Patient RUT (foreign key): Integer Drug trade name (foreign key): String Prescription requirement: boolean Drug pricing entity: Price ID (Primary Key): Integer Pharmacy code (foreign key): Integer Drug trade name (foreign key): String Price: float Prescription Entity: Prescription ID (primary key): Integer Doctor RUT (Foreign Key): Integer Patient RUT (foreign key): Integer Prescription date: Date Drug List: Array Quantity: Integer Contracting entity: Contract ID (primary key): Integer Pharmaceutical company code (foreign key): Integer Pharmacy code (foreign key): Integer Start date: Date End date: Date Full text: String Contract Supervisor Assigning Entity: Assignment ID (primary key): Integer Contract ID (foreign key): Integer Supervisor Name or ID: String Task start date: Date Task completion date: Date

Expert Solution

Step by step

Solved in 3 steps

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