DH20x Week 5 (textbook-glossary)

Database -  is an organized collection of ____________, or data, typically stored electronically in a computer system.

• structured information

• unstructured information

• structured facts and opinions

• columns and rows

Relational Database - a relational database is a type of database that stores and provides access to ______________________.

• user accounts and administration tools

• metadata related to culture artifacts

• data points that depended on facts

• data points that are related to one another

A column (or set of columns) whose values uniquely identify each row in a table.

• Primary key

• Foreign key

• Surrogate key

• Composite key

This key is formed when more than one column in a table is merged to constitute the primary key.

• Complex key

• Foreign key

• Surrogate key

• Composite key

When multiple copies of the same data have conflicting values because not all copies have been updated correctly.

• Data Redundancy

• Data Inconsistency

• Data Integrity

• Data Accuracy

Unnecessary duplication of data across multiple locations, leading to errors and wasted storage.

• Data Redundancy

• Data Inconsistency

• Data Integrity

• Data Accuracy

The accuracy, consistency, and reliability of data over its entire life cycle.

• Data Completeness

• Data Cyclicity

• Data Integrity

• Data Accuracy

The reliability and correctness of data.

• Data Completeness

• Data Cyclicity

• Data Fairness

• Data Accuracy

Which is the example of Camel Case naming?

• correct_answer_is_here

• CorrectAnswerIsHere

• correctAnstwerIsHere

• correct ANSWER is HERE

Which is the example of Pascal Case naming?

• correct_answer_is_here

• CorrectAnswerIsHere

• correctAnstwerIsHere

• correct ANSWER is HERE