Creating Tables

• [e-mail]
• Primary Education
• Lower Secondary (Key Stage 3)
• Upper Secondary (Key Stage 4)
• Further Education (Key Stage 5)
• Higher Education (degree)
• Higher Education (non-degree)
• Special Education

Revision

Today will concentrate only on developing the table mechanics 

We will do more on queries next time.

How Many Fields

1. 10
2. 13
3. 9
4. 12

What are the obvious tables

What you must bear in mind?

01. Inspect your tables

2. Group all the obvious fields that are the same entity or linked together.

3. Ensure you have the tables that are stated in scenario

4. The remaining field can be grouped together  using  composite keys

5. Composite keys can be  a. Keys within that fields  for example  a) "Cleanliness rating" could depend on  1. No of clean ups per year, Amount of rubbish cleaned ,   Year of the review

b, It can depend on a foreign composite keys - You decide!

Group your tables together

Determine the Many to Many relationships

Identify the 1-1 Relationship if there are any.

Remember 

Try  find relationships via the primary keys only or the table becomes very complex.

Remember you only have a couple of hours so do not over complicate Things.

Bless

Thank you 

Good luck in your exam!

Relationship

Draw your relationship for your database

Remember the rules

1. Ensure you have the tables required in the task set for the exams.

2. Use the IDs to create your tables

3. fields that don't easily fit  set them into own table. But use composite keys as Primary keys

4. Look at original table to work out relationships

5. only base relationship on primary keys

6. You would need about Four tables with 3 or 4 Relationships