a) DDL- Data Definition Language; it is used to define a database including creating,altering,and dropping tables
b)DML- Data Manipulation Language;it is used to maintain and query database.
c)DCL- Data Control Language;It is used to control database.
johnson mwenjera answered the question on December 4, 2017 at 12:50
- State four data types in SQL(Solved)
State four data types in SQL
Date posted: December 4, 2017. Answers (1)
- Explain the contribution that an information resource centre might make towards end-user computing(Solved)
Explain the contribution that an information resource centre might make towards end-user computing
Date posted: December 3, 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: December 3, 2017. Answers (1)
- Client/Server architecture, database technology and networks provide structures which facilitate sharing of corporate data and information. As an information Technology (IT) specialist, outline the major precautions...(Solved)
Client/Server architecture, database technology and networks provide structures which facilitate sharing of corporate data and information.
As an information Technology (IT) specialist, outline the major precautions that should be taken into account in the process of sharing data.
Date posted: December 3, 2017. Answers (1)
- Describe the relevance of the following to a Decision Support System (DSS):(i) Specialised packages: (ii) Query languages; (iii) Database management system(Solved)
Describe the relevance of the following to a Decision Support System (DSS):
(i) Specialised packages:
(ii) Query languages;
(iii) Database management system
Date posted: December 3, 2017. Answers (1)
- List four application packages that you might consider using on a micro-computer for administrative functions in an organisation. Explain how each of these packages can...(Solved)
List four application packages that you might consider using on a micro-computer for administrative functions in an organisation. Explain how each of these packages can increase an organisation's efficiency.
Date posted: December 3, 2017. Answers (1)
- On your homework Web page, you want to present a warning message in red and bold. Write one line of HTML that will make that...(Solved)
On your homework Web page, you want to present a warning message in red and bold. Write one line of HTML that will make that happen. The content of the warning message is up to you.
Date posted: December 1, 2017. Answers (1)
- Give four examples of industries and business organisations that are currently using computer networking(Solved)
Give four examples of industries and business organisations that are currently using computer networking.
Date posted: November 30, 2017. Answers (1)
- What are the implications of increased electronic networking on computer security?(Solved)
What are the implications of increased electronic networking on computer security?
Date posted: November 30, 2017. Answers (1)
- Why is active participation of senior management in design of information systems important?(Solved)
Why is active participation of senior management in design of information systems important?
Date posted: November 30, 2017. Answers (1)
- Using a practical example, explain what is meant by sub-optimization(Solved)
Using a practical example, explain what is meant by sub-optimization.
Date posted: November 30, 2017. Answers (1)
- The trends towards distributed data processing and end user development can have significant effect on the structure and operation of Information Technology in an organisation....(Solved)
The trends towards distributed data processing and end user development can have significant effect on the structure and operation of Information Technology in an organisation. Although the underlying trends and advantages are favourable, managers have to aware of potential problems.
What problems would you envisage arising as a result of widespread end-user computing
and how might such problems be avoided?
Date posted: November 30, 2017. Answers (1)
- Your company has decided to replace it‘s existing accounting system. The company has identified the requirements of the system. The company wishes to make a...(Solved)
Your company has decided to replace it‘s existing accounting system. The company has identified the requirements of the system. The company wishes to make a decision on how to acquire this application-software.
Required:
Identify the three main sources of applications-software and discuss the appropriateness of
each source.
Date posted: November 30, 2017. Answers (1)
- Identify and describe the application of fourth generation languages (4GLs) during information system development(Solved)
Identify and describe the application of fourth generation languages (4GLs) during information system development.
Date posted: November 30, 2017. Answers (1)
- Due to complexity of information systems development, a number of tools and methodologies have been used to resolve this complexity. Some of such tools and...(Solved)
Due to complexity of information systems development, a number of tools and methodologies have been used to resolve this complexity. Some of such tools and methodologies include Computer Aided Software Engineering (CASE) and Prototyping.
Required:
Identify those aspects of information systems development life cycle for which these tools or techniques are available illustrating their application in each case.
Date posted: November 30, 2017. Answers (1)
- What is the role of a database administrator in an organisation.(Solved)
Examine the role of a database administrator in an organisation.
Date posted: November 30, 2017. Answers (1)
- 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)