Database Review

What is a limitation of using a file-based approach to data storage due to data redundancy?

• Data is stored in one central location

• Data is repeated in more than one file

• Data is structured in tables, rows, and columns

• All users have access to all data if a single flat file

What is one of the benefits of relational databases over file-based approaches?

• Increased data redundancy

• Decreased data integrity

• Reduced data redundancy

• Decreased data privacy

What aspect of security is enhanced by giving different users different access rights in a relational database?

• Data redundancy

• Data integrity

• Data privacy

• Data accessibility

What is an entity in a database system?

• A unique identifier for each tuple

• A field within a table

• The concept that we want to model and store information about

• A field in one table that links to a primary key in another table

What is a primary key in a database?

• A field in one table that links to a primary key in another table

• A data item represented as a field within a table

• A unique identifier for each tuple

• The concept or object in the system that we want to model and store information about

What is a foreign key in a database?

• A unique identifier for each tuple

• A data item represented as a field within a table

• A field in one table that links to a primary key in another table

• The concept or object in the system that we want to model and store information about

What is the term used to describe all the data about one entity in the database?

• A) Attribute

• B) Tuple/Record

• C) Table

• D) Field

What is the term used to describe the data in one row of a table in the database?

• A) Attribute

• B) Tuple/Record

• C) Table

• D) Field

What is the term used to describe a column or field in a table in the database?

• A) Attribute

• B) Tuple/Record

• C) Table

• D) Field

Can a primary key be used as a foreign key in another table?

• No, a primary key cannot be used as a foreign key.

• Yes, but only in the same table.

• Yes, to form a relationship between the tables.

• Yes, but it will no longer function as a primary key.