databases pmt flashcards
what is a relational database
a database which recognises the differences 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 the r 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 method do banks use to capture data from cheques
magnetic ink chatter recognition(MICR) is used for all the details apart from the amount which must be entered manually
what does selecting data mean
selecting data is the process of removing excess information to extract only the data you require
what does managing the data mean
to manipulate the information collected in any type of way such as through sorting through it or selecting certain parts using SQL
What is the most common language used to manipulate data in databases
SQL
