Upgrade to remove ads
Only $35.99/year

Computer Concepts 2018 Module 10 Section C

Terms in this set (24)

database structure
refers to the arrangement of fields, tables, and relationships in a database.
computed field
a calculation that a DBMS (database management system) performs, similar to the way a spreadsheet computs a formula.
primary key
a field that contains data unique to a record. (customer ID #, account #, SS#, Telephone#
What would be the best primary key for a customer table?
Customer ID #
Case-sensitive database
uppercase letters are not equivalent to their lowercase counterparts.
field format
template that adds the correct formatting as data is entered.
Which field would use a field format?
telephone number: 9318675309 = (931) 867-5309
field validation rule
filters data entered into a particular field. ($19.98 will not be mistook for $1,998.00)
lookup routine
validates an entry by checking data in an in house or third party database. (shipping address is checked against the USPS data base)
data type
specifies the way dat is represented on physical storage media and in RAM.
Data Types
real, integer, date, text, memo, logical, BLOB-(binary large objects), Hyperlink
Which data type to use in a Music database?
BLOB, binary large objects.
normalization
helps database designers create a database structure that minimizes storage space and increases processing efficiency.
redundancy
normalization reduces the amount of data that is duplicated in a data base called _______________
physical sort order
the order in which records are arranged on storage devices.
sort key
the column of data that is used as the basis for rearranging the data .
database index
contains a list of keys, and each key provides a pointer to the record that contains the rest of the fields related to that key.
report generator
software tool for specifying the content and format for a database report. Most DBMSs include them.
report template
contains the outline or general specifications for a report. including report title, fields to include, fields to subtotal or total and report format specifications. Does not contain data from databases.
report template contains NO_______________
data
A ___________________ such as SS#, contains data unique to a record.
primary key
To filter data as it is entered into a field, a database designer can set up a field ___________________
validation rule
Database designers use a process called _________to minimize data redundancy in a database
normalization
As an alternative to storing data in sorted order a database can be ___________________ to produce a list of keys that can be used to alphabetize or otherwise organize the record.
indexed.
Sets found in the same folder