Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
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.

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 Systems: Design, Implementation, & Management
Database Systems: Design, Implementation, & Management
11th Edition
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Chapter10: Transaction Management And Concurrency Control
Section: Chapter Questions
Problem 6P
See similar textbooks
icon
Related questions
Question

Design the database, following an ER model.                                                            

1. Patients:

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

2. Cancer:

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

3. Clinic:

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

4. Employees:

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

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Transaction Processing
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
A Guide to SQL
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Oracle 12c: SQL
Oracle 12c: SQL
Computer Science
ISBN:
9781305251038
Author:
Joan Casteel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Principles of Information Systems (MindTap Course…
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS