SLR10 Flashcards
What is a database
An organised collection of data
What does a database need to be able to do
Add data
Modify data
Delete data
Find data
Where were databases stored before the developments of technology
Physical paper format in filing cabinets
What did technology do to make the functionality of databases better
Made it easier to retrieve data, back up data, access data and modify data
How is a flat file data base stored
In a table
What are the names of the columns and rows in a flat file database
Fields and records
What are the benefits of a flat file database (3)
- They are really easy to set up
- They are really simple
- They require little maintenance
What are the losses of a flat file database (3)
- Can become inefficient quickly due to repeated data
- Making them slow
- Using up unnecessary space
What are the benefits of a flat file database compared to relational database
- Simple to manage
- Great for a small database
- In expensive
What are the drawbacks of a flat file database compared to relational database (2)
- Takes up a lot of unnecessary spade on the computer
- Increased data redundancy
What are the benefits of a relational database compared to flat file database (2)
- More data efficient
- Much better for expansion
What are the drawbacks of a relational database compared to flat file database (2)
- Very time consuming to set up
- Much more expensive to set up
What is a relational database
A database that has been split over multiple tables
What are the three different ways relational databases can be linked
- One to One
- One to Many
- Many to Many
When linking relational databases which is considered to be the worst
Many to Many
What is the most important thing in making a relational database effective
You are able to find things quickly
What is a primary key in a relational database
An item of data that keeps record in every table unique in some way
How can secondary index be made in relational databases
From a piece of data (field) this will be used as the search key
When working in a database what are the 4 ways of handling data
- Capturing
- Selecting
- Managing
- Exchanging
In a database what is the process of capturing
Getting the data into the database
In a database what is the process of selecting
Being able to query or search for the data
In a database what is the process of managing
This is the action of manipulating the data (add, edit and delete)
In a database what is the process of exchanging
Moving the data from one device to another
What effect will data being in a paper format have on the data itself
The data has to be imputed into a computer, to avoid human error and save time Data Capture Forms allow a computer to scan the data off of a paper without anyone having to input any information into the computer