BTEC unit 2 databases - key terms

A row in a database.

• Record
• Field
• Entity
• Table

A unique identifying field.

• Primary Key
• Integer
• Verification
• Boolean

What is a database?

• A piece of software to do calculations
• A device to load information onto the computer.
• A structured collection of information
• A calculator

Which of the following describes a relational database?

• Access
• A database that has a table
• There are two or more tables that are linked using the primary keys
• There are more than one table that have duplicate data

A sports club needs to store information about each member.  The individual information about each member is called a:

• Field
• File
• Table
• Record

One specific piece of information about a person or thing is called:

• Field
• File
• Record
• Table

Which of these could be a primary key?

• Centre number
• Surname
• Teacher name
• Students addresses

How many records are in this database?

• 8
• 5
• 10
• 12

What is the primary key in this database?

• Emp_Id
• Last Name
• Gender
• Title

SQL stands for

• Structured Query Language

• Sequenced Query Language

• Structured Question Language

• Structured Query Learning