Networking-Databases Flashcards
Learn about how databases work and what they are used for
Form
User-friendly interface for adding to or retrieving information from a database.
Report
Formatted summary of information from a database.
Table
Stores raw data in a relational database.
Query
Retrieves specific information from a database. Can also be used to update, edit, and delete information.
Primary Key
A unique identifier for each record in a table.
Foreign Key
A value that’s used to identify a record from a linked table.
Field
Columns in databases are known as fields. Each field contains a specific type of information about each record.
Unique Values
Primary keys must always be unique values.
Customer ID
A primary key used to uniquely identify each customer record.
Records
Each row in a database table, representing a single item or entry.
Categories
Another term for columns in a relational database table.
Instances
Refers to individual occurrences of data in a database.
Linked Key
Incorrect term; the correct term is Foreign Key.
License Number
A unique identifier that is not shared by anyone else, even if they have the same first and last name.
Foreign Key
A field in a table that is a primary key from another table, establishing a relationship between the two tables.
Public and Private Keys
Keys used by encryption methods to secure data.
Query
A database feature that results in information resembling a spreadsheet with rows and columns.
Report
A formatted, easy-to-read listing of the results of a query.
Form
A database feature used to automatically build a query to retrieve database records.
Table
A structure used to store information in a database.
Record
A single instance of a thing stored in a database table.
SQL Command
Commands used to interact with a database.
NOT NULL Constraint
A rule that prevents certain fields in a database from being left blank.
Schema
The general database structure.
Query Builder
A method of accessing a database using a graphical user interface that allows users to select actions to perform on a database.
Scalability
A characteristic of databases that allows data to be modified and users to be added without impacting accessibility and performance.
