Databases

Question 1

Data

Answer 1

Raw facts and figures

Question 2

Ways of using databases

Answer 2

1) Search engines 2) Telephone directories 3) Online shop database 4) Information about student 5) Record of each book in library

Question 3

Give advantages of databases? (7)

Answer 3

1) Can be sorted 2) Search 3) Filtered 4) Sharing 5) Validation 6) Backup 7) Saves space

Question 4

Table

Answer 4

A structure in which data is stored in a database

Question 5

Flat file database

Answer 5

A database whose records are stored in a single table

Question 6

Record

Answer 6

A collection of data about single item

Question 7

Field

Answer 7

One piece of data about an item

Question 8

Data type

Answer 8

The format of data in a field

Question 9

List data types (5)

Answer 9

1) Text 2) Integer 3) Real (number) 4) Date/time 5) Boolean

Question 10

What is a Boolean

Answer 10

Data which has only two possible values

Question 11

Give an example of a Boolean

Answer 11

Yes/No or True/False

Question 12

Primary key

Answer 12

A unique identifier for each record in a database

Question 13

Index

Answer 13

A list of values or items

Question 14

Relational database

Answer 14

A database that has several tables linked by primary key fields

Question 15

Foreign key

Answer 15

A primary key that appears in another table in a relational database

Question 16

Where can a relational database be used?

Answer 16

In a veterinary clinic

Question 17

I have a pet ID, Owner ID, Appointment ID, what are going to be linked?

Answer 17

Pet and Owner + Appointment and Pet

Question 18

Give an advantage of a relational database

Answer 18

Data has to be entered only once

Question 19

Develop the advantage of relation database that data has to be entered only once

Answer 19

Data doesn’t have to be reentered if the owner has several pets –> entering the data once reduces the chance of an error –> Error has to be corrected only once

Question 20

Query

Answer 20

A method of searching a database

Question 21

SQL

Answer 21

A specialized programming language for maintaining databases and generating queries

Question 22

Query-by-example

Answer 22

A method of searching a database by stating the criteria to be searched

Question 23

What does SQL stand for?

Answer 23

Structured Query Language

Question 24

What is data validation

Answer 24

Making sure the user entered the right data

Question 25

What doesn’t data validation insure?

Answer 25

That data is correct

Question 26

How does the computer know that the data is valid?

Answer 26

It checks whether it matches the rules