Lesson 1: Intro to Database Design and SQL Flashcards
Data
Raw facts that need to be processed to become meaningful and useful
Database
A collection of related data that is organized so that it can be easily accessed, managed, and updated. A file cabinet could be considered a paper database. This SQL course is about electronic databases.
Database Management System
The software that handles the storage, retrieval, and updating of the data in the computer system.
Information
Data that has been processed and has meaning and context; it can be used to make decisions.
Relational Database
A database where the data is stored in a table format with rows and columns. Each table is related to another table through a primary key.
Column
One data item that is a field in a table. For example: name, gender, birthdate
Data Integrity
The assurance of the accuracy and consistency of the data.
Data Redundancy
Data that is duplicated in the database. This should be minimized by the design of the tables.
Field/Columns
The column in a database table. It is one type of data.
Foreign Key (FK)
The FOREIGN KEY is a key that is used to connect two tables. The FOREIGN KEY is a column or columns in one table that refers to the PRIMARY KEY column in another table.
Null
A field with no value. It is left blank.
Primary Key (PK)
The primary key is a column or columns that uniquely identifies each row in the table. It cannot be left blank.
Record
A row in a database table. It is a collection of data fields about one item. When you start writing SQL query statements, we will refer to a record as a row
Relationship
The link that connects relational database tables.
Row
One record in a table made up of several columns. Same as the record
