Questions from Grover – p.150

1. What are the main components of a database?

 

The main components of a database are records, fields, tables, primary keys, queries, forms and wizards

2. What is the difference between a record and a field?

A record is a set of data and a field is the information in one column of a list or database.

3. What are primary keys? What are they used for?

The primary key of a relational table uniquely identifies each record in the table and is used to uniquely identify each row in a table

4. Draw up a table which could be used for data about students who borrow books from a library. Identify and label a record, a field and the primary key.

5. Why would we not put the students’ data in the same file as the books?

They wouldn’t because the information would get mixed up?

6. If data is repeated unnecessarily in a table, it is called redundant. Why do you think that databases should be designed to minimise data redundancy?

duplicate field remover