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.
- (i) What is a Database?
(ii) List three DBMS the firm can use to achieve the stated objectives.
- (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
- MySQL
- Microsoft Access
- SQL Wizard
- Microsoft SQL Server
- Oracle
- RDBMS
- dBASE
- Fox Pro
- PostgreSQL
- MongoDb
- Teradata
- IBM DB2
- Informix
SAP ASE/SYBASE
- amazon’s simple db
- Filemaker
- Adabas
- SQLite
- Toad
- phpMyAdmin
- CouchdB
- Redis
- IBM DB2
- IBM Lotus Approach
- Lotus Note
- 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
- 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