As a database administrator for a company, create a table named tbl-Employee in a database application package containing the fields: "Employee Name", "Depa...

Assessment: WAEC SSCE - Computer Studies - 2019 (Practical) Subject: Computer Studies

Question 1 Report

As a database administrator for a company, create a table named tbl-Employee in a database application package containing the fields:

"Employee Name", "Department", "Assumption Date", Address and "Designation".

(a) Enter the data as shown in the table tbl-Employee

tbl-Employee

Employee Name Department Assumption Date Address Designation
Kate Willikie General Office 03/08/18 3 Lagos Crescent Secretary
James Elliot Security 27/11/10 2 Cocoa House Villa. CSO
Paul Akinson Admin 03/11/12 12 Millo Avenue HRM
Abdul Kaduna Registry 05/06/16 2 Park Lane Rd Clerk
David Madu Management 22/03/94 34 Lakeside MD

(b)Sort the data using the Assumption date from oldest to newest.

(c) Create a report in tabular, landscape using the tbl-Employee table.

(d) Insert your full name and index number as a label on the report.

(e)Save the report as rpt-Employee.

(f) Print your work and submit to the supervisor.

Answer Details

To create a table named "tbl-Employee" in a database application package, you would need to use a database management system and write a SQL (Structured Query Language) script to create the table and specify the fields. The fields you need to include are: "Employee Name", "Department", "Assumption Date", "Address", and "Designation".


Here's an example of the SQL script to create the table:


CREATE TABLE tbl-Employee (
  EmployeeName varchar(50),
  Department varchar(50),
  AssumptionDate date,
  Address varchar(100),
  Designation varchar(50)
);

Next, you can insert the data into the table using the following SQL script:


INSERT INTO tbl-Employee (EmployeeName, Department, AssumptionDate, Address, Designation)
VALUES
  ('Kate Willikie', 'General Office', '03/08/18', '3 Lagos Crescent', 'Secretary'),
  ('James Elliot', 'Security', '27/11/10', '2 Cocoa House Villa.', 'CSO'),
  ('Paul Akinson', 'Admin', '03/11/12', '12 Millo Avenue', 'HRM'),
  ('Abdul Kaduna', 'Registry', '05/06/16', '2 Park Lane Rd', 'Clerk'),
  ('David Madu', 'Management', '22/03/94', '34 Lakeside', 'MD');

To sort the data by the "Assumption Date" field from oldest to newest, you can use the following SQL script:


SELECT * FROM tbl-Employee
ORDER BY AssumptionDate ASC;

For the report, you can use a reporting tool or generate a SQL script to format the data into a tabular, landscape report. You can add your full name and index number as a label on the report by including it as a header or footer in the report.


Finally, you can save the report as "rpt-Employee" and print it for submission to your supervisor.

Download The App On Google Playstore

Everything you need to excel in your exams

Green Bridge CBT Mobile App
Personalized AI Learning Chat Assistant
200,000+ Exam Questions Across IGCSE, JAMB, WAEC & NECO
Over 3,900 Lesson Notes
Offline Support - Learn Anytime, Anywhere
Green Bridge Timetable
Literature Summaries & Potential Questions
Track Your Performance & Progress
In-depth Explanations for Comprehensive Learning