9.3 3. A user queries the Item table in the TAL Distributors database over the c

Question

9.3

3. A user queries the Item table in the TAL Distributors database over the company intranet. Assume the Item table contains 5,000 rows, each row is 1,000 bits long, the access delay is 2.5 seconds, the transmission rate is 50,000 bits per second, and only 20 of the 5,000 rows in the Item table satisfy the query conditions. Calculate the total communication time required for this query based on retrieving all table rows one row at a time, and then calculate the total communication time required based on retrieving the 20 rows that satisfy the query conditions in a single message.

Explanation / Answer

Consider the Given Senario is

5000 -----------> 2.5 sec------>
5000-28 --------->2.5 ----1.7 ----> 0.8 sec

for 5000 records it will take the 2.5 seconds
for 4972 records it will take 1.7 sec
for satisfy thing this condition it will take 1.7 sec

Related Questions

Navigate

• Browse (All)
• Browse 9
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.