Make a relational diagram with the following data: 1. 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 2. Health Insurance Entity: Code (primary key): Integer Type: String 3. Medical entity: RUT (Primary Key): Integer Name: String Last name: String Date of Birth: Date Specialties: String Years of practice: Integer 4. Medical Specialty Entity: Code (primary key): Integer Specialty Name: String 5. Pharmaceutical company entity: Code (primary key): Integer Name: String Phone number: String 6. Medication Entity: Business name (primary key): String Formula: String Pharmaceutical company code (foreign key): Integer 7. Pharmacy Entity: Code (primary key): Integer Name: String Address: String Phone number: String 8. Patient-Doctor Assignment Entity: Assignment ID (primary key): Integer Patient RUT (foreign key): Integer Doctor RUT (Foreign Key): Integer Start date: Date End date: Date 9. Purchase Registration Entity: Purchase ID (primary key): Integer Patient RUT (foreign key): Integer Drug trade name (foreign key): String Prescription requirement: boolean 10. Drug pricing entity: Price ID (Primary Key): Integer Pharmacy code (foreign key): Integer Drug trade name (foreign key): String Price: float 11. 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 12. 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 13. Contract Supervisor Assigning Entity: Assignment ID (primary key): Integer Contract ID (foreign key): Integer Supervisor Name or ID: String Task start date: Date

Database Systems: Design, Implementation, & Management

12th Edition

ISBN:9781305627482

Author:Carlos Coronel, Steven Morris

Publisher:Carlos Coronel, Steven Morris

Chapter2: Data Models

Section: Chapter Questions

Problem 8P

See similar textbooks

Related questions

Concept explainers

Question

Make a relational diagram with the following data:
1. 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

2. Health Insurance Entity:
Code (primary key): Integer
Type: String

3. Medical entity:
RUT (Primary Key): Integer
Name: String
Last name: String
Date of Birth: Date
Specialties: String
Years of practice: Integer

4. Medical Specialty Entity:
Code (primary key): Integer
Specialty Name: String

5. Pharmaceutical company entity:
Code (primary key): Integer
Name: String
Phone number: String

6. Medication Entity:
Business name (primary key): String
Formula: String
Pharmaceutical company code (foreign key): Integer

7. Pharmacy Entity:
Code (primary key): Integer
Name: String
Address: String
Phone number: String

8. Patient-Doctor Assignment Entity:
Assignment ID (primary key): Integer
Patient RUT (foreign key): Integer
Doctor RUT (Foreign Key): Integer
Start date: Date
End date: Date

9. Purchase Registration Entity:
Purchase ID (primary key): Integer
Patient RUT (foreign key): Integer
Drug trade name (foreign key): String
Prescription requirement: boolean

10. Drug pricing entity:
Price ID (Primary Key): Integer
Pharmacy code (foreign key): Integer
Drug trade name (foreign key): String
Price: float

11. 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

12. 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

13. 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 with 2 images

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.