Introduction to Databases

What is a database?

• A database is a software program used for creating spreadsheets.

• A database is a structured collection of data.

• A database is a type of computer hardware.

• A database is a random collection of data.

What is the purpose of a database?

• To delete data

• To store and manage data.

• To encrypt data

• To organize files

What are the advantages of using a database?

• Improved data integrity, data consistency, data security, data sharing, data scalability, and data backup and recovery.

• Higher cost of implementation, increased complexity in data management, and limited data sharing capabilities.

• Limited access to data, increased risk of data loss, and difficulty in data retrieval.

• Faster data processing, reduced storage space, and improved data visualization.

What is a table in a database?

• A table in a database is a collection of related data organized in rows and columns.

• A table in a database is a collection of functions and procedures.

• A table in a database is a collection of unrelated data organized in rows and columns.

• A table in a database is a collection of files and folders.

What is a record in a database?

• A record in a database is a backup of the entire database.

• A record in a database is a single data field.

• A record in a database is a type of database management system.

• A record in a database is a collection of related data fields that are organized and stored together.

What is a field in a database?

• A field in a database is a software program used to manage data.

• A field in a database is a query used to retrieve information.

• A field in a database is a specific piece of information that is stored in a database table.

• A field in a database is a type of data structure.

What is a primary key in a database?

• A primary key in a database is a field that can be duplicated in multiple records.

• A primary key in a database is a random number assigned to each record.

• A primary key in a database is a field that stores the most important data.

• A primary key in a database is a unique identifier for each record in a table.

What is a foreign key in a database?

• A foreign key in a database is a field that stores the primary key of another table.

• A foreign key in a database is a field that is used to uniquely identify a record in a table.

• A foreign key in a database is a field or a set of fields in a table that refers to the primary key of another table.

• A foreign key in a database is a field that is used to sort the records in a table.

What is a query in a database?

• A query in a database is a way to delete data from a database.

• A query in a database is a type of database table.

• A query in a database is a request for information from a database.

• A query in a database is a method to organize data in a database.

What is normalization in a database?

• The process of organizing data to minimize redundancy and dependency.

• The process of deleting data from a database.

• The process of organizing data to maximize redundancy and dependency.

• The process of adding redundancy to data in a database.