Title: Identify relational database terminology.
Course: Programming, Advanced (10152-II) > Section: Developing Database Applications

Identification should include the following terms and their definitions:

- Relational database—a database that stores information in one or more tables
- Table—a group of related records, with each record in the table pertaining to the same topic and composed of the same fields
- Record—a row or entry in the table
- Field—a single item or column of information about something (e.g., name, address, or phone number)
- Data type—examples include VARCHAR2(), NUMBER(), DATE, CHAR, LONG, BLOB, CLOB
- Relationships—types include one-to-one, one-to-many, and many-to-many
- Primary key—a special relational database table column (or combination of columns) designated to uniquely identify all table records
- Structured Query Language (SQL)—a standard computer language for relational database management and data manipulation used to query, insert, update, and modify data
- Index—a method for accessing data in a table