Creating Tables

Revision
Today will concentrate only on developing the table mechanics 
We will do more on queries next time.
1 / 12
volgende
Slide 1: Tekstslide
Ilearningdeal@gmail.comPrimary EducationLower Secondary (Key Stage 3)Upper Secondary (Key Stage 4)Further Education (Key Stage 5)Higher Education (degree)Higher Education (non-degree)Special Education

In deze les zitten 12 slides, met interactieve quizzen en tekstslides.

time-iconLesduur is: 2 min

Onderdelen in deze les

Revision
Today will concentrate only on developing the table mechanics 
We will do more on queries next time.

Slide 1 - Tekstslide

Slide 2 - Tekstslide

Slide 3 - Tekstslide

How Many Fields
A
10
B
13
C
9
D
12

Slide 4 - Quizvraag

What are the obvious tables

Slide 5 - Open vraag

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!



Slide 6 - Tekstslide

Group your tables together

Slide 7 - Open vraag

Determine the Many to Many relationships

Slide 8 - Open vraag

Identify the 1-1 Relationship if there are any.

Slide 9 - Open vraag

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

Slide 10 - Tekstslide

Thank you 
Good luck in your exam!

Slide 11 - Tekstslide

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

Slide 12 - Tekstslide