Draw a relational model diagram with the following: 1. Patient Entity: RUT (Primary Key): Integer Name: Chain Last name: Rope Date of Birth: Date Email: String Address: Chain Telephone numbers: Chain Pension System: Chain 2. Health Insurance Entity: Code (primary key): Integer Type: Rope 3. Medical entity: RUT (Primary Key): Integer Name: Chain Last name: Rope Date of Birth: Date Specialties: Rope Years of practice: Whole 4. Medical Specialty Entity: Code (primary key): Integer Specialty name: String 5. Pharmaceutical company entity: Code (primary key): Integer Name: Chain Telephone number: Chain 6. Medication Entity: Business name (primary key): String Formula: Rope Pharmaceutical company code (foreign key): Integer 7. Pharmacy Entity: Code (primary key): Integer Name: Chain Address: Chain Telephone number: Chain 8. Patient-Doctor Assignment Entity: Assignment ID (primary key): Integer Patient RUT (foreign key): Integer Doctor RUT (Foreign Key): Integer number 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 number Patient RUT (foreign key): Integer Prescription date: Date Drug List: Array Quantity: Whole 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: Chain 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
Draw a relational model diagram with the following:
1. Patient Entity:
RUT (Primary Key): Integer
Name: Chain
Last name: Rope
Date of Birth: Date
Email: String
Address: Chain
Telephone numbers: Chain
Pension System: Chain
2. Health Insurance Entity:
Code (primary key): Integer
Type: Rope
3. Medical entity:
RUT (Primary Key): Integer
Name: Chain
Last name: Rope
Date of Birth: Date
Specialties: Rope
Years of practice: Whole
4. Medical Specialty Entity:
Code (primary key): Integer
Specialty name: String
5. Pharmaceutical company entity:
Code (primary key): Integer
Name: Chain
Telephone number: Chain
6. Medication Entity:
Business name (primary key): String
Formula: Rope
Pharmaceutical company code (foreign key): Integer
7. Pharmacy Entity:
Code (primary key): Integer
Name: Chain
Address: Chain
Telephone number: Chain
8. Patient-Doctor Assignment Entity:
Assignment ID (primary key): Integer
Patient RUT (foreign key): Integer
Doctor RUT (Foreign Key): Integer number
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 number
Patient RUT (foreign key): Integer
Prescription date: Date
Drug List: Array
Quantity: Whole
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: Chain
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
Step by step
Solved in 3 steps with 1 images
