Databases

Question 1

describe a database

Answer 1

a database is a persistent (saved on secondary storage for the future) organised (to easily select or process) store of related data on a computer system.

Question 2

explain the use of data handling software

Answer 2

database software has to be able to create, retrieve, update and delete the data in a database.

Question 3

describe how a DBMS allows the separation of data from applications and why this is desirable

Answer 3

s

Question 4

describe the principal features of a DBMS and how they can be used to create customised data handling applications.

Answer 4

s

Question 5

understand the relationship between entities and tables

Answer 5

s

Question 6

understand the components of a relational database, such as tables, forms, queries, reports and modules

Answer 6

s

Question 7

understand the use of logical operators in framing database queries

Answer 7

s

Question 8

explain the use of key fields to connect tables and avoid data redundancy

Answer 8

s

Question 9

describe methods of validating data as it is input.

Answer 9

s