Normalisation 2

What is the primary purpose of a database?

• To create spreadsheets for calculations
• To manage email communications
• To display information in a graphical format
• To store data in an organized way

Which of the following is a key advantage of using databases over spreadsheets?

• Databases allow for more complex data manipulation.
• Databases are less organized than spreadsheets.
• Databases can only store text data.
• Spreadsheets are better for large data sets.

Which of the following statements is true regarding database tables?

• Tables can only contain text data.
• Each table must have a unique name.
• Tables do not need to be linked.
• Each table can have the same name.

What does a primary key do in a database table?

• It stores multiple values in one field.
• It is used to sort data alphabetically.
• It uniquely identifies each record in the table.
• It links two tables together.

What is a composite key in a database?

• A key that is not unique.
• A key that is made up of two or more columns.
• A key that is made up of one column.
• A key that is used to sort data.

Which statement best describes a Database Management System (DBMS)?

• A DBMS is a programming language.
• A DBMS is used to manage data in a database.
• A DBMS is a type of spreadsheet software.
• A DBMS is only for small databases.

Why is a DBMS important for a database?

• It is only used for small databases.
• It eliminates the need for data.
• It organizes and manages data effectively.
• It makes data meaningless.

How does normalization help in database design?

• It increases the size of the database.
• It prevents duplicate or unreliable data.
• It eliminates the need for tables.
• It combines all data into a single table.

What problem does normalization aim to prevent in databases?

• Data redundancy and inconsistency.
• Data loss during storage.
• Slow data retrieval times.
• Inability to link tables.

What is the main goal of normalization in database design?

• To store data in a single format.
• To create larger tables.
• To divide larger tables into smaller ones.
• To link unrelated data.