Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Consider the suppliers - parts database with tables S , P , SP . Recall SP [ sno ] is a FK to S [
Consider the suppliersparts database with tables SPSP Recall SPsno is a FK to Ssno and SPpno is a FK to Ppno Suppose that all three tables are stored as unordered files, and we have no available indexes. Check below all the correct statements. Assume the cost estimates discussed in the lecture. Also, assume that there is nothing in main memory that would store information about the database before each query besides the T object discussed in the lecture. Question options:
If S has blocks then the cost of select from S where city"Rome' is at most da
If S has blocks then the cost of select from S where city"Rome' is at most da
If SP has blocks then the cost of delete from SP where pno is at most da
If S has blocks then the cost of select from S where city"Rome' is at most da
If SP has blocks then the cost of delete from SP where pno is at least da
If S has blocks then the cost of delete from S where sno is at most da
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