Review of a Entity Relations Diagram and the Select Statement

Concepts used in this lesson include:

Database – A collection of tables

Enhanced Entity Relations Diagram (ERD) – A visual representation of a database

SQL – Structured Query Language

Data Definition Language (DDL) – A language used to create and modify a database

Data Manipulation Language (DML) – A language used to manipulate data in a database

Data Control Language (DCL) – A language used to control access to a database

Schema – A collection of tables and their relationships

Catalog – A collection of databases and their objects

Data Dictionary – A collection of data types and their properties

Data types – A classification of data

Primary Key – A unique identifier for a row in a table

Foreign Key – A unique identifier for a row in another table

Relationship – A connection between two tables

Bridge Table – A table that contains a foreign key

Associative Table – A table that contains a foreign key

Entity – A real-world object that you can store in a table

Table – A collection of rows and columns

Column – A field in a table

Row – A record in a table

Join – A SQL statement that combines two tables into one

View – A virtual table that is created from a query

Subquery – A query that is used in another query

Where Clause – A filter that is applied to a query