1(a)(i)
Data model is the organization of data elements and standard on how the data elements relate to one another.
OR
Data model is the representation of the data structures that are required by the database.
OR
Data model is the representation of a real-world situation about which data is to be collected
OR
Data model is the structure and organization of data in database
OR
Data model is the diagram showing inter-relationships between data elements and how they are stored
(ii)
Types of data model
flat model
hierarchical model
network model
relational model
object-oriented model
entity relationship model
document model
entity-attribute-value model
star schema
object relational model
inverted file model
multi dimensional model
semi structured model
context model
associative model
NoSQL model
(b)(i) Approaches to data modelling
conceptual data model
enterprise data model
logical data model
physical data model
(ii) Conceptual data model
identifies objects, concepts, entities and relationships between them
represents the first/initial stage/base in the development of the design of data and data storage.
is the most abstract form/ highest level/ summary level of data modeling.
Enterprise data model
creates a graphical model/view of all data used in an organization/ company/ enterprise.
Logical data model
describes the data in detail as much as possible without regard to how they will be physically implemented in the database .
Physical data model
is a representation of data/ tables (Table Names, Primary key, Foreign keys, Column/Field Name & Data types) in a DBMS.
2.(a)(i) A word processing package / Word processor
Ami Pro
Applix Word
Atlantis Word Processor
Corel Word Perfect
emacs
Google Docs
IA Writer
Kword
Kingsoft writer
Libre Office
Locoscript
Lotus WordPro
Microsoft Write
Ms Edit
MS Word
Nisus Writer
Open Office Word
Polaris Office
Quick Office
Quick word
Star Office writer
TechWriter
TextMaker
Word Craft
Word Perfect
Wordperfect
Wordstar
Zoho Office
Zoho Writer
(ii) Water Mark
(iii) Measures to ensure confidentiality of files
use of password
use of encryption
access control
authentication
(b)(i) An icon is an image/ a graphical or pictorial representation of a command, program, file or folder on a computer screen for easy access.
(ii) A browser is a software/web client/ program/ application used for accessing / retrieving, presenting and traversing information resources on the World Wide Web/ internet/ web servers
3.(a) Steps involved in printing first five pages of a document
choose the printer from the list of printers displayed;
choose the page range (1-5 OR 1,2,3,4,5);
click on print/ok
(b)(i) Possible cause of the pop-up
Virus/Malware
unlicensed software
plugins
Pirated/Faked Software
Need for Software update
(ii) Sources of malware/virus
infected files/media
installed plugins
downloading
cracked/pirated software
email attachment
-use of CD/DVD or portable devices
visiting unreliable websites
outdated/expired software
(iii) Measures to prevent the pop-up
Use of antivirus/ anti-malware
popup blocker
use of licensed software
disable plugins
regular software update
(c)(i) Presentation Packages
Corel Presentation
Calligra
Magic point
OpenLP
Slide Dogs
Havard Graphics
PowerPoint
Prezi
Camtasia
Google Docs
(ii) Multimedia projector/ projector
(d) Types of computer network
Local Area network (LAN/WLAN)
Metropolitan Area Network (MAN)
Personal Area Network (PAN)
Wide Area Network (WAN)
4.(a) Steps involved in creating the query
In MS Access,
click on Create;
select Query Design;
add table tblCustomer to QBE interface;
select the field lastName from the grid;
select the field firstName from the grid;
select the field Town from the grid;
type ‘John’in the Criteria row under lastName field;
tick all the check boxes .in the Show row, under lastName, firstName and Town fields.
(b) Steps to generate the SQL statement for the action in 4(a)
Right click on Query (QBE) Interface;
select SQL view.
OR
From Design view, click view;
select SQL view.
OR
Click on SQL at the bottom right corner
5.(a)(i) Application type 1
I-
Word processor
Ami Pro
Applix Word
Atlantis Word Processor
Corel Word Perfect
emacs
Google Docs
IA Writer
Kword
Kingsoft writer
Libre Office
Locoscript
Lotus WordPro
Microsoft write
Ms Edit
MS Word
Nisus Writer
Open Office Word
Polaris Office
Quick Office
Quick word
Star Office writer
TechWriter
TextMaker
Word Craft
Word Perfect
Wordperfect
Wordstar
Zoho Office
Zoho Writer
Application type 2
Web browser
opera mini
safari
UC browser
Msedge
Mozilla Firefox
Internet explorer
Google Chrome
Netscape
Application type 3
email clients
Outlook Express/MS Outlook
Gmail
Yahoomail
Hotmail
(ii) Hardware required to carry out the task
Computer system
Printer
Router
Modem
Telephone line
Dongle
VSAT
Smartphones
Power supply
(ii) Conditions to submit electronic copy of report
active email account/ address for recipient/sender
Internet connection/ access
(iii) Possible reasons for the observation
No Internet connection
poor/slow Internet connectivity/ network
file size is heavy to be attached
virus effect
processor speed
(iv) printer
(b)(i) web browser/ browser
(ii) Examples of the application
Google Chrome
FireFox
Safari
Opera
opera mini
UC browser
Ms edge
Mozilla Firefox
Internet explorer
Netscape
Vivaldi
Maxthon
Chromium
Slim browser
Slim Browser
Sea Monkey
Konqueror
Avant Browser
Flock
Torch
Lynx
Tamino
Pale Moon
OmniWeb
Lunascape
Waterfox
icab
Yandex Browser
Swiftfox
(iii) Steps to follow in creating an email address
On the Address bar of the web browser, type the URL of the email provider domain (eg. yahoo/ yahoo mail/ gmail).
click on “Sign Up”/ create account on the email home page
create user account/ username and password [ Complete the form displayed]
enter the information for password recovery
follow the instructions asking you to prove that you are a human/ review terms of reference and click next
click on “Create my account”/ continue to Gmail
6.(a)(i) Drop Cap
(ii) I. Steps to achieve Drop Cap
Select the letter and click on “Insert”
click on “Drop Cap”
click on “dropped”
OR
Select the letter, and click on format menu
click on “Drop Cap”
click on “dropped”
II. Steps to make two columns
highlight the text and click on “Page Layout”;
click on “more columns”;
click on “Two Columns” and line between;
click OK or press enter.
OR
highlight the text and click Format menu;
click “Columns”;
click on “Two Columns” and line between;
click OK or press enter.
(b) Objects that can be placed in a document using ‘Insert menu’
Add Ins
Blank page
chart
clip art
Comments
Cover page
Date & Time
equation
footer
header
Header & Footer
Link
Page break
page number
pictures
shapes
smart art
sound
symbol
-tables
Text
Text box
video
Word Art
(c) (i) Steps to insert a circular shape
click on the ellipse tool/ Press F7
click and drag on the page to the desired size pressing down the left Mouse button
(ii) Steps to add caption
click on Text tool/ Press F8
click on the page
type “Happy Birthday”
(iii) Steps to change colour
Select/click on the typed caption
select/click on “Red” on the colour palate
OR
select the caption
click on the fill tool box/ interactive fill tool
select red on the dialogue box, then click Ok/ Select red from the colour palate
(iv) Steps to fit caption around circular object
select the “Circular Shape” and the caption using the pick tool
click on text menu and select “Fit to Path”
OR
Select the caption using the pick tool, and click on text menu,
click on “Fit to Path” and lick on the circular shape
No comments:
Post a Comment