Queries: 1. List the first and last name of all patients who had blood cancer. 2. List names and location of clinies reported cases of lung cancer. 3. Find the names of patients whose age is above 50 years and had oral cancer since 10/10/2010.

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question
Project
Project I
Database System for a cancer registry
Consider a database system for a Cancer Registry. The data requirements are
summarized as follows:
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.
على النص الذي ترغب في أن يظهر ها.1 Headingخطا استخدم علامة التبويب "الصفحة الرئيسية لتطبيق
3. Clinie:
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.
Queries:
1. List the first and last name of all patients who had blood cancer.
2. List names and location of clinics reported cases of lung cancer.
Find the names of patients whose age is above 50 years and had oral cancer
since 10/10/2010.
4. List the names of employees who are working in clinics, which do not have
breast cancer case.
Transcribed Image Text:Project I Database System for a cancer registry Consider a database system for a Cancer Registry. The data requirements are summarized as follows: 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. على النص الذي ترغب في أن يظهر ها.1 Headingخطا استخدم علامة التبويب "الصفحة الرئيسية لتطبيق 3. Clinie: 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. Queries: 1. List the first and last name of all patients who had blood cancer. 2. List names and location of clinics reported cases of lung cancer. Find the names of patients whose age is above 50 years and had oral cancer since 10/10/2010. 4. List the names of employees who are working in clinics, which do not have breast cancer case.
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY