Question: 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
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
