Get premium membership and access questions with answers, video lessons as well as revision papers.
Role of database administrator
? To maintain the database. The database administrator is responsible for making additions
deleting information and ensuring that there is no duplication of data.
? Maintaining the data dictionary. A data dictionary is an index of data held in a database
which can be used in the maintenance and access of the database. It contains a pool of
information concerning a database.
? Helping users to overcome the problems that they may encounter when using the
database.
? Resolving conflicts between users and the technical people.
? Overseeing the database security.
? Evaluating the Database Management System (DBMS) performance so as to determine
whether it meets the organisation‘s needs.
? Enhancing backing up of data and making sure that data recovery is in place.
? Ensuring compliance with the rules and regulations, for example, statutory legislation i.e.
Data Protection Act.
gregorymasila answered the question on November 30, 2017 at 13:39
- For applications such as banking, it may be argued that security is a major concern when implementing database systems. As a database administrator, you are...(Solved)
For applications such as banking, it may be argued that security is a major concern when implementing database systems. As a database administrator, you are expected to explain five security features expected to be included with the design of the database systems.
Date posted: November 30, 2017. Answers (1)
- 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)