Database Reference
In-Depth Information
PatientName
1
PROJECT
2
PatientName
PROJECT
DoctorName
=
“Ruby Ross” AND D.DoctorID
=
T.DoctorId
AND P.PatientNo
=
T.PatientNo AND DOB
>
12DEC1952
DoctorID
3
PRODUCT
SELECT
PatientName
PROJECT
DOCTOR
PRODUCT
PRODUCT
PatientNo
PatientNo
TREATMENT
SELECT
PATIENT
SELECT
Ruby Ross
PRODUCT
SELECT
DoctorID
PRODUCT
DOB
SELECT
SELECT
DOCTOR
DOB
SELECT
PRODUCT
TREATMENT
PATIENT
Ruby Ross
PATIENT
SELECT
TREATMENT
DOCTOR
Figure 13-17
Heuristic approach: optimization steps—Part 1.
PatientName
4
PROJECT
5
PatientName
PROJECT
PatientNo
JOIN
PatientNo
PatientNo, PatientName
PatientNo
JOIN
PROJECT
PROJECT
DoctorID
DOB
JOIN
DOB
SELECT
SELECT
PatientNo
DoctorID
PATIENT
JOIN
PROJECT
PATIENT
PatientNo, DoctorID
PROJECT
Ruby Ross
Ruby Ross
SELECT
TREATMENT
SELECT
TREATMENT
DOCTOR
DOCTOR
Figure 13-18
Heuristic approach: optimization steps—Part 2.
Search WWH ::
Custom Search