Define the following terms:
-Database
-Database management system
-Relational database
-Hierarchical database
-Network database(Answered) Describe functions of the following tools found in DBMS
-Data definition language
-Data manipulation language(Answered) State 5 functions of Database Management System(Answered) Give four widely used DBMS today(Answered) State two classes of database software(Answered) State the components of database hierarchy.(Answered) Write short note on;
-Database
-Database maintenance
-Databank(Answered) Explain importance of using DBMS in storage of data in an organization(Answered) Name and explain 3 database models(Answered) State three views in a Microsoft database window.(Answered) List two properties of a primary key.(Answered) State two ways of enforcing referential integrity in a database.(Answered) Give the function of Object Linking and Embedding (OLE) object data type.(Answered) Expand the term OLE objects as used in database.(Answered) Differentiate between single and double types of integer field size as used in database.(Answered) Give three ways of opening Ms-Access program.(Answered) Differentiate between an action query and a select query.(Answered) Give the function of each of the following queries.
-Make table query
-Delete query
-Append query
-Update query;(Answered) Name four types of Action Queries.(Answered) State three disadvantages of traditional file management system over electronic file management system.(Answered) Explain three categories of database controls.(Answered) Define the term control as used in database forms.(Answered) A form two student wishes to create a field named ADM. No in a table. This field will be used to store admission numbers of students in a class. Outline the steps to follow to achieve this.(Answered) State two qualities of a primary key field.(Answered) Differentiate between the term entity and attribute in a database.(Answered) Name any two examples of a database package.(Answered) List any six general field properties that can be set on a field in a table.(Answered) List two types of form layout available in a database form wizard dialog box.(Answered) Differentiate between a report and a form.(Answered) Mention three objectives of normalisation.(Answered) Differentiate between an index and a primary key.(Answered) Define the term normalisation as used in a database.(Answered) State three ways in which a primary key field can be used in a database.(Answered) Give three functions of a database management system.(Answered) State one disadvantages of flat file database model.(Answered) Explain these database models:
a)Network model
b)Flat file(Answered) Differentiate between database and database management software.(Answered) List four features of database software.(Answered) Define the term dynaset as used in database.(Answered) Distinguish between relational database and flat file model.(Answered) Explain these database models:
a)Relational
b)Hierarchical(Answered) List three database management system objects.(Answered) Define the term database management system (DBMS).(Answered) List three types of relationships that can be used to link tables in a database.(Answered) State one function of each of these objects in a database.
a)Table
b)Query
c)Forms
d)Reports(Answered) Define the following terms as used in database:
a)Record
b)File
c)Database(Answered) Mention two advantages of entering data into a database using a form.(Answered) Differentiate between a foreign key and primary in a relational database.(Answered) For each of the following. State the type of cell referencing that has been used in: (i)A6 (ii) $F$7(Answered) List any two data management tools in spreadsheets.(Answered) Give the function of the following types of charts: bar graph, line graph, pie chart and scatter chart.(Answered) Define the term cell as used in spreadsheet.(Answered) Name any two types of charts in a spreadsheet.(Answered) Explain how spreadsheets can be used in these areas:
i)statistical analysis
ii)Accounting
iii)Data management
iv) Forecasting(Answered) Describe the following components of spreadsheet:
i)Worksheet
ii)Database
iii)Graphs(Answered) Explain three types of cell referencing techniques.(Answered) Define the term cell reference.(Answered) Describe four cell data types as used in spreadsheets.(Answered) Mention two types of cell referencing.(Answered) Differentiate between sorting and filtering of data as applied in spreadsheets.(Answered) Consider the data in the cells below entered in a worksheet.
a)Name the data types in the cells i)D13 ii)E20 iii)E21
b)Give the values in cells
i)E20 ii)E22.(Answered) List three sections of a functions(Answered) Differentiate between a label and a value used in spreadsheets.(Answered) Define the term data filtering as used in spreadsheets.(Answered) Differentiate between sum and sumIf functions.(Answered) Define the following terms as used in spreadsheet graphs.
a)Legend
b)Data series(Answered) Give three components of a worksheet.(Answered) Give two different ways in which a sheet name in a workbook can be renamed.(Answered) List four data types available in spreadsheets.(Answered) Give examples of spreadsheet packages.(Answered) Explain the term “what if analysis” as used in spreadsheet.(Answered) Differentiate between a formula and a function.(Answered) Describe the following terms as used in electronic spreadsheet:
a)Automatic recalculations
b)Data range(Answered) List two logical functions in a spreadsheet.(Answered) Differentiate between workbook and a worksheet.(Answered) Outline the steps for setting the automatic save of a workbook.(Answered) a project manager is currently working on a workbook named “Nairobi City”. She would like to save it with the new name “Beautiful City”. Outline the steps to follow.(Answered) A student obtained the following marks in an examination: 70, 80, 60, 33, and 76. If the values are written at cells C5 to C9, write a formula that will be used to sum all marks greater than 50.(Answered) Give the default function of these control keys as used in spreadsheets:
i)Left arrow ii)Tab
iii)Enter
iv)Shift +tab v)Home(Answered) Define the term active cell.(Answered) State four application areas of spreadsheet.(Answered) List two components of a spreadsheet.(Answered) Give four advantages of the electronic spreadsheet over the manual spreadsheet.(Answered) Describe two types of spreadsheets.(Answered) Define the term spreadsheets.(Answered) Mention two ways of opening a word document.(Answered) Give a benefit of print previewing a document.(Answered) Define the term clipboard as used in one processing.(Answered) Mention three disadvantages of using word processor.(Answered) Distinguish between printing multiple copies and multiple pages.(Answered) Define the term tool bar.(Answered) Define the term symbols as used in word processing.(Answered) State four advantages of using word processor package over a typewriter.(Answered) Distinguish between formatting and editing.(Answered) Define the term pasting as used in a word processor(Answered) Differentiate between superscript and subscript.(Answered) Distinguish between template and wizard(Answered) Give two functions of the thesaurus.(Answered) Define the term saving.(Answered) Outline the steps followed to convert a table into text.(Answered)