Get premium membership and access video lessons, revision papers with marking schemes, notes and live classes.

Processing. Please wait.

Form 2 Computer Studies Questions and Answers on Databases

Lessons (39)

1. Differentiate between a foreign key and primary in a relational database.
0m 49s
2. Mention two advantages of entering data into a database using a form.
1m 25s
3. Define the following terms as used in database: a)Record b)File c)Database
2m 11s
4. State one function of each of these objects in a database. a)Table b)Query c)Forms d)Reports
0m 58s
5. List three types of relationships that can be used to link tables in a database.
0m 23s
6. Define the term database management system (DBMS).
0m 53s
7. List three database management system objects.
0m 29s
8. Explain these database models: a)Relational b)Hierarchical
2m 7s
9. Distinguish between relational database and flat file model.
0m 30s
10. Define the term dynaset as used in database
0m 23s
11. List four features of database software
1m 33s
12. Differentiate between database and database management software
1m 19s
13. Explain these database models: a)Network model b)Flat file
0m 51s
14. The figure below shows an example of a database model: Name the type of database model represented by the figure.
0m 33s
15. State one disadvantages of flat file database model
0m 27s
16. Give three functions of a database management system.
1m 24s
17. State three ways in which a primary key field can be used in a database.
0m 32s
18. Define the term normalisation as used in a database.
0m 0s
19. Differentiate between an index and a primary key.
0m 0s
20. Mention three objectives of normalisation.
0m 34s
21. Differentiate between a report and a form.
0m 0s
22. List two types of form layout available in a database form wizard dialog box.
0m 0s
23. List any six general field properties that can be set on a field in a table.
0m 0s
24. Name any two examples of a database package.
0m 0s
25. Differentiate between the term entity and attribute in a database.
0m 0s
26. State two qualities of a primary key field.
0m 0s
27. A form two student wishes to create a field named ADM. No in a table. This field will be used to store admission numbers of students in a class. Outline the steps to follow to achieve this.
0m 0s
28. Define the term control as used in database forms.
0m 0s
29. Explain three categories of database controls.
0m 0s
30. State three disadvantages of traditional file management system over electronic file management system.
0m 0s
31. Name four types of Action Queries.
0m 0s
32. Give the function of each of the following queries. -Make table query -Delete query -Append query -Update query;
0m 0s
33. Differentiate between an action query and a select query.
0m 0s
34. Give three ways of opening Ms-Access program.
0m 0s
35. Differentiate between single and double types of integer field size as used in database.
0m 0s
36. Expand the term OLE objects as used in database.
0m 0s
37. Give the function of Object Linking and Embedding (OLE) object data type.
0m 0s
38. State two ways of enforcing referential integrity in a database.
0m 0s
39. State three views in a Microsoft database window.
0m 33s

Form 2 Computer Studies Questions and Answers on Databases

Related Content