Database Intro (A Level CS)

Databases are split into separate...

• Tables

• Worksheets

• Modules

Categories of data in a database table are known as...

• Values

• Formats

• Fields

• Items

Each table needs one field which acts as a unique reference which cannot be repeated. This is known as the...

• Key Value

• Primary Key

• ID

• ERD

In an ERD, each table translates into...

• An Entity

• A Relationship

• A Database

• An Attribute

In an ERD, each column heading (e.g. name, address, etc) is listed as...

• An Entity

• A Relationship

• A Database

• An Attribute

What does ERD stand for?

(a)  

Tables are linked by _____ lines.

• Ley

• Relationship

• Attribute

• Link

If a unique value in one table can be linked to multiple values in another table, this is known as a _______ relationship.

• 'one-to-many'

• 'one-to-one'

• divergent

• convergent

ERDs allow you to easily spot errors such as (a)   data.

ERDs can only be created after you have made the database.

• True

• False