|
With the aid of a diagram, describe the Hierarchical Database Model.
Data items are arranged in a tree like format.
Factors
(c) (i) Name three types of validation checks during data entry in data processing.
0 Comments
State three reasons why it is important to define datatypes of fields in a database correctly.8/1/2021 State three reasons why it is important to define datatypes of fields in a database correctly.
Reasons for defining datatypes in databases
Figure 1 shows relationships between tables in a database.
Identify two primary and two foreign keys used in the relationship.
Primary keys
A) State three hardware devices that may be required to connect a computer to an existing local area network. (3 marks)
B) A publisher intends to use a desktop publishing programme to create a publication which is to have many graphics. State three ways in which the graphics may be acquired for this purpose. (3 marks)
C) Interpret each of the following spreadsheet formula:(i) = countif(D2:D9, “>“&B4) (2 marks) (ii) sumif(B3 :B 11, “4M”, D3 :D11) (2 marks) (i) = Countif (D2 : D9, “>“ & B4)
(D) The following are the fields of products table in a database created to store records of products manufactured in a factory:
II. State three properties to be put in place during table design to ensure integrity of the data entered. (3 marks) I) Product Number — Number/Autonumber/Text
 A school keeps student records in a database. The data is coded before entry.State three reasons why the coding is necessary.
With the aid of a diagram, describe the Hierarchical Database Model.
(b) List three factors that should be considered when developing a database application and give reasons why each should be considered.
(c) (i) Name three types of validation checks during data entry. (ii) Differentiate between primary key and index key RESPONSES
Data items are arranged in a tree like format.
Access is through a single path and all from one single item called the root component. (b) Factors .
What is an information system?
(a) (i) What is an information system?
(ii) State two roles of an information system. (b) Describe the following file organisation methods: (i) random file organisation; (ii) sequential file organisation. (c)The following records were extracted from two files that contained student data. 
(i) Which of the two files above represents a Transaction file?
(ii) Give a reason for your answer in c(i) above. (iii) Name the other type of file represented above. (d)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) Identify this data processing mode. (ii) State two advantages and two disadvantages of this data processing mode. RESPONSES
(a)(i) Information system is an arrangement of people, data, processes, communication and IT that interact to support problem solving.
(ii) Improve day-to-day operation
(ii) Method of storing or retrieving information that requires the program to start reading at the beginning and continue until it finds the desired data. (c) (i) File B. (ii) Transaction file: It contains data which is regularly added. Has data/fee payment . (iii) Master File: It contains records that do not change regularly like in file A.
(d) (i) Real time processing.
(ii) Advantages
Describe the following types of relationships as used in Database design:One-to-one and One-to-many.(a) One-to-one;
(b) One-to-many.
(a) State four activities of the planning stage of systems development. (4 marks)
Activities at the planning stages
State the purpose of each of the following in database design.(a) input mask
(b) default value
Using two examples, explain the term field properties as used in database design.
(b) Below is an extract from a hospital database table.
(i) State with reasons the most suitable data types for the following fields:
(iii) What is the purpose of a primary key field in database design? (iv) Describe how information about patients who registered after 09/08/06 can be extracted from the database.
(a)Field property:
Distinguish between Real, Integer and Character data types as used in programming ( 3mks)
 Related SearchesName two types of relationships that can be applied in database design (2mks)
State three operations that can be performed on relational database files
 The information 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 type 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?
EXPECTED RESPONSES
(a)The field values are the values assigned to the attributes, that is, actual names, classes.
(c) (i) Text/Number/character. (ii) Text/Character/String/alphanumeric. (i)
(ii) 11 |
Categories
All
Archives
December 2024
|
RSS Feed
