Course 3: Module 3 Flashcards
Metadata
Data about data
Foreign key
A field within a table that is a primary key in another table
Primary key
- 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
Foreign key
- 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
Relational database
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.
Normalization
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.
Composite key
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.
Structural metadata
Metadata that indicates how a piece of data is organized and whether it is part of one, or more than one, data collection
Administrative metadata
Metadata that indicates the technical source of a digital asset
Data governance
A process to ensure the formal management of a company’s data assets
Internal data
Data that lives within a company’s own systems
External data
Data that lives and is generated outside an organization
Openness (or open data)
Free access, usage, and sharing of data
Sorting data
Arranging data into a meaningful order to make it easier to understand, analyze, and visualize
Filtering
Showing only the data that meets a specific criteria while hiding the rest