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.
