CSMI week 10

What is the primary goal of database normalisation?

• To increase data redundancy

• To reduce data redundancy

• To enhance data encryption

• To improve data visualisation

Which normal form eliminates repeating groups in a database table?

• First Normal Form (1NF)

• Second Normal Form (2NF)

• Third Normal Form (3NF)

• Boyce-Codd Normal Form (BCNF)

What is a common data validation technique used to ensure data integrity?

• Data Encryption

• Input Masking

• Data Compression

• Data Replication

In MS Access, which tool is primarily used to create reports?

• Query Designer

• Report Wizard

• Form Builder

• Macro Editor

What is a key characteristic of a relational database?

• Data is stored in a hierarchical structure

• Data is stored in flat files

• Data is stored in tables with relationships

• Data is stored in a single table

Which of the following is NOT a type of query in MS Access?

• Select Query

• Update Query

• Delete Query

• Encrypt Query

What is an entity in the context of a database?

• A type of query

• A table column

• A real-world object or concept

• A database user

Which normal form requires that all non-key attributes are fully functional dependent on the primary key?

• First Normal Form (1NF)

• Second Normal Form (2NF)

• Third Normal Form (3NF)

• Fourth Normal Form (4NF)

What is the purpose of a validation rule in a database?

• To encrypt data

• To ensure data accuracy and consistency

• To compress data

• To replicate data

Which feature in MS Access allows users to input data into a database?

• Reports

• Queries

• Forms

• Macros