Chapter 3 - Database Applications Flashcards
What is a flat file database?
In a flat-file database, all the data is stored in one table
What is a relational database?
In a relational database, each object (or entity) has it’s own table.
The tables are joined together by relationships
What is a key field?
The key field uniquely identifies each record in a table
Also called a primary key
What are tables made up from?
Tables are made up from records.
Records are made up from fields.
What is a column in a database table called?
A column in a database table is a field
What is a row in a database table called?
A row in a database table is a record
What is a record?
A record is a set of all the data items that relate to one object in a table
What is a field?
A field stores a single piece of data about an object
What is a query?
A query is a feature of a database…
…that allows records to be selected (searched) based on criteria
Used to search for records that match criteria
What is a form?
A form is a feature of a database …
…that can be used to collect new records, modify existing records or view records already stored in a table
Used to collect data about objects
What is a report?
A report is a feature of a database…
…that allows tables and query results to be presented in a user-friendly way
What is a macro?
A macro is a small program that performs a repetitive task automatically
What is a foreign key?
A foreign key is a field in a table that is the primary key in a different table.
Foreign keys and Primary keys are joined together to make relationships between tables.
What are the 3 types of database relationships?
one-to-one
one-to-many
many-to-many
What is referential integrity?
Referential integrity ensures that data is consistent between tables. E.g. a record of an exam result could not be created in a results table if the student did not already exist in a related student table.
What is importing data?
Importing data is copying data from one application (like a spreadsheet) into another application (like a database)
List 5 data types used in databases
Text
Number
Date/Time
Autonumber
True/False (or Yes/No)
What is data validation?
Data validation checks any input data to make sure it is within acceptable limits.
What are the 5 types of validation?
Presence check
Length check
Type check
Format check
Range check
What are the 6 comparison operators?
> greater than
= greater than or equal to
< less than
<= less than or equal to
= equal to
<> not equal to
BETWEEN
List 2 types of logical operator
AND
OR
