Answer all Questions

1. (a) Explain the meaning of the following database terms

• Forms
• Query

(b) Differentiate between;

(i) A field and a record in a database

(ii) Give an example of each

• Field
• Record

2. (a) What is a database?

(b) Distinguish between Microsoft Access and Databases.

• List four examples of data which can be used to create a database.

(d) Mention three examples of Database management software.

(e) Give four advantages of electronic databases over manual databases.

3. (a) Define the following terms in relation to database.

(i) File

(ii) Record

(iii) Field

(b) Name three functions of databases:

(c)Outline four steps taken to create a simple database.

(c) A teacher keeps a class list containing the following data for each

Student: Name, Student index number, Test scores.

(i) State the data type for each of these fields:

Field name Data type

(ii) Primary key field for the record is;

4. State any two factors to consider when designing a database.
5. a) What is a field in relation to databases?

(b) A property owner uses a database to store data about houses he sells. The table shows part of the database.

• The records shown are to be sorted in ascending order of price. What will be the reference number of the first record in the database after it has been sorted?

(ii) Give the names of the fields that contain Boolean data type.

5. Identify the field type of the reference number field.

(iv) Give two validation checks that could be carried out on the reference number field.

(v)  Which field should be the primary key of the database table?

6. A senior four class in Naluwere S.S has formed a club. A file named CLUB MATES is to be kept by the secretary of the club. The design of CLUB MATES has the following fields. NAME, MEMBERSHIP-NUMBER, SEX, AGE and TELEPHONE.

• Suggest a primary key for the CLUB MATES. Explain why it is chosen as the primary key.
• If the longest name in a class is Sangalyambogo, suggest the minimun field length.
• Why is it not a good idea to use the AGE? Suggest an appropriate field name and type.

Field name and type:

• Suggest appropriate data types for the following fields.
• Membership
• SEX
• Telephone

7. (a) (i) What a wild card is in database management system

(ii) Importance of a wildcard in a query criterion

(iii)   Naming examples of frequently used wildcards

8. (a) (i) Give two advantages of using a primary key in a database.

(ii) State two examples of data types recognized by a database.

(b) Use the following table structure to answer the following questions.

A query is organized from the above table structure.

Write down the;

• Criteria for students whose first Name ends with letter Z.
• Criteria for students whose other name begins with letters A.
• Formula for total mark provided that a new column is added After English

• Input mask for students ID to contain KKK and incremented by one.

(c)     Distinguish between validation rule and validation text.

9. (a)         A hospital would like to use a relational database to keep track of its patients. Give four different tables that may be included in this database.

• List down three advantages that will result from using the database.

(c) Mention three challenges of using electronic database to keep track of patients’ records in a hospital.

10. (a) Give any two examples of database management software you know.

• Distinguish between a field and a record as used in databases.
• State the use of the following data types as used in database management software.

11. (a) What is a flat file database?

(b)    Mention any two advantages of using electronic database system

(c)     State two characteristics of a good database design

12. (c). Explain the following field properties as used in database design.

(i).Caption

(ii).Input mask

(d). Give one requirement of a good primary key field in a database table.