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

The information in figure 3 below is maintained by the patron of wildlife club in a school. Study it and answer the questions that follow.

      

The information in figure 3 below is maintained by the patron of wildlife club in a school. Study it and answer the questions that follow.
Q191172019111.png
(a) Describe the field values, records and file.
(b) State the most appropriate primary key for the list.
(c)State the most appropriate data types for the fields:
(i) Admission number
(ii) Membership number.
(d) If a database was to be created for the list; forms, tables, queries and reports are likely to be used.
(i) State the purpose of each of these objects.
(ii) Which objects cannot be used to store the data in the list?
(e) (i) How many field values are in the list?
(ii) How many records are in the list?

  

Answers


Maurice
a) –Field values are characters or logical combination of characters that represent a data item.
For example, in the database above name for example is a field.
-Records are collections of related fields that represent a single entity. For example in the
above database, name, class, admission number, membership number and group all
constitute a record.
-File is a database structure that is used to hold related records and is often organized into
rows and columns, with each row representing a record while each column represents
common fields in each record eg in the above database, the file structure comprise 5
fields and 10 records.

b) Membership Number

c) (i) Admission number: Number.
(ii) Membership number: Memo/ Alphanumeric

d) ( i) –Forms: Are graphical interfaces that resemble an ordinary paper form used to either
enter data into or view data from a database.
-Tables: Are database structures organized into rows and columns and used to hold related
records.
-Queries: Are statements used to extract, change, analyze or request for specific data from
one or more tables.
-Reports: Are summaries generated from underlying tables or queries using a database tool
known as report generator.

(ii) –Forms
-Queries
-Reports

e) (i) 5 fields
(ii) 10 records
maurice.mutuku answered the question on November 7, 2019 at 10:19


Next: An airline uses an information system whereby if a passenger at station A books a plane seat, this transaction is immediately shown at stations A...
Previous: Explain five reasons why affirm may consider hiring a machine rather than buying.

View More Computer Studies Questions and Answers | Return to Questions Index


Learn High School English on YouTube

Related Questions