Computing: Databases

?
Define a database
A persistent organised store of data on a computer system
1 of 43
Why do businesses need databases?
In order to operate properly. Businesses could not function without them.
2 of 43
Databases should be..
accurate, up to date, available to those who need them, protected from those who should not have access
3 of 43
Database administrators go to great lengths in order to protect their data against:
errors, loss, insufficient data, inconsistencies, unauthorised access
4 of 43
How could data be lost?
A catastrophe, such as a fire or flood, an accident, such as an employee deleting data, malicious action.
5 of 43
Errors in databases can result in:
Embarressment, such as sending bills to customer who have died. Financial loss, such as if a bank account is wrongly credited or debited. Life or death situations, such as incorrect navigational data for an aircraft.
6 of 43
To avoid database problems, data is protected by:
Making regular backups, having a mirror database server so that data is saved in at least two places, storing backups in a safe place such as the cloud, restricting access, keeping audit trails of who has accessed data.
7 of 43
What does data integrity mean?
The data reflects reality. The accuracy and consistency of data stored in a database.
8 of 43
How can data integrity be maximised?
Suitable validation, software that prevents inconsistent states
9 of 43
Explain the term 'validation'
The process of checking data when it is input. Carried out by software not humans. It checks the data conforms to certain rules.
10 of 43
Explain the term 'verification'
The process of checking that the data entered is correct. It can be a simple visual check against the source data or an algorithm checks two copies, entered independently, and flags up inconsistencies
11 of 43
Define the term 'redundancy'
the storing of the same data in multiple locations. An example of data redundancy is saving the same file five times to five different disks.
12 of 43
What do databases make data easy to?
Access, search, sort, group, copy and protect.
13 of 43
What is a view?
A subset of the data in a database.
14 of 43
What does CRUD stand for?
Create, read, update and delete.
15 of 43
What is data matching?
Compares different databases to look for paticular relationships . For example, it can be used to compare housing benefit claims with credit agency data in order to uncover benefit fraud.
16 of 43
What is data mining?
Process that looks in many different unrelated databases. it may show up unexpected relationships that may not have been noticed before. An example is using a supermarket card data to look for connections between purchases and lifestyle indicators.
17 of 43
What is a model?
A model is a data structure that attempts to represent reality in such a way that is useful to the owner of the database.
18 of 43
What is the simplest model?
A flat file database. This is just rows and columns such as would be suitable for an address book.
19 of 43
What is a row called in a database?
Record
20 of 43
What is a column called in a database?
Field
21 of 43
Why are flat file databases limited?
Data might be repeated unnecessarily, such as the names of cities in an address book. This would be data redundancy.
22 of 43
What is a hierarchical database?
Linking items that are related to an item. Like a diagram.
23 of 43
What is a relational database?
Store data in seperate tables. The tables are linked together so that related data can easily be extracted.
24 of 43
What is a DBMS?
A database management system is a piece of software that looks after a database at a fundamental level. It acts as a go between connecting applications to the underlying data.
25 of 43
What does a DBMS allow database administrators to do?
Create database applications, protect data, run queries to extract data, keep data consistent and keep data accurate.
26 of 43
Why is it important to separate the applications from the data?
Programmers do not have to worry that their applications might damage existing data structures, new applications can be written without restructuring the data, data can be more easily shared between applications, data remains consistent.
27 of 43
What is a transaction?
When a change takes place in a database. Transactions must not damage the integrity of a database.
28 of 43
What happens if two users try to modify data at the same time in a multi-user database?
One of the transactions will fail.
29 of 43
What is record locking?
It means that when a user has opened a record for writing, other users can only view it until the transaction is committed. Then it is unlocked for other users.
30 of 43
What is a table?
Structures where data is stored
31 of 43
What does a primary key do?
Uniquely identifies a record, can be one field usually a reference of some sort or a combination of fields
32 of 43
The primary key of one table can be linked to..
the foreign key of another table.
33 of 43
What does the designer need to do when setting up a field?
Choose what data type it will be.
34 of 43
What is a form and what does it provide?
Data can be inputted into tables from forms or selected data can be output to the screen in a form. Forms have objects, such as buttons and drop-down lists, to make them easier to use. They provide a friendly user interface.
35 of 43
What is a report?
An output from a database, which can be set up to summarise, group and select data.
36 of 43
What is a graph?
A way some DBMSs use to simply call upon applications programmers to display data rather than having to write their own display routines.
37 of 43
What is a Query?
A tool to extract a subset of data in the database. They can combine data from more than one table and present data in whatever order is required. A query will always include the 'FROM' command to identify the source of the fields.
38 of 43
What is an example of a query?
SELECT "room_number","room_type","view","bath" FROM "tblRoom" WHERE "view" = TRUE AND "bath" = TRUE
39 of 43
How can queries be created?
By a graphical user interface that lets the user assemble the fields and conditions required for a query. They use the mouse to click and drag. This is an easier way for a beginner at databases and queries.
40 of 43
What is an additional, more technical way to create queries?
SQL (Structured Query Language) is used by writing code which checks the conditions before selecting data to display.
41 of 43
What is a module?
A unit of software that takes care of some particular functionality of a database.
42 of 43
What other features do DBMS's have?
Referential integrity: changes must not be made that are logically impossible, validation, security: read and write priveliges can be assigned to different tables for different groups and automatic backup: some DMBSs save transactions=preventdataloss
43 of 43

Other cards in this set

Card 2

Front

Why do businesses need databases?

Back

In order to operate properly. Businesses could not function without them.

Card 3

Front

Databases should be..

Back

Preview of the front of card 3

Card 4

Front

Database administrators go to great lengths in order to protect their data against:

Back

Preview of the front of card 4

Card 5

Front

How could data be lost?

Back

Preview of the front of card 5
View more cards

Comments

WetBlanket

Report

Thanks :^)

Similar Computing resources:

See all Computing resources »See all Databases resources »