1: Creating a Normalised Relational Database Structure

Table of Contents

1. What is Data?
2. The Relational Database Model
3. The Need for Normalisation
4. Entity Model Diagrams
5. The Data Dictionary
6. Creating the Database Tables

Creating the Database Tables

We are now going to create the database tables using Microsoft Access. It is assumed that you know how to start the package so you should create a new database called MossparkCommunityCollege and navigate to Create Table in the Design View page. Create the four tables from the 3NF descriptions. Click on the following link to see what the database information page should look when this is done:

Database Information Page

Click the following link to see the design view of the Classlist table. Note the two-part key:

Design View of Classlist Table

After the tables have been created you should create the relevant Relationships. Base this on the Entity Model you created in earlier. Click the link below to see what it should look like:

Relationships

Congratulations, you've now reached the end of this section. You can go back to any topic by using the menu on the left-hand side of the screen, or return to the home page for the unit by clicking the HN Computing logo in the top left-hand corner.