Database Terminology

This is the primary key, it helps relates to other

• Table

• Foreign Key

• Query

What is the definition of Select Statement?

• create, modify, or remove entire tables within a database

• a query containing the word select that simply displays data to the other user

• a critical and identifying piece of data

This is the programming language that is standard for querying a database.

• Primary Key

• SQL

• DDL

This can either create, modify, or remove entire tables within a database.

• SQL

• DDL

• Foreign Key

This holds information from both tables and has a primary key that is a combination of the foreign keys from both tables that it is relating to.

• Database management system

• Junction table

• Select Statement

What is the definition of Query?

• a critical and identifying piece data

• the process that involves writing a snippet of simple code that displays or alters data in a database, matching the requirements given by the user

• a specialized software that handles the storage, updating, and retrieval of data.

This is a structured collection of data, a large organize collection of information.

• Data

• Database Management

• Database

This works in conjunction with a primary key, tells two tables they are housing similar columns.

• Primary Key

• Foreign Key

• SQL

This is a specialized software that handles the storage, updating, and retrieval of data that is housed within a database.

• Database

• Foreign Key

• Database Management System

A critical identifying piece data.

• Primary Key

• Foreign Key

• Table