Flashcards
SLR 10 - Database
Flashcards do conjunto (12)
- 1What are Serial files?Permanent storage of data.
Data is not stored in any order.
Whole file needed to be read to be able to index.
Useful for storing transactions and initialization files. - 2What is a Sequential file?Data is stored in the order.
Order is maintained when new records are added.
Indexed Sequential file.
Allows the file to be indexed.
Specific groups of data can be accessed. - 3What is a Database?Structured persisting collections of data.
Makes process more efficient.
Reduces storage requirements.
Avoids redundancy.
Allows different users to only see relevant data. - 4What are Records?Rows in a database
Each record stores data for each file - 5What is a Field?Columns
Define the different pieces of data which each record holds - 6What is a Flat file database?A single table which stores all the data in a database
Data may be repeated in different records
Hard to edit due to the vast amounts of data
Redundant data - 7What is a Relational Database?Has multiple related tables
Tables for different data which are interconnected
Makes editing data easy as data is stored into specific tables
No repeated data - 8Name the 4 different types of connection in a relational databaseOne to many
Many to one
One to one
Many to many - 9What type of keys are there used in a databasePrimary key
Concatenated primary key
Foreign key
Secondary keys - 10What is Indexing?Allows specific records to be found by using
Faster than searching sequentially - 11What is Paper Data Capture Form?A dedicated paper form with all the fields you want to fill out for a record
Clearly labelled
Filled out with a black pen so it can be clearly read
Data written on the sheet is then read and inputted into the database - 12—