This comprehensive exam guide from Armstrong Computers College provides detailed solutions to the May/June 2024 Level Three Database Management questions. Designed specifically for advanced database students, this resource covers both theoretical concepts and practical MS Access applications.
Our interactive format allows you to click on each question to reveal professional explanations and model answers. Whether you're preparing for final exams or enhancing your database skills, this guide offers valuable insights into advanced database management techniques.
Note: The downloadable PDF contains only the questions – the complete answers are available exclusively on this interactive platform.
Get the complete question paper for offline practice
THEORY QUESTIONS
b. Why is normalization needed in Database?
a. Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.
b. It ensures data is stored logically, reduces duplication, and simplifies data updates and queries.
b. Why are captions important?
a. A caption is a label that appears as a column heading in datasheets and forms.
b. Captions make field names more readable and user-friendly for end users.
It improves performance, reduces file size, and fixes minor database corruption issues.
- Short Text: For text data like names. Example: "John"
- Number: For numeric values. Example: 25
- Date/Time: For dates and times. Example: 01/01/2024
- Currency: For money. Example: GH₵500.00
- Yes/No: For boolean values. Example: True or False
Field properties define characteristics of data fields. Example: setting the field size of a text field to 50 limits entry to 50 characters.
- General Number
- Currency
- Fixed
- Standard
- Percent
- Scientific
b. State THREE (3) uses of navigation.
a. Navigation refers to moving through database records or screens.
b.
- To move between records
- To search for specific data
- To add or delete records
Used for maintenance tasks like compacting, repairing, encrypting, or backing up databases.
- Compact and Repair
- Database Splitter
- Backup
- Linked Table Manager
- Encryption Tool
ActiveX controls allow users to embed and interact with objects like calendars, calculators, and other tools in forms.
SECTION B – PRACTICAL
PART ONE
- Create a table for types of businesses with fields: Membership Number, Type of Business, Number of Employees.
- Create a dues payment table with fields: Membership Number, Due Date, Payment Amount (based on employee size: Small - $200, Medium - $300, Large - $500).
- Create another table for business contact info: Membership Number, Business Name, Address, City, Region Code.
- Set Membership Number as the Primary Key for all tables.
- Create forms and enter 20 records into each table.
PART TWO
- Create a query with Membership Number, Name, City. Sort by City and print it.
- Create a query showing Type of Business, Name, Membership Number, Number of Employees. Sort by Membership Number and print.
- Create a query displaying members with more than 50 employees. Design an appropriate report and print.
- Print all tables.
Advanced Exam Tip: For Level Three database practicals, focus on creating efficient table relationships and well-structured queries. Practice designing forms and reports that present data professionally. Time management is crucial - allocate appropriate time for each practical task during your exam.
Get the complete question paper for offline practice
