Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Question 6 Consider the following database Schema, where patients can have many appointments in different hospitals. Hospital (HNo, Hname) Patient (PID, Pname) Appointment (HNO, PID,
Question 6 Consider the following database Schema, where patients can have many appointments in different hospitals. Hospital (HNo, Hname) Patient (PID, Pname) Appointment (HNO, PID, ApptDate, price) Based on the following assumptions: 10 tuples in Hospital; 50 tuples in Patient; 100 tuples in appointments; 5 appointments for Patient ID=555 no indexes or sort keys; results of any intermediate operations stored on disk; cost of the final write is ignored; tuples are accessed one at a time. Calculate the cost of the following strategies to retrieve the list of appointments for patient ID=555, and show which one is more efficient. 1. PID=555 ( (Hospital Appointment) * Patient) 2. Hospital (Appointment (o PID=555 Patient))
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started