CIT 381 Chapter 7, Database Systems: Design, Implementation, and
Management
1. Alias: An alternative name for a column or table in a SQL statement.
2. ALTER TABLE: The SQL command used to make changes to table structure. When the command is followed
by a keyword (ADD or MODIFY), it adds a column or changes column characteristics.
3. AND: The SQL logical operator used to link multiple conditional expressions in a WHERE or HAVING clause. It
requires that all conditional expression evaluate to true.
4. Authentication: The process through which a DBMS verifies that only registered users can access the
database.
5. AVG: An SQL aggregate function that outputs the mean average for a specified column or expression.
6. BETWEEN: In SQL, a special operator used to check whether a value is within a range of specified values.
1/3
, 7. Boolean Algebra: A branch of mathematics that uses the logical operators OR, AND, and NOT.
8. Cascading Order Sequence: A nested ordering sequence for a set of rows, such as a list in which all
last names are alphabetically ordered and, within the last names, all first names are ordered.
9. COMMIT: The SQL command that permanently write data changes to a database.
10. COUNT: A SQL aggregate function that outputs the number of rows containing not null values for a given column
or expression, sometimes used in conjunction with the DISTINCT clause.
11. CREATE INDEX: A SQL command that creates indexes on the bases of a selected attribute or attributes.
12. CREATE TABLE: A SQL command that creates a table's structures using the characteristics and attributes
given.
13. DELETE: A SQL command that allows data rows to be deleted from a table.
2/3
Management
1. Alias: An alternative name for a column or table in a SQL statement.
2. ALTER TABLE: The SQL command used to make changes to table structure. When the command is followed
by a keyword (ADD or MODIFY), it adds a column or changes column characteristics.
3. AND: The SQL logical operator used to link multiple conditional expressions in a WHERE or HAVING clause. It
requires that all conditional expression evaluate to true.
4. Authentication: The process through which a DBMS verifies that only registered users can access the
database.
5. AVG: An SQL aggregate function that outputs the mean average for a specified column or expression.
6. BETWEEN: In SQL, a special operator used to check whether a value is within a range of specified values.
1/3
, 7. Boolean Algebra: A branch of mathematics that uses the logical operators OR, AND, and NOT.
8. Cascading Order Sequence: A nested ordering sequence for a set of rows, such as a list in which all
last names are alphabetically ordered and, within the last names, all first names are ordered.
9. COMMIT: The SQL command that permanently write data changes to a database.
10. COUNT: A SQL aggregate function that outputs the number of rows containing not null values for a given column
or expression, sometimes used in conjunction with the DISTINCT clause.
11. CREATE INDEX: A SQL command that creates indexes on the bases of a selected attribute or attributes.
12. CREATE TABLE: A SQL command that creates a table's structures using the characteristics and attributes
given.
13. DELETE: A SQL command that allows data rows to be deleted from a table.
2/3
