CCNC/CCNC Module 5/Designing and creating tables/Defining Keys/Self Assessment

From WikiEducator
Jump to: navigation, search
Tutorial.png Defining Keys and Indexes 

Primary Keys | Indexes | Self Assessment | Summary & FAQs

Self Assessment

Icon objectives.jpg


Upon completion of this self assessment the learner will:
  • Identify fields to be indexed
  • Create and maintain indexes
  • Describe the use of a uniqueness constraint
  • Rename an index
  • Delete an index

Icon activity.jpg

Portfolio Activity

Refer back to the table creation work you did in the previous section. Review the database design that accompanies these tables and identify possible indexes.

  1. Highlight the desired table and open the Index Designer from the Tools menu
  2. Create indexes on the fields identified most appropriate for indexes
  3. If you have identified a field that requires a uniqueness constraint, add a unique index to this field
  4. Rename the new indexes to a meaningful name
  5. Save the new indexes and close the Index Designer
  6. Add data to the table(s) with new indexes
  7. Try out the unique index by adding two rows with the same value