CCNC/CCNC Module 5/Designing and creating tables

Designing and Building Database Tables using OpenOffice 2.0

The focus of this section is to build a database containing a number of tables representing one-to-many and many-to-many relationships. The section has four subsections that progress through; the creation of database tables, identifying and adding keys and indexes, building out the number of tables to represent a subject area and complete the definition of relationships. We will also focus on entering data and use strategies to test the data integrity of you newly implemented database design.

Basic Table Operations

Outcomes

Upon completion of this tutorial the learner will: Create a fully attributed database table Create, Read, Update and Delete records from a database table Navigate the records within a database table Delete a database table Close a database table

Defining Keys and Indexes

Outcomes

In this tutorial we will: Create primary keys Identify and create indexes

Table Design and Layout

Outcomes

In this tutorial we will: Modify the design of a database table Managing the data when modifying a table Discuss the impacts of modifying and extending a database design Add tables for a many-to-many relationship

Table Relationships

Outcomes

In this tutorial we will: Create relationships between tables Design table relationships, including; one-to-many and many-to-many Apply rules to relationships to increase data integrity Add and modify data to test the tables and relationships