IT103

1. What is the name of the table that is displayed above?

• Personal Information

• School fee

• Copy of Personal Information

What is the field size of the Student ID field?

• 8

• 7

• 6

How many students have been registered for school?

• 3

• 4

• 5

• 6

Which student is the oldest in the class?

• Beckford

• Gold

• Hulk

• Hazard

Whose data is listed in the last record?

• Beckford

• Gold

• Hulk

• Hazard

Which field data type is set to YES/NO?

• STUDENT ID

• Last Name

• AGE

• REGISTERED

Which field data type is set to Number?

• Telephone Number

• REGISTERED

• AGE

• Fees Paid

Which field data type is set to Text?

Telephone number is also actually text, it has the - hyphen.

• Student ID

• Date Birth

• Age

• Fees Paid

How many records are in the table?

• 7

• 6

STOP and Read. you have three minutes.

Primary key is the field that has been selected to identify a record and its unique.

Composite key is when the database administrator uses more than one fields to create a primary key. for example. HULK133459876

Candidate key is a field that also has unique fields but was not selected as the primary key. But can. Like a candidate in an event.

Secondary keys are the extra field that was not used as the primary key

Foreign is when you have a match of the primary in another table. This is needed to make a relationship

If Student ID is the primary key, which other field would be best to set as the candidate key. Pretend there were a 1000 records instead of 6.

• AGE

• Telephone number

• Date of Birth

• Last Name