Databases CSC12

Which over the following is not an example of a database?

• Student information in SEQTA

• Telephone Directory

• MS Word

• File Cabinet with sale records

A field that connects one table to another table that creates a relationship is called:

• Car Key

• Foreign Key

• Main Key

• Primary Key

A unique identifier for a record in a database is called a:

• Car Key

• Foreign Key

• Main Key

• Primary Key

A good example of a Primary Key for a car table would be:

• Make

• Model

• Registration Number

• Colour

A good example of a Primary Key for a "person" table would be:

• PersonID

• First Name

• Surname

• Suburb

Searching databases to find patterns and relationships is called:

• Data Mart

• Data Mining

• Data Wharehouse

• Data Storage

A flat file database has how many tables?

• One

• Two

• Three

• Four

A database that has two or more tables is called a:

• Flat File Database

• Relational Database

• Multi Database

• Dimensional Database

A relational database increases:

• data anomalies

• data integrity

• data complexity

• data costs

If the data in the database is accurate and correct it has:

• Low integrity

• High integrity