Get premium membership and access questions with answers, video lessons as well as revision papers.
-Data Definition Language (DDL): Used by the DBA and database designers to specify the
conceptual schema of a database. In many DBMSs, the DDL is also used to define internal
and external schemas (views). In some DBMSs, separate storage definition language (SDL) and view definition language (VDL) are used to define internal and external schemas.
-Data Manipulation Language (DML): Used to specify database retrievals and updates.DML commands (data sublanguage) can be embedded in a general-purpose programming language (host language), such as COBOL, C or an Assembly Language.Alternatively, stand-alone DML commands can be applied directly (query language).
-High Level or Non-procedural Languages: e.g., SQL, are set-oriented and specify what data to retrieve than how to retrieve. Also called declarative languages.
-Low Level or Procedural Languages: record-at-a-time; they specify how to retrieve data and include constructs such as looping.
jim items answered the question on March 12, 2019 at 08:42
- Explain two types of computer data independence.(Solved)
Explain two types of computer data independence.
Date posted: March 12, 2019. Answers (1)
- Discuss the types of database states and database schema as studied in computer applications.(Solved)
Discuss the types of database states and database schema as studied in computer applications.
Date posted: March 11, 2019. Answers (1)
- Discuss the advantages and disadvantages of computer Network data models.(Solved)
Discuss the advantages and disadvantages of computer Network data models.
Date posted: March 11, 2019. Answers (1)
- Discuss advantages and disadvantages of Hierarchical computer data models.(Solved)
Discuss advantages and disadvantages of Hierarchical computer data models.
Date posted: March 11, 2019. Answers (1)
- Discuss conditions under which one should not use a Database management system (DBMS).(Solved)
Discuss conditions under which one should not use a Database management system (DBMS).
Date posted: March 11, 2019. Answers (1)
- Define the following terms as used in computer applications:
a)Database.
b)Data.
c)Mini-world.
d)DBMS.
e)Database system.(Solved)
Define the following terms as used in computer applications:
a)Database.
b)Data.
c)Mini-world.
d)DBMS.
e)Database system.
Date posted: March 9, 2019. Answers (1)
- Write a C program that prompts a user to enter radius of a circle and calculate the Area(Solved)
Write a C program that prompts a user to enter radius of a circle and calculate the Area.
Date posted: March 6, 2019. Answers (1)
- Explain the following input/output terms as used in computer systems. Give an example. (i) Read (ii) Write(Solved)
Explain the following input/output terms as used in computer systems. Give an example
(i) Read
(ii) Write
Date posted: February 23, 2019. Answers (1)
- Explain three functions of an information system in an organisation(Solved)
Explain three functions of an information system in an organisation.
Date posted: January 20, 2019. Answers (1)
- Explain ways in which computers can be used in the transport industry. (Solved)
Explain ways in which computers can be used in the transport industry.
Date posted: January 20, 2019. Answers (1)
- A school has been advised to employ a database administrator. State responsibilities of this personnel in the school.(Solved)
A school has been advised to employ a database administrator. State responsibilities of this personnel in the school.
Date posted: January 20, 2019. Answers (1)
- A computer laboratory experiences power supply problems. Describe three power related problems that should be addressed(Solved)
A computer laboratory experiences power supply problems. Describe three power related problems that should be addressed.
Date posted: January 20, 2019. Answers (1)
- Arnold a programmer intends to create a user input interface screen for a system. State factors that he should consider. (Solved)
Arnold a programmer intends to create a user input interface screen for a system. State factors that he should consider.
Date posted: January 20, 2019. Answers (1)
- Describe three arithmetic errors that may occur during computerized data processing(Solved)
Describe three arithmetic errors that may occur during computerized data processing.
Date posted: January 20, 2019. Answers (1)
- Identify tasks that can be achieved using a Desktop Publishing programme from the following list of tasks.(Solved)
Identify tasks that can be achieved using a Desktop Publishing programme from the following list of tasks.
Date posted: January 20, 2019. Answers (1)
- State ways through which a computer user can minimise Repetitive Strain Injuries (RSI)associated with the use of a computer. (Solved)
State ways through which a computer user can minimise Repetitive Strain Injuries (RSI)associated with the use of a computer.
Date posted: January 20, 2019. Answers (1)
- State ways in which one can create a password which cannot be easily accessed by hackers.(Solved)
State ways in which one can create a password which cannot be easily accessed by hackers.
Date posted: January 20, 2019. Answers (1)
- A school intends to install wireless media in their communication system. State three advantages of this model(Solved)
A school intends to install wireless media in their communication system. State three advantages of this model
Date posted: January 20, 2019. Answers (1)
- Explain problems associated with the computer hard disk(Solved)
Explain problems associated with the computer hard disk.
Date posted: January 20, 2019. Answers (1)
- Explain the term proofreading as used in word processing. (2 marks)(Solved)
Explain the term proofreading as used in word processing. (2 marks)
Date posted: January 20, 2019. Answers (1)