Module 13 Flashcards
(21 cards)
Field
A column containing a specific property for each record
Record
A row of data in a table
Relational database
A database that consists of a collection of tables that can be joined through a common field
Database management system (DBMS)
A software program that lets you create databases and then manipulate data in them
Relational database management system (RDBMS)
A software program in which data is organized as a collection of tables, and relationships between tables are formed through a common field.
Input mask
A field property that provides a visual guide for users as they enter data
Primary key
The field in a database that contains unique information for each record, also called a unique identifier.
Foreign key
A primary key field from one table that you include as a field in a second table to form a relationship between the two tables.
One-to-many relationship
A relationship between two database tables that connects each record in one table with one or more records in the other table.
One-to-one relationship
A relationship between two database tables that connects each record in one table with exactly one record in the other table.
Many-to-many relationship
A relationship between two database tables that connects one or more records in one table with one or more records in the other table.
Form
Designed for easily entering data into a table
Report
Outputs data in a visually appealing format
Confidentiality, Integrity, and Availability (CIA) triad
A classic security model that guides efforts to protect data from unauthorized access, protect data from unauthorized changes, and ensure data is accessible by authorized users when needed.
NoSQL databases (nonrelational databases)
A highly scalable and highly available database type that is designed to store unstructured data.
Key-value databases
A nonrelational database consisting of any number of key-value pairs for each record.
High availability
A characteristic of a computing resource that identifies the percentage of time the resource functions reliably.
Business intelligence (BI)
Software tools designed to extract useful information from big data.
Data warehouse
A type of database that serves as a central repository from other data sources and databases for the purpose of data analysis.
Data lake
A collection of both structured and unstructured data of diverse data formats.
Dashboards
A data visualization tool such as Power View.
