slide1 n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
1. (25) Answer the following questions: PowerPoint Presentation
Download Presentation
1. (25) Answer the following questions:

Loading in 2 Seconds...

play fullscreen
1 / 2

1. (25) Answer the following questions: - PowerPoint PPT Presentation


  • 107 Views
  • Uploaded on

REL_NAME INDEX_NAME MEMBER_ATTR INDEX_TYPE ATTR_NO ASC_DESC. Assignment #1 (Assignment due: Mon., Feb. 04, 2014). 1. (25) Answer the following questions: i) Why must the meta data be established for a database?

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about '1. (25) Answer the following questions:' - gella


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
slide1

REL_NAME INDEX_NAME MEMBER_ATTR INDEX_TYPE ATTR_NO ASC_DESC

Assignment #1

(Assignment due:Mon., Feb. 04, 2014)

1. (25) Answer the following questions:

i) Why must the meta data be established for a database?

ii) What is the meaning of each attribute in the relation schema shown below?

RELATION_INDEXES

Use an example to explain your answer.

2. (30) Sort the following integer sequence:

1, 10, 9, 8, 7, 5, 6, 2, 4, 3

using the heap sorting algorithm. Trace the computation process (i.e., give each computation step).

slide2

Assignment #1

(Assignment due:Mon., Feb. 04, 2014)

3. (30) Assume that a file contains an integer sequence:

18, 17, 1, 2, 3, 4, 16, 15, 14, 13, 5, 6, 7, 8, 9, 10, 12, 11

and the buffer (in main memory) is of size 5 blocks with each being able to hold 2 integers.

Sort this file using the external sorting algorithm. Trace the computation process.

4. (15) Given the following relation schema and assume that a primary index has been

established on DNUMBER, how to evaluate DNUMBER>5(DEPARTMENT) in an efficient way?

Describe your method.

DEPARTMENT

… ...

DNUMBER

DNAME