Database Analysis Revision

A unique identifier for each record in a table

A field used to store text-based data

A key that links two tables together

A command used to retrieve data

To link tables together

To store redundant data

To uniquely identify each record in a table

To allow NULL values in a table

To uniquely identify each record in a table

To establish a relationship between two tables

To store numerical values in a table

To improve query performance

A unique identifier for a table

A table that has no attributes

A temporary data entry

A link between two tables

A field that links two tables together

A combination of two or more attributes that uniquely identify a record

A key used to speed up database queries

A special key automatically generated by the database

A book has one author, and an author writes only one book

A student has one school, and a school has one student

A teacher has many students, but each student has only one teacher

A product has multiple suppliers, and each supplier provides multiple products

To improve data redundancy

To reduce the complexity of SQL queries

To eliminate duplicate data and improve efficiency

To increase the number of tables in the database

Ensuring that all fields in a table contain unique values

Preventing unauthorized users from accessing the database

Maintaining consistent and valid relationships between tables by enforcing foreign key constraints

Optimizing database queries for faster performance