A relational database is a type of database that stores data, and relations between the data, in
organized structures called tables.
A relational database management system, or RDBMS, is a system that provides an interface for managing
and using a relational database.
Tables organize data into rows and columns. The columns describe the type of data that each row should
supply, and the rows, also known as records, are sets of values corresponding to the table's
Each column defined for a table has at least two properties:
Name – an identifier for the column
Data type – the type of data stored in the column
SQL, or Structured Query Language, is a language used with RDBMS to:
Define the structure of a database & its tables
Insert, update, & delete data from a database
Query, or request, specific pieces of data from a database
SQL also defines several standard data types for data that can be stored in a database table:
Dates & Times
A primary key is a piece of data that can be used to uniquely identify table rows.
A table’s primary key refers to the column for which the value of that column in each row is
guaranteed to be unique.
Introduction to Databases
Lecture Slides are screen-captured images of important points in the lecture. Students can download and print out these lecture slide images to do practice problems as well as take notes while watching the lecture.