FIT328_DBS_Tutorial_06 - DBS Tutorial Week 6 Exercise 1...

Info icon This preview shows page 1. Sign up to view the full content.

DBS Tutorial Week 6 Exercise 1 Match the following terms to the appropriate definitions: ___ extent ___ hashing algorithm ___ index ___ physical record ___ pointer ___ data type ___ physical file a. a detailed coding scheme for representing organizational data b. a data structure used to determine in a file the location of a record/records c. a named area of secondary memory d. a contiguous section of disk storage space e. a field not containing business data f. converts a key value into an address
Image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: g. adjacent fields Exercise 2 Explain why normalized relations may not comprise an efficient physical implementation structure and list three common situations that suggest that relations be denormalized before database implementation. Exercise 3 Consider the following two relations for Millennium College: On what attributes should indexes be defined to speed up this query? Give the reasons for each attribute selected....
View Full Document

  • Spring '16
  • Luyen Thu Trang
  • Database normalization, Algorithmic efficiency

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern