Data Processing Paper 2, WASSCE (SC), 2022

Question 2

 

A medium scale enterprise intends to create a database to manage its staff records with the following fields: staff ID, Name, Address, Photograph and Department.

  1.  (i) What is a Database?

                                                                                    
(ii)  List three DBMS the firm can use to achieve the stated objectives.

  1.  (i)  Mention two tasks that can be performed on staff photographs using graphic packages.

                                                                                  
(ii)  Give three examples of graphic packages that can be used for the tasks in 2 (b)(i)

Observation

                                                         
The question tested the candidates’ skill in DBMS.
The Chief Examiner reported that a good number of the candidates who attempted this     question struggled with the task.

 

 The expected answer is:

(a) (i)   A database is an organized collection of data or information electronically for easy access and management
OR
Database is a collection of information that is organized so that it can easily be accessed, managed and updated.         
OR
A database is an organized collection of structured information, or data, typically stored electronically in a computer system.
OR
A database refers to a collection of logically related information organized so that it can be easily accessible, managed and updated.                                           
                                                                                                                 
                  (ii) Examples of DBMS


  1. MySQL
  2. Microsoft Access
  3. SQL Wizard
  4. Microsoft SQL Server
  5. Oracle
  6. RDBMS
  7. dBASE
  8. Fox Pro
  9. PostgreSQL
  10. MongoDb
  11. Teradata         
  12. IBM DB2
  13. Informix         

SAP ASE/SYBASE  

  1. amazon’s simple db   
  2. Filemaker        
  3. Adabas
  4. SQLite
  5. Toad   
  6. phpMyAdmin
  7. CouchdB
  8. Redis
  9. IBM DB2
  10. IBM Lotus Approach
  11. Lotus Note
  12. Bigtable

Cloud Spanner

 (b) (i)  Tasks performed using graphic packages


  • Resize
  • Photo manipulation
  • Rotate
  • Mirroring
  • Crop
  • Remove background
  • Edit
  • Apply artistic effects
  • Contrast/Brightness  Adjustment
  • Blurring
  • Filtering
  • Add effects
  • Photo enhancement
  • Transparency
  • Flip
  • Change to 3D
  • Adding watermarks                                      

    (ii) Examples of graphic packages


  • Print Artist
  • Corel Paint/
  • Paint PRO
  • CorelDraw
  • Instant Artist
  • Harvard Graphics
  • Photoshop
  • Logo Graphics
  • Animation software
  • Print
  • Computer Aided Design
  • Canva 
  • Gimp
  • Pixlr                
  • Inkscape         
  • MsPaint          
  • photoscape     
  • Adobe Dreamweaver
  • Adobe illustrator        
  • Adobe photoshop
  • SumoPaint
  • Blender
  • Sketch
  • Mega Creator

  • Logic Graphics
  • Affinity Designer
  • Adobe Indesign
  • VisMe
  • SVG-edit