Get premium membership and access questions with answers, video lessons as well as revision papers.

Form 2 Computer Studies Questions and Answers on Databases

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