Design the database, following an ER model. 1. Patients: Patients are tracked by a unique patient ID. Personal information includes first name, last name, phone number, Date of Birth, and sex. The combination of the Patient's first and last name must be unique. Patient's sex is a mandatory field. Patient can be registered at any clinic. 2. Cancer: Type of cancer is tracked by a unique ID. Cancer is categorized as either Oral, Lung, Breast, Liver, Blood, Bone, Pancreatic, Cervical, or Prostrate. Stage of cancer can be Stage I, Stage II, or Stage III Stage of cancer detection. Treatment given: Chemotherapy only, Surgery with chemotherapy, Surgery only or Radiation therapy. Patient_id is an FK which references the ID of the Patient. Clinic_id is an FK which references the ID of the Clinic that patient register. Patient information must be stored at one clinic. Patient Date of detection of Cancer. 3. Clinic: Clinics are tracked by unique clinic ID. Each clinic has a name and location. The combination of the clinic's name and location must be unique. 4. Employees: Employees are tracked by unique Employee ID. Clinic_id is a FK which references the Clinic ID which they work at. Employees must work at a single Clinic. Personal information includes Fname, Lname and sex. The combination of an employee's first and last name must be unique.

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

Design the database, following an ER model.

1. Patients:

Patients are tracked by a unique patient ID.
Personal information includes first name, last name, phone number, Date of Birth, and sex.
The combination of the Patient's first and last name must be unique.
Patient's sex is a mandatory field.
Patient can be registered at any clinic.

2. Cancer:

Type of cancer is tracked by a unique ID.
Cancer is categorized as either Oral, Lung, Breast, Liver, Blood, Bone, Pancreatic, Cervical, or Prostrate.
Stage of cancer can be Stage I, Stage II, or Stage III
Stage of cancer detection.
Treatment given: Chemotherapy only, Surgery with chemotherapy, Surgery only or Radiation therapy.
Patient_id is an FK which references the ID of the Patient.
Clinic_id is an FK which references the ID of the Clinic that patient register.
Patient information must be stored at one clinic.
Patient Date of detection of Cancer.

3. Clinic:

Clinics are tracked by unique clinic ID.
Each clinic has a name and location.
The combination of the clinic's name and location must be unique.

4. Employees:

Employees are tracked by unique Employee ID.
Clinic_id is a FK which references the Clinic ID which they work at.
Employees must work at a single Clinic.
Personal information includes Fname, Lname and sex.
The combination of an employee's first and last name must be unique.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 1 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.

Similar questions