1.3.2 Databases Flashcards
what is a relational database?
a database which recognises the
difference between entities and uses different tables for each entity
what is an entity?
an item of interest about which
information is stored
what is a flat file?
a database that consists of a single file
(usually about one entity)
what is a primary key?
a unique identifier for each record in a table
what is a foreign key?
the attribute which links two tables
together
what is a secondary key?
an index other than the primary key used to search and sort through the database with more convenience and speed
what does capturing data mean?
the process of getting the information that will be stored in the database
what are the methods of capturing data?
-manually
-magnetic ink character recognition (MICR)
-optical mark recognition (OMR)
-optical character recognition (OCR)
what is MICR used for?
scanning checks at the bank