Chapter 9 - Databases

Question 1

Database

Answer 1

Structured collection of data that allows people to extract information in a way that meets their needs

Question 2

Single table database

Answer 2

Data base containing only one table

Question 3

Table

Answer 3

Collection of related records in a database

Question 4

Record

Answer 4

Collection of fields that describe one item (rows)

Question 5

Field

Answer 5

Database table (columns)

Question 6

How databases prevent problems (3)

Answer 6

Everyone uses the same data
Data is consistent (changes/additions only have to be made once)
Data only stored once in relational databases so no data duplication

Question 7

What are data bases used for (3)

Answer 7

To store information about:
-people
-events
-things

Question 8

Difference between fields and records

Answer 8

Fields are fixed records can vary

Question 9

Validation

Answer 9

Prevents incorrect data from being entered

Question 10

Basic data types (6) in a database

Answer 10

Boolean
Character
Integer
Text/alphanumeric
Real
Date/time

Question 11

Data type

Answer 11

Classification of how data is stored and displayed and of which operations can be performed on the stored value

Question 12

Primary key

Answer 12

Field in a database that uniquely identifies a record

Question 13

SQL

Answer 13

Structured query language
For writing scripts to obtain useful information from a relational database

Question 14

SQL scripts

Answer 14

List of SQL commands that perform a given task often stored in a file so the script can be reused

Question 15

FROM

Answer 15

SQL command that fetches specified fields (columns) from a table

Question 16

WHERE

Answer 16

SQL command to include only those records in a query that match a given condition

Question 17

ORDER BY

Answer 17

SQL command that sorts results from a query by a given column either alphabetically or numerically

Question 18

SUM

Answer 18

SQL command that returns the sum of all values in a field (column) USED WITH SELECT

Question 19

COUNT

Answer 19

SQL command that counts the number of records (rows) in which the field matches a specific condition
Used with SELECT

Question 20

SELECT

Answer 20

SQL command that fetches specified fields (columns) from a table