Chapter 9 Definitions Flashcards
Define database
A persistent structured collection of data that allows people to extract information in a way that meets their needs
Define single-table database
A database that contains only one table
Define table
A collection of related records in a databaseD
Define record
A collection of fields that describe one item
Define field
A database table
Define data type
A classification of how data is stored and displayed, and of which operations that can be performed on the stored value
Define primary key
A field in a database that uniquely identifies a recordq
Define SQL
Structured Query Language - the standard query language for writing scripts to obtain useful information from a relational database.
Define SQL scripts
A list of SQL commands that perform a given task; often stored in a file so the script can be reused
Define SELECT
An SQL command that fetches specified fields (columns) from a table
Define FROM
An SQL command that identifies the table to use
Define WHERE
An SQL command to include only those records (rows) in a query that match a given condition
Define ORDER BY
An SQL command that sorts the results from a query by a given column either alphabetically or numerically
Define SUM
An SQL command that returns the sum of all the values in a field (column)
Define COUNT
An SQL command that counts the number of records (rows) in which the field (column) matches a specified condition; used with SELECT
