CCNC/CCNC Module 5/Designing and creating tables/Table Design and Layout/Self Assessment

From WikiEducator
Jump to: navigation, search
Tutorial.png Table Design and Layout 

Field Design and Properties | Adding Columns | Adding Indexes | Database Schemas | Self Assessment | Summary & FAQs

Self Assessment

Icon objectives.jpg


Upon completion of this self assessment the learner will:
  • Modify the design of a database table
  • Managing the data when modifying a table
  • Identify appropriate database design changes for a given scenario
  • Design the tables required for a many-to-many relationship
  • Add the tables for a many-to-many relationship

Icon activity.jpg

Portfolio Activity

Refer back to the database design work you did in the previous chapter. Choose both the design for a one-to-many and a many-to-many relationship. Use these designs to create two or more tables that represent the one-to-many and many-to-many relationships.

  1. Use the "Create Table in Design View..." option from the task panel.
  2. Create the tables required for a one-to-many relationship.
  3. Ensure that the table acting as the many has an INTEGER field of the same name as the primary key of the table being the one.
  4. Save and close the new tables.
  5. Create the tables required for a many-to-many relationship.
  6. Ensure that the table acting as the cross reference (_xref_) table has INTEGER fields for the primary keys for the two many tables.