Consider the follow relations’ schemas to answer the following questions: Student (sid, name, level, address) Book(bid, title, author) BorrowedBook( sid , bid , date) 1) Assume that, there are 10,000...


Consider the follow relations’ schemas to answer the following questions:



  • Student (sid, name, level, address)

  • Book(bid, title, author)

  • BorrowedBook(sid,bid, date)


1)    Assume that, there are 10,000 Student records stored on 1,000 pages/blocks, 50,000 Book records stored on 5,000 pages, 300,000 BorrowedBook records stored on 15,000 pages, and there are 500 different authors.Find out what is the record size for each of the previous relation?, and what is the blocking factor for each relation?



Jun 06, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here