Database as information systems questions | form three Information and Computer Studies

In database , tables have records which are columns and fields which are rows.

Answer / Solution

FALSE:

A database has fields (Columns) and records (Rows).

Database keeps all the information in a file about one person, thing and event.

Answer / Solution

FALSE

A databse keeps data and not information.

Give four disadvantages of traditional databases.

Answer / Solution

UNSOLVED

1. Create a Database called STAFF SALARIES
2. Create a Database within the database called HIGH GRADE SALARIES with the following details

100. Insert column AGES after Gender

500. Delete all records related to Wenge

5. Sort in Ascending Order of Surname
6. Create a report of Staff Salaries and Name the Report as “Staff Report”
7. Insert the Current date as the header of the report created in (f) above
8. Create a Form which includes the current time and date

Answer / Solution

UNSOLVED

The following table gives information on some staff members of a computer school called “ACAPROSO ACADEMY”. Use the information given to perform the given tasks (a)-(h).

1. Design a suitable database to manage the information presented in the table , name it as “EMPLOYEE DATABASE”.
2. Create a table using design view and enter the records above. Name it “EMPLOYEE TABLE”.
3. Create a query displaying all the fields in the table above to filter out only employees from the information department. Save it as “INFORMATION DEPARTMENT”.
4. Create a query that wolud retrieve records of people who were born between 1/1/1940 and 3/7/1960, save a query as “BBC”.
5. The academy`s retirement age is 55 years. Create a query to filter out the employees whose ages are above 55 years. Name it “RETIREMENT AGE”.
6. Create a form of the employee who are in retirement age. Save it as “RETIREMENT FORM”.
7. Use the employee table to group the records by department , and create a report which include the current date and time in the header. Save it as “REPORT BY DEPARTMENT”.
8. Print your Document.

Answer / Solution

UNSOLVED