Data manipulation and Presentation

In database normalization, what is the key characteristic of a table that complies with the First Normal Form (1NF)?

• The table has been split into multiple related tables.

• All calculated fields have been removed from the table.

• There are no repeating groups, and each field contains only one value.

• Every non-key field is dependent only on the primary key.

  Hint

What is the primary function of a foreign key in a relational database?

• To combine multiple fields to create a unique identifier.

• To uniquely identify each record within a single table.

• To create a link to a primary key in another table, thereby establishing a relationship.

• To validate data as it is entered into a field

Which of the following describes a 'many-to-many' relationship in a database?

• One customer can place multiple orders, but each order belongs to only one customer.

• Each student can enroll in multiple subjects, and each subject can be studied by multiple students.

• Several employees in an office share a single telephone extension.

• Each passenger is assigned to one unique seat, and each seat is assigned to only one passenger.

When designing a database, what is the purpose of using a data dictionary?

• To meticulously plan the structure of a table, including field names, data types, sizes, and validation rules.

• To perform calculations on data after it has been queried.

• To store the actual data records for the database.

• To present the results of a query in a user-friendly format.

What is data cleansing, also known as data scrubbing?

• The process of detecting and correcting inaccurate, incomplete, or inconsistent data.

• The process of exporting data from a database into a CSV file.

• The process of arranging data into tables that conform to normal forms.

• The process of setting up validation rules to prevent bad data from being entered.

In a spreadsheet, if you have the formula '=A1 B1' in cell C1 and you drag it down to cell C2, the formula in C2 becomes '=A2 B2'. What is this behavior called?

• Data validation

• Relative referencing

• Conditional formatting

• Absolute referencing

What is the primary advantage of importing large datasets into a database before a spreadsheet for initial processing?

• Databases can automatically perform complex mathematical functions like SUMIF().

• Databases can use pre-set validation rules to automatically detect and quarantine problematic data during import.

• Database files like .mdb or .accdb are smaller and more easily transferable than spreadsheet files.

• Databases have more advanced charting and graphing tools.

Which design principle for data visualizations refers to the empty parts of the screen used to create a clean, uncluttered look?

• Leading

• White space

• Camel casing

• Kerning

What is the purpose of user acceptance testing (also known as beta testing)?

• To have the developer immediately check if a button or link works after creating it.

• To use a formal testing table to verify every function with specifically designed boundary data.

• To check that individual components, like a single formula, work correctly in isolation.

• To ensure the solution meets the needs of its intended users in real-world conditions.

According to the provided text, what distinguishes a flat file database from a relational database?

• A flat file database is stored electronically, while a relational database is on paper.

• A flat file database consists of a single table, leading to data redundancy, while a relational database uses multiple linked tables.

• A flat file database has a limit of one million records, while a relational database can store more.

• A flat file database uses queries to retrieve information, whereas a relational database does not.