Unit 2 - Paper 1 Activity 1

• Computing ICT
• Further Education (Key Stage 5)

Unit 2 - Paper 1 Activity 1

Outcomes- 1 Normalising database standard form 1

a. Identifying tables 

b. identifying Primary and  Foreign keys 

2, ERD

3. Relationships 

4. Naming conventions 

5. Referential Integrity

00:00

Name four things that your Database design should provide.

00:58

Name four things that your Database design should provide.

00:58

Name four things that your Database design should provide.

00:59

Name the four tasks expected for activity 1

01:04

Test

01:12

01:29

What is the naming convention for table?- This is worth a point !

1. TABLE
2. tbl_
3. THBL
4. table1

01:45

In the exams what would the "data set" allow you to do?

1. Not important
2. Remove unimportant information.
3. Add more data
4. Normal your table into 1st Order form.

02:15

Customer details table , items ordered table, items in stock table. State whether they should be in the same table.
What is the relationship between
Customer table and Items ordered table

02:35

data set

03:34

Many - many Relationship
1 classes (like IT group A and B)
have many subjects.
1 Subject can belong to many classes.
Hence - Many to Many Relationship.
What do you need to implement this?- This is worth 1 Mark.

1. Primary key
2. 1 foreign Key.
3. bigger table
4. Joining table with Primary keys from both tables

03:37

State the relationship between
classes and subjects

03:55

What Name was given to
the Join table of Student_Id
and Class_Id?

04:13

What do you need to complete Activity 2

05:14

When designing your database table
what view should you be in

1. Layout view
2. More than View
3. Overview
4. Design View

05:27

What would be a suitable name
for a student table. You get marks for this !

05:38

Give a suitable name for
you database!

09:21

Explain

10:25

What does the combo box do?

10:35

Where would you find the Combo box

1. Look left
2. Look up
3. Look out
4. Look in

11:51

What would be the validation rule for the Levels.

1. Between 1 AND 3
2. More than 1 and less than 3
3. Less than 3
4. none of these

03:34