Theory question 102
Database ManagementPaper 2, Section A: Short-structured questions
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. (a)(i) What is a database? (ii) List three DBMS the firm can use to achieve the stated objectives. (b)(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).
Show the model answer
(a)(i) A database is an organised collection of related data stored so that it can be easily accessed, managed and updated.
(ii) Any three: Microsoft Access; MySQL; Oracle; Microsoft SQL Server; PostgreSQL; dBase.
(b)(i) Any two: cropping; resizing; adjusting brightness/colour; removing red-eye; retouching; changing the background; adding text.
(ii) Any three: Adobe Photoshop; CorelDraw; MS Paint; GIMP; Paint Shop Pro; PC Paintbrush.
Name real DBMS products.