A2 Computer Science 4.10 Databases

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

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

• Field
• File
• Record
• Table

A collection of fields and records in a specific category

• Record

• Table

• Field

The best data type to choose for date of birth would be

• Number

• Date/Time

• Text

• Currency

The best data type to choose for a memberID would be

• Number

• Date/Time

• Text

• Currency

Which of the following would be used to uniquely identify a record?

• Validation

• Data type

• Primary key

• Field size

For A Relational Database, which of these statements defines an " attribute" ?

• A structure where all the data in a database is stored

• A value defined to hold a specific type of data, such as dates, numeric, or textual data.

• A request for data or information from a database.

• A value that uniquely identifies each record in the table.

• A value relating to an entity that we wish to store.

For A Relational Database, which of these statements defines a "primary key" ?

• A structure where all the data in a database is stored

• A value defined to hold a specific type of data, such as dates, numeric, or textual data.

• A request for data or information from a database.

• A value that uniquely identifies each record in the table.

• A value relating to an entity that we wish to store.

For A Relational Database, which of these statements defines a "Table" ?

• A structure where all the data in a database is stored

• A value defined to hold a specific type of data, such as dates, numeric, or textual data.

• A request for data or information from a database.

• A value that uniquely identifies each record in the table.

• A value relating to an entity that we wish to store.