AHJN: U8 DB Fr-TB

What is a primary key in a relational database?

• A foreign key that links to another table

• A unique identifier for a table

• A candidate key that is an alternative to the primary key

• An attribute that contains non-unique values

Which of the following is a characteristic of a file-based approach to data management?

• Data is stored only once

• Data redundancy is minimized

• Data is independent

• Storage space is wasted due to data duplication

What is a relational database?

• A database that organizes data into tables with relationships defined by keys

• A database where data items are not linked

• A database that uses a file-based structure

• A database that stores all data in a single table

In database terminology, what is a 'tuple'?

• A column in a table

• A row in a table representing a record

• A database itself

• A relationship between tables

What is the purpose of normalization in a database?

• To increase data redundancy

• To complicate data retrieval

• To organize data and minimize data redundancy

• To slow down data access

What is First Normal Form (1NF)?

• Entities are in 1NF and all non-key attributes are independent

• Entities do not contain repeated groups of attributes

• Entities are in 1NF and any non-key attributes depend upon the primary key

• The database is fully normalized

Which of the following is a benefit of using a database approach over a file-based approach?

• Increased data redundancy

• Data inconsistency

• Data independence

• Data is dependent on the application

What is a candidate key?

• A primary key in another table

• A non-unique identifier for a table

• An attribute or set of attributes that uniquely identifies a record

• A key used only for sorting data

What is a foreign key?

• A unique identifier within its own table

• A key that is not unique

• A set of attributes in one table that refers to the primary key in another table

• A key used to sort data

What is referential integrity?

• A state where data is inconsistent

• A property of a database where foreign keys must match corresponding primary keys

• A method of data redundancy

• A process of data normalization