Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

AQA Computer Science GCSE > Databases > Flashcards

Databases Flashcards

You may prefer our related Brainscape-certified flashcards:
GCSE Geography - AQA flashcards GCSE Religious Studies - Edexcel Route B flashcards GCSE Religious Studies - Eduqas Route A flashcards GCSE Religious Studies - Edexcel Route A flashcards GCSE Religious Studies - Eduqas Route B flashcards Biology 101 flashcards
1
Q

Give two types of VERIFICATION

A
  1. Visual check- checked by a human to see if it is correct

2. Double entry- when the data is entered twice and neither are accepted if they are different

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Explain why it is desirable to separate the data in a database from the applications used to manage the database

A

If the data is separate from the application using it than the database can be used by more than the one application ie. The data can be shares. This avoids the need to duplicate data for each application

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What does DBMS stand for?

A

DataBase Management System

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What is the difference between a simple and a complex query?

A

Simple- looks for data in only one field

Complex- looks for data in multiple fields

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

How does DBMS create data?

A

It allows data to be inserted into the relevant table. It can also check that the data is valid and complies with any rules set up.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Give some advantages of computerised databases over paper-based databases

A
  1. Data can be accessed by more than one person
  2. Can easily sort the data in different ways
  3. Easy to update the data
  4. Can restrict access to the data so that different users can see different data
  5. Easy to search for specific information
  6. Updates are immediate and shared with all users
  7. Easy to present data in different forms eg. Graphs
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What is a persistent store of data?

A

The data is stored even when the application or device is no longer running

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What does related mean, in terms of databases?

A

The data in one table is linked with the data in another table eg, an order (one table) is linked with a customer (another table)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q 
Explain the following terms
A) field
B) primary key
C) record
D) table
E) File
A

A) a single set of data (a column)
B) a unique value used to identify each record in a table and link it to a different table
C) a set of data about a person/ thing (a row)
D) stores all the records for a thing
E) the actual file that holds the database/ a table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

How does DBMS interrogate a table?

A

It allows data to be queried (using SQL)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Explain how a DDL and a DML are used to manage database files

A

DDL- Data Definition Language, used to create tables and rules

DML- Data Manipulation Language, used to insert/update/delete/query the data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Explain the difference between VALIDATION and VERIFICATION

A

VALIDATION - chicks that the data is:
~ sensible/ reasonable
~ within acceptable boundaries
~ complete

VERIFICATION is confirmation that the data itself is correct, eg double entry/ visual check

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Give 4 types of VALIDTION checks

A
  1. Range - that the number isn’t too big/ too small
  2. Length- that the text entered isn’t too long/ short
  3. Presence- that data has been entered in the correct fields
  4. Format- that the data is in the right data type eg, there are no letters in the age box
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Give 2 examples of VERIFICATION that might be used in computer systems

A
  1. When entering and email address

2. When changing/ creating a password

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

How can DBMS be used to create applications?

A

The DBMS allows things like:
Tables- to hold the data
Relationships- to link the tables
Access rights- to control people’s access to the data
Queries- to allow the database to be searched
Forms- to allow user friendly input of data
Reports- to present the data in a useful and meaningful way

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Explain the difference between DBMS and a database

A

The DBMS manages the data whilst the database is the data.

17
Q

How does DBMS maintain data?

A

It allows data to be changed/ deleted. It can also check that the data entered complies with any rules set up (VALIDATION)

18
Q

What three things should data handling software be able to do?

A
  1. Create data
  2. Maintain data
  3. Interrogate data
19
Q

Use SQL to add the following data into the product database:
| Product code | name | cost | supplier code | quantity |
| 101AA | sandy| 21 | 63 | 40 |

A

INSERT INTO product

VALUES ( ‘101AA’, ‘sandy’, 21, 63, 40)

20
Q

Select the name and cost of a shoe that costs less than £50 and has a supplier code of 63 from the database product.

A

SELECT product.Name, product.Cost
FROM product
WHERE product.cost

21
Q

Change the supplier code to 62 for the product of code 367HT in the products table.

A

UPDATE product
SET product.suppliercode = 62
WHERE product.productcode = 367HT

AQA Computer Science GCSE (4 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions