Get premium membership and access questions with answers, video lessons as well as revision papers.
Specify features to be included with the design of the database system
1. Strict operating procedures
The database through the database management system should have in built procedures
which allows only the authorised persons to access the system or to make modifications
such as updating the data.
2. Back-up procedures
The design of a database system should include backup procedures to ensure that data is
not lost in case of malfunction or accidental loss of data.
3. Protection against remote access
Data contained in the system should be protected against remote access through the use
of passwords and data encryption.
4. Controlled access to the system
Physical security measures should be put in place to limit physical access to the system by
unauthorised users.
5. Database administration
A database system should have an administrator who is responsible for its administration.
He performs such functions as maintaining the database the data dictionary and helping
users overcome the problems that they encounter.
gregorymasila answered the question on November 30, 2017 at 13:36
- What is meant by cost/benefit analysis? Illustrate its relevance to the System Analyst during systems development life cycle(Solved)
What is meant by cost/benefit analysis? Illustrate its relevance to the System Analyst during systems development life cycle
Date posted: November 30, 2017. Answers (1)
- Examine any four desirable features which should be inherent in an operating system(Solved)
Examine any four desirable features which should be inherent in an operating system.
Date posted: November 30, 2017. Answers (1)
- Decisions can either be classified as structured (programmed) or unstructured (non-programmed). Required: (i) Distinguish between programmed and non-programmed decisions. (ii) Identify each of the following with...(Solved)
Decisions can either be classified as structured (programmed) or unstructured (non-programmed).
Required:
i) Distinguish between programmed and non-programmed decisions.
ii) Identify each of the following with the type of decision to which it may apply.
- Computer program;
- Stock ordering;
- Judgement;
- Regulation.
Date posted: November 30, 2017. Answers (1)
- You recently attended a seminar organised by the Institute of Certified Public Accountants of Kenya (ICPAK) on information management into the 21st century. One of...(Solved)
You recently attended a seminar organised by the Institute of Certified Public Accountants
of Kenya (ICPAK) on information management into the 21st century. One of the topics
covered was on Internet and its impact on the society. Your first task is to explain to the
senior management the effect of Internet on the following sectors of society.
i) Education.
ii) Service provision industry.
Date posted: November 30, 2017. Answers (1)
- Identify and describe the main criteria which should be met by a local area network design.(Solved)
Identify and describe the main criteria which should be met by a local area network design.
Date posted: November 30, 2017. Answers (1)
- What reasons would you put forward for adopting a database as a basis for an information system?(Solved)
What reasons would you put forward for adopting a database as a basis for an information system?
Date posted: November 30, 2017. Answers (1)
- It has been cited that Information Technology has caused more harm than good. One of the vices sited is computer related crime. Outline and briefly describe...(Solved)
It has been cited that Information Technology has caused more harm than good. One of
the vices sited is computer related crime. Outline and briefly describe four categories of
computer related crimes.
Date posted: November 30, 2017. Answers (1)
- Everything an expert system can do, a decision support system (DSS) can also do?. Discuss any four grounds that consistently support or disapprove this statement....(Solved)
Everything an expert system can do, a decision support system (DSS) can also do.
Discuss any four grounds that consistently support or disapprove this statement.
Date posted: November 30, 2017. Answers (1)
- Whenever a user buys a software, it is essential that the software comes with a seller maintenance contract. As an outside consultant, you are required...(Solved)
Whenever a user buys a software, it is essential that the software comes with a seller
maintenance contract. As an outside consultant, you are required to explain to the user what
a seller maintenance contract is and the specifications required by the user in a seller
maintenance contract.
Date posted: November 30, 2017. Answers (1)
- Most users interact with their computer systems through a command-driven interface or graphical interface. As a person in charge of Information Technology (IT), your...(Solved)
Most users interact with their computer systems through a command-driven interface or
graphical interface. As a person in charge of Information Technology (IT), your boss is
proposing that you move away from the command driven interface you are currently
using, to a new platform which is object-based and has appealing interface as well as
being more user friendly.
What advise might you offer your boss regarding this proposal
Date posted: November 30, 2017. Answers (1)
- Without proper consideration of the behaviour of people in the business organisation setting even the best technically designed system is likely to fail.Required: (a) Analyse the...(Solved)
Without proper consideration of the behaviour of people in the business organisation setting
even the best technically designed system is likely to fail.
Required:
a) Analyse the most common reasons that may lead to resistance to the introduction of
Management Information Systems and how an organisation can overcome it.
Date posted: November 30, 2017. Answers (1)
- Change is inevitable. Change occurs in many ways and adapting to change is a primary management responsibility. Identify the factors, which bring about change in anorganisation....(Solved)
Change is inevitable. Change occurs in many ways and adapting to change is a primary
management responsibility. Identify the factors, which bring about change in an
organisation.
Date posted: November 30, 2017. Answers (1)
- The widespread use of computers in offices have raised major health and safety issues. Describe three major health related problems that may result from intensive...(Solved)
The widespread use of computers in offices have raised major health and safety issues.
Describe three major health related problems that may result from intensive computer use
and list three products that may be made available to improve the working conditions of
personnel using computers.
Date posted: November 30, 2017. Answers (1)
- Distinguish between online and offline transactions(Solved)
Distinguish between online and offline transactions.
Date posted: November 30, 2017. Answers (1)
- Describe any three basic strategies that an organisation can employ to obtain competitive advantage and illustrate the role of Information Technology in each case(Solved)
Describe any three basic strategies that an organisation can employ to obtain competitive advantage and illustrate the role of Information Technology in each case.
Date posted: November 30, 2017. Answers (1)
- Name six guidelines required for the development of new information systems.(Solved)
Name six guidelines required for the development of new information systems.
Date posted: November 30, 2017. Answers (1)
- Explain the meaning of the following terms, bringing out clearly the distinction between the terms in each pair (i) Unit testing and systems testing(Solved)
Explain the meaning of the following terms, bringing out clearly the distinction between the
terms in each pair.
i) Unit testing and systems testing.
ii) Preventive and perfective maintenance.
iii) Co-processing and parallel processing.
iv) Logical and physical design of a system.
Date posted: November 30, 2017. Answers (1)
- Write short descriptive notes on the following: (a) Electronic Data Interchange (b) Client/server computing (c) System specification (d) Electronic point of sale system...(Solved)
Write short descriptive notes on the following:
a) Electronic Data Interchange
b) Client/server computing
c) System specification
d) Electronic point of sale system
Date posted: November 30, 2017. Answers (1)
- Systems walkthroughs are procedures that are commonly used as a means of quality assurance in the information systems development process.Required: (i) Describe the composition and the...(Solved)
Systems walkthroughs are procedures that are commonly used as a means of quality
assurance in the information systems development process.
Required:
i) Describe the composition and the roles of walk through teams.
ii) Provide a checklist of items to be examined during the walkthrough.
Date posted: November 30, 2017. Answers (1)
- Explain what is meant by a Graphical User Interface (GUI) and account for the increased design and implementation of such interfaces(Solved)
Explain what is meant by a Graphical User Interface (GUI) and account for the increased design and implementation of such interfaces.
Date posted: November 30, 2017. Answers (1)