Given the following relation: Account (account_id, branch_id…
Given the following relation: Account (account_id, branch_id, balance). Suppose each tuple is 40 bytes long, 80 tuple per page, and the relation contains 5000 pages. Suppose that a B+ tree index on balance and it is clustered. The value of balance ranges from 0 to 1,000,000. The index file contains 20 pages. What is the cost of sequentially scan of the relation to perform the query: Select * from Account where balance100,000
Read DetailsGiven the following relation: Student (sname, department, ci…
Given the following relation: Student (sname, department, city) where sname is the primary key. Suppose each tuple is 50 bytes long, 100 tuple per page, and the relation contains 1000 pages. Suppose that a B+ tree index on department available and it is unclustered. There are 20 different departments stored in the table. The index file contains 20 pages. What is the cost of using the index to perform the query: Select * from Employee where department=’CS’?
Read DetailsConsider the relation Student (sid, sname, address, departme…
Consider the relation Student (sid, sname, address, department) where sid is the primary key. Assume a tuple takes 80 bytes where sid takes 10 bytes and sname takes 20 bytes. The relation takes 800 pages. The system has 10 buffer pages. Given a query: SELECT sid FROM Student, if sorting-based projection algorithm is used to implement the query, how many runs will be generated without using replacement sort:
Read DetailsPlease examine the life table below and answer the questions…
Please examine the life table below and answer the questions asked.These are coded as multiple fill in the blank values, lettered A – BWe will only accept a numerical response estimated to thousandths place (e.g., 0.500 would be acceptable, but not 0.5, 50%, px = 0.500, or point five). When calculating, round each calculation to this level of precision.The spaces to fill in with answers appear at the bottom of the question, A = ___, B = ____. Question A: What is the probability of making it to age 2? In other words, what is the px value for the 3rd row of the column “px”? __ __Question B: What is the probability of NOT making it to age 3? In other words, what is the qx value for the 4th row of column “qx”? _____
Read Details