Brainscape's Knowledge GenomeTM

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


See full index

Computer Science > Chapter 5- DATABASES > Flashcards

Chapter 5- DATABASES Flashcards

1
Q

What is meant by a range check

A

A range check validates data that falls between two extreme values

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

Explain the term verification

A

Verification is a check that data is correct, compared with the source or duplicate file

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

What is a check digit

A

An extra digit added to a data item produced by an algorithm or calculations

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

Surname

A

Length, type

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

Date of birth

A

Length, range

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

Gender

A

Length, type

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

Credit limit

A

Number, range

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

Telephone number

A

Length, type

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

Password

A

Length, type

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

Define the term data redundancy

A

The unnecessary repetition of data

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

Explain how data redundancy affects this table

A

City names are repeated

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

Explain what problems could occur due to data redundancy

A

Alternative spellings might be used so data is not found

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

Explain how the data could be stored to eliminate this problem

A

Store city names and addresses in separate tables

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

Explain what DBMS is

A

Database management software that controls the setting up and interrogation of a database

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

What is a database

A

A store of persistent and organised data

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

What is a flat file database

A

A flat file database consists of only one table

17
Q

What is a relational database

A

Data stored in tables, linked in key fields with each row the same structure and size

18
Q

Describe four features of a typical DBMS

A

Forms
Reports
Queries
Tables

19
Q

Describe the difference between an entity and a table

A

An entity is a real world object, a table is a data structure that holds data about an entity

20
Q

Describe two ways in which a query can be constructed

A

QBE, a visual interface or programmed query language

21
Q

Define the term validation

A

Validation is a check on data as it is input carried out by a software or the computer

Computer Science (10 decks)

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