Data Types
This data type can store text, numbers, URLs, or passwords, but is more expensive in terms of storage.
What is a String (or Varchar)?
A field where you can perform sums, averages, or other aggregations (like sales quantity or GPA).
What is a Fact?
A Dimension with a natural or logical sequence (like months: Jan, Feb, Mar, ...) is called this.
What is Ordinal?
The unique identifier for a table, of which there is exactly one per table, is known by this abbreviation.
What is a PK (Primary Key)?
This software is limited to about 1 million rows per spreadsheet and is prone to crashing with large data.
What is Excel?
This numeric data type is used for storing numbers that can include decimal points, such as currency.
What is a Float?
A field that describes data elements that are used to categorize or classify the data, such as a store or product.
What is a Dimension?
A Dimension with no inherent order (like red, blue, green for colors) is called this.
What is Nominal?
This type of key points to another table’s primary key, creating a link between tables.
What is a FK (Foreign Key)?
This type of system scales to handle large datasets beyond a single computer’s resources.
What is a Relational Database (or Database in general)?
This data type can store only two values, typically stored as 1 or 0.
What is a Boolean?
Name one dimension from everyday life, such as a characteristic describing you or your environment.
What is a Name, Location, Customer, Category?
A Fact with a set number of possible values (like a GPA range of 0.0 to 4.0 or days of the month 1–31).
What is Discrete?
The relationship where one record in Table A corresponds to many in Table B, but those B records link back to only that single A record.
What is a One-to-Many relationship?
Relational databases rely on roles and permissions to ensure this protective measure
What is data security?
This date-related data type includes hours, minutes, and seconds for more precise timestamps.
What is Datetime?
Name one fact from everyday life, usually a numeric measure that can be aggregated.
What is Height, Sales, GPA, or Profit?
A Fact with infinitely many possible values (like sales, profit, quantity) is called this.
What is Continuous?
A unique identifier created by combining multiple columns is referred to as this.
What is a Composite Key?
Unlike Excel, relational databases maintain this concept across tables to ensure data accuracy, completeness and quality over time.
What is data integrity?
Common geospatial data types include Point, Line, and this shape type for boundaries like states.
What is a Polygon?
This concept of separating data into facts and dimensions is crucial for which area of data management?
What is Data Warehousing?
An Order ID might look sequential but doesn’t strictly follow an order. Its subcategory is usually this.
What is Nominal?
This term describes the relationships between tables (e.g., 1-to-1, 1-to-many).
What is Cardinality?
A key advantage of databases is improved ________ and ________, meaning users can be restricted from altering certain data.
What are Data Integrity and Security?