Introduction to Database concepts

What is a database?

• A collection of data
• A computer program
• A spreadsheet
• A website

What are the benefits of organizing data into a database?

• Easy addition, modification, deletion, and searching of data
• Faster data retrieval
• Ability to make copies and backups
• All of the above

What is a primary key?

• A unique field in a record
• A field used for searching data
• A foreign key in a table
• A field that links tables together

What is a foreign key?

• A unique field in a record
• A field used for searching data
• A primary key in a table
• A field that links tables together

What is entity relationship modeling?

• A way to draw relationships between tables
• A method to organize data in a database
• A technique to create primary keys
• A process to normalize data

What is normalization?

• A way to draw relationships between tables
• A method to organize data in a database
• A technique to create primary keys
• A process to eliminate data redundancy

What is indexing in a database?

• A way to sort data in a table
• A method to create primary keys
• A technique to optimize data retrieval
• A process to eliminate data redundancy

What is a flat file database?

• A database with multiple tables
• A database with only one table
• A database with complex relationships
• A database with no primary keys

What are the drawbacks of a flat file database?

• Repetitive data and inefficient storage
• Slow data retrieval
• Difficult to maintain
• All of the above

What is a one-to-many relationship in a database?

• One record in one table is related to many records in another table
• One record in one table is related to one record in another table
• Many records in one table are related to one record in another table
• Many records in one table are related to many records in another table