Answered step by step
Verified Expert Solution
Link Copied!

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,

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

What is a stock insurer and who elects a board of directorss?

Answered: 1 week ago