User Account

All Pages

List whether the index matches the given selection condition

Assignment Help Database Management System
Reference no: EM13336567

Question 1

Athabasca University has about 32,000 students between the ages of 17 to 60. Consider the AU student relation with the following schema:

Students (stud-id: integer, stud-name: string, gpa: integer, age: real)

For each of the following indexes, list whether the index matches the given selection conditions. If there is a match, list the primary conjuncts.2

1. A B+-tree index on the search key Students.stud-id.

a. σ Students.stud-id < 28,000 (Students)

b. σ Students.stud-id = 28,000 (Students)


2. A hash index on the search key Students.stud-id.

a. σ Students.stud-id < 28,000 (Students)

b. σ Students.stud-id = 28,000 (Students)


3. A B+-tree index on the search key Students.stud-id, Students.age.

a. σ Students.stud-id < 28,000 and Students.age = 21 (Students)

b. σ Students.stud-id = 28,000 and Students.age> 21 (Students)

c. σ Students.stud-id = 28,000 (Students )

d. σ Students.age = 21 (Students )


4. A hash-tree index on the search key Students.stud-id, Students.age .

a. σ Students.stud-id = 28,000 and Students.age = 21 (Students)

b. σ Students.stud-id = 28,000 and Students.age> 21 (Students)

c. σ Students.stud-id = 28,000 (Students )

 

Reference no: EM13336567

Questions Cloud

What is the cost of joining r and s using a sort-merge join : What is the cost of joining R and S using a page-oriented simple nested loops join? What is the minimum number of buffer pages required for this cost to remain unchanged?
What is the total i/o cost for sorting this file : How many sorted subfiles will there be after the initial pass of the sort, and how long will each subfile be?
What is the carts final velocity : A 100 N force has a horizontal component of 60 N and a vertical component of 80 N. What is the cart's final velocity
Calculate the pressure of the gas on the walls : One mole of oxygen molecules occupies a cubic vessel of side length 10 cm at a temperature of 18 C. Calculate the pressure of the gas on the walls
List whether the index matches the given selection condition : Athabasca University has about 32,000 students between the ages of 17 to 60. Consider the AU student relation with the following schema.
Find an expression for the velocity vs distance : Find an expression for the velocity vs. distance.
Briefly how to make use of indexes such as b+ tree : Summarize briefly how to make use of indexes such as B+ tree or a hash indexes in selection, projection, and join operations?
Sketch the base-five pieces and each of the subtraction mode : Sketch the base-five pieces and each of the subtraction models to determine the following differences. Record sketches of your work and record the base-five numeral for each difference.
What is the maximum safe diving depth : A scuba diver can withstand pressures up to 4.2 atm without rish of getting the bends. What is the maximum safe diving depth

Reviews

Write a Review

Database Management System Questions & Answers

  How many times the top module call each subordinate module

Select the best answer for each of the multiple choice questions below about the Structure Chart shown her

  Find names of students who have higher gpa from table

List the students ID, name, GPA, and course Number such that all students have GPA greater than 3 . 5 and enrolled in a course in Jan 1, 2011. Find the names of all students who have GPA greater than 3.

  Explain why data flow diagrams are developed in a hierarchy

Explain why data flow diagrams are developed in a hierarchy? What are the names of some levels in the hierarchy?

  Research paper on the turing and von neumann models

Write a two page research paper on the Turing and von Neumann models.

  Ways of implementing one-to-one relationships

Describe the difference ways of implementing one-to-one relationships. Assume you are maintaining information on offices (office numbers, building, and phone numbers)

  List the requirements for this eer diagram

Given the following EER diagram of the Museum Database.

  Difference between obsolescent and redundant stocks

Difference between obsolescent and redundant stocks

  Explain relational database design

How would you change the current design and how does your new design address the problems you have identified with the current design.

  Write a memorandum to sam jones

Write a memorandum to Sam Jones (CIO) and present your research findings. Your memorandum should be no longer than 500 words.

  Determine a list of n numbers has no duplicates

Express given five loosely described problems carefully in { Instance, Question } form as utilized in "Computers and Intractability". Determine that a list of n numbers has no duplicates.

  Explaining business activity in new is with a database

Assume you manage business activity which needs a new IS with a database. The development team is divided on which DBMS you must use. One faction wishes to use oracle,a second wants to use MtSQL, and a third wants to use SQL server.

  Create an employee database

Create a report that contains the above data - be sure to include a Hampton University logo in your report.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd