| A | B |
|---|
| Table | a data structure that organizes information into rows and columns. It can be used to both store and display data in a structured format. |
| Query | a request for data or information from a database table or combination of tables. |
| Field | are the containers that store pieces of information or data in database tables |
| Record | Data is stored in records. A record is composed of fields and contains all the data about one particular person, company, or item in a database. |
| Relationship | is a situation that exists between two relational database tables when one table has a foreign key that references the primary key of the other table. |
| ERD | An entity relationship diagram (ERD), also known as an entity relationship model, is a graphical representation that depicts relationships among tables within a database. |
| SELECT | extracts data from a database |
| UPDATE | creates a new database |
| INSERT INTO | modifies a database |
| CREATE DATABASE | creates a new table |
| ALTER DATABASE | modifies a table |
| DROP TABLE | deletes a table |
| CREATE INDEX | creates an index (search key) |
| DROP INDEX | deletes an index |
