Course 3: Module 3 Flashcards

1
Q

Metadata

A

Data about data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Foreign key

A

A field within a table that is a primary key in another table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Primary key

A
  • Used to ensure data in a specific column is unique
  • Uniquely identifies a record in a relational database table
  • Only one primary key is allowed in a table
  • Cannot contain null or blank values
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Foreign key

A
  • A column or group of columns in a relational database that provides a link between the data in two tables
  • Refers to the field in a table that’s the primary key of another table
  • More than one foreign key is allowed to exist in a table
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Relational database

A

a database that contains a series of tables that can be connected to form relationships. Basically, they allow data analysts to organize and link data based on what the data has in common.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Normalization

A

a process of organizing data in a relational database. For example, creating tables and establishing relationships between those tables. It is applied to eliminate data redundancy, increase data integrity, and reduce complexity in a database.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Composite key

A

a revenue table can have multiple foreign keys and not have a primary key. A primary key may also be constructed using multiple columns of a table.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Structural metadata

A

Metadata that indicates how a piece of data is organized and whether it is part of one, or more than one, data collection

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Administrative metadata

A

Metadata that indicates the technical source of a digital asset

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Data governance

A

A process to ensure the formal management of a company’s data assets

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Internal data

A

Data that lives within a company’s own systems

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

External data

A

Data that lives and is generated outside an organization

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Openness (or open data)

A

Free access, usage, and sharing of data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Sorting data

A

Arranging data into a meaningful order to make it easier to understand, analyze, and visualize

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Filtering

A

Showing only the data that meets a specific criteria while hiding the rest

How well did you know this?
1
Not at all
2
3
4
5
Perfectly