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.

(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?

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

Exams With Marking Schemes

• Grade 1
• Grade 2
• Grade 3
• Grade 4
• Grade 5
• Grade 6
• Grade 7
• Grade 8
• Grade 9
• PP1
• PP2
• Playgroup
• Form 1
• Form 2
• Form 3
• Form 4

Related Questions

• 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... (Solved)
  

  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 and B such that no other passenger can book the same seat.
  (I) Name this data processing mode.
  (II) State two advantages of this data processing mode.

  Date posted: November 7, 2019 .    Answers (1)

• List two factors that dictate the cost of a computer system. (Solved)
  

  List two factors that dictate the cost of a computer system.

  Date posted: November 7, 2019 .    Answers (1)

• Give three hardware considerations that should be made before installing an operating system. (Solved)
  

  Give three hardware considerations that should be made before installing an operating system.

  Date posted: November 7, 2019 .    Answers (1)

• Differentiate between a word and a word length as used in data representation. (Solved)
  

  Differentiate between a word and a word length as used in data representation.

  Date posted: November 6, 2019 .    Answers (1)

• Using two's complement, show how the arithmetic below would be carried out on a 8 – bit computer system. (+54) – (+29). (Solved)
  

  Using two's complement, show how the arithmetic below would be carried out on a 8 – bit computer system. (+54) – (+29).

  Date posted: November 6, 2019 .    Answers (1)

• A car rental firm leases its cars for Kshs. 2500.00 per day. The manager gives a discount based on the number of days that the... (Solved)
  

  A car rental firm leases its cars for Kshs. 2500.00 per day. The manager gives a discount based on the number of days that the car is rented. If the rental period is greater than or equals to 7 days then a 25% discount is given. Write a pseudo-code to accept a car number and the rental period, and calculate the total amount earned by the company when a car is leased.

  Date posted: November 6, 2019 .    Answers (1)

• State any two laws governing protection of information. (Solved)
  

  State any two laws governing protection of information.

  Date posted: November 6, 2019 .    Answers (1)

• Distinguish between an integrated software and a software suite. (Solved)
  

  Distinguish between an integrated software and a software suite.

  Date posted: November 6, 2019 .    Answers (1)

• State any two sensory devices used in virtual reality. (Solved)
  

  State any two sensory devices used in virtual reality.

  Date posted: October 29, 2019 .    Answers (1)

• Describe three factors that cause system entropy (Solved)
  

  Describe three factors that cause system entropy

  Date posted: October 11, 2019 .    Answers (1)

• a)Study the Pseudo code below and answer the questions that follows. BEGIN Print “enter the value of A and B”; Read A, B Y =... (Solved)
  

  a)Study the Pseudo code below and answer the questions that follows.
  BEGIN
  Print “enter the value of A and B”;
  Read A, B
  Y = A+B
  While Y<20 Do
  BEGIN
  PRINT Y
  A = B
  B = Y
  Y = B+A
  END WHILE
  PRINT A, B, Y;
  END
  
  i)Assuming the user keys in 2 and 4 when prompted to enter the values for A and B respectively, determine the values of A, B and Y show your working
  ii)State the control structures used in the above pseudocode.
  b)Draw a flowchart that would be used in place of the pseudocode
  c)Give three examples of Iteration construct

  Date posted: October 11, 2019 .    Answers (1)

• Describe two situations in the bus transport industry where computerized systems could replace human employees. (Solved)
  

  Describe two situations in the bus transport industry where computerized systems could replace human employees.

  Date posted: October 11, 2019 .    Answers (1)

• Explain the functions of complementary metal-oxide semiconductor (CMOS) (Solved)
  

  Explain the functions of complementary metal-oxide semiconductor (CMOS)

  Date posted: October 1, 2019 .    Answers (1)

• Briefly explain what happen during power on self test (POST) (Solved)
  

  Briefly explain what happen during power on self test (POST)

  Date posted: October 1, 2019 .    Answers (1)

• State the following types of transcription errors: i. 3455 instead of 3456 ii. Simth instead of Smith (Solved)
  

  State the following types of transcription errors:
  i. 3455 instead of 3456
  ii. Simth instead of Smith

  Date posted: October 1, 2019 .    Answers (1)

• Using one’s complement, calculate 5₁₀ – 9₁₀. Use six bit in your calculation. (Solved)
  

  Using one’s complement, calculate 5₁₀ – 9₁₀. Use six bit in your calculation.

  Date posted: October 1, 2019 .    Answers (1)

• Convert 0.11011₂ to its decimal equivalent (Solved)
  

  Convert 0.11011₂ to its decimal equivalent

  Date posted: October 1, 2019 .    Answers (1)

• Convert binary number 11010110.1001₂ into octal number. (Solved)
  

  Convert binary number 11010110.1001₂ into octal number.

  Date posted: October 1, 2019 .    Answers (1)

• Find the sum of binary number 101.101₂ and 110.100₂ (Solved)
  

  Find the sum of binary number 101.101₂ and 110.100₂

  Date posted: October 1, 2019 .    Answers (1)

• Name two files that are created in mail merging process (Solved)
  

  Name two files that are created in mail merging process

  Date posted: October 1, 2019 .    Answers (1)