Project 1: Database Design Project – HealthOne Medical Database

docx

School

Broward College *

*We aren’t endorsed by this school

Course

2472

Subject

Information Systems

Date

Feb 20, 2024

Type

docx

Pages

Uploaded by johnjames123460

Project 1: Database Design Project – HealthOne Medical Database Dr. Jong Lee February 10, y Academic Report 1

PART A: Determining Entities, Attributes. Entities: • Patient • Doctor • Hospital • Prescription Attributes and Keys: Patient: • Attributes : patient_id (Primary Key), name, address, phone, email, primary_care_doctor_id (Foreign Key), insurance_id, insurance_company_name Doctor: • Attributes : doctor_id (Primary Key), name, specialty, phone, address Hospital: • Attributes : hospital_id (Primary Key), name, location, phone, address Prescription: Academic Report 2

• Attributes : prescription_id (Primary Key), patient_id (Foreign Key), doctor_id (Foreign Key), drug_name, purpose, side_effects PART B: Relationships • Each PATIENT must have one and only one DOCTOR (their primary doctor). Relationship Type: One-to-one Foreign Key: patient.primary_care_doctor_id -> doctor.doctor_id • Each DOCTOR may treat many PATIENTs. Relationship Type: One-to-many Foreign Key: prescription.doctor_id -> doctor.doctor_i • Each PATIENT may have many PRESCRIPTIONs. Relationship Type: One-to-many Foreign Key: prescription.patient_id -> patient.patient_id • Each DOCTOR may be affiliated with many HOSPITALs. Relationship Type: Many-to-many Join Table: doctor_hospital_affiliation Academic Report 3

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Primary Keys: doctor_id, hospital_id PART C: Normalization The database is already in the normalized form. Each table represents a distinct entity with its attributes, and there are no repeating groups or redundant data. Therefore, denormalization is not necessary. Academic Report 4

Project 1: Database Design Project – HealthOne Medical Database

Related Documents