INFORMATION AND COMMUNICATION TECHNOLOGY
ICT LEVEL ONE & TWO
SUBJECT: DATABASE MANAGEMENT
INSTRUCTIONS: Answer all question in SECTION A and SECTION B You
Are advised not to spend more than 1 hour on SECTION A.
SECTION A
Answer All Question
Sorting refers to arranging data in a specific order based on one or more criteria, such as alphabetical, numerical, or chronological order. In MS Access, sorting can be applied to the data in a table, query, or form to change the display order of records.
Indexing is a technique used to improve the performance of data retrieval operations in a database.
The index helps in faster searching and sorting of records based on the indexed fields.
- Improved User Interface:Forms provide a user-friendly interface for entering and viewing data. They can be designed with labels, input fields, drop-down menus, and other controls that simplify data entry and make it more intuitive for users.
- Data Validation: Forms allow for the implementation of data validation rules and checks. They can validate user input to ensure data accuracy and integrity, such as enforcing required fields, data formats, or range restrictions.
- Enhanced Efficiency: Forms streamline the data entry process by providing a structured layout and predefined fields. They eliminate the need for users to directly interact with the underlying database tables and fields, reducing the chances of errors and speeding up the data entry process.
Validity Check is an automatic check on values entered in a field to make sure that the values are valid for the field type.
In a database system, a domain refers to the set of allowable values for a particular attribute or field. It defines the range of values that can be assigned to the attribute.
The domain specifies the data type, format, and any additional constraints or rules that apply to the attribute.
For example, a domain for a "Date" field may specify that only dates between a specific range are allowed, while a domain for a "Gender" field may restrict the values to "Male" or "Female" only.
Forms are database objects used primarily for data entry and making changes to existing records.
Reports are the printed output you generate from tables or queries.
Advantages of databases:
- Data Organization and Structure:
Databases provide a structured and organized way to store and manage data. They use tables, relationships, and constraints to define the data structure, ensuring data integrity and consistency. This allows for efficient data retrieval, updates, and maintenance. - Data Integration and Sharing:
Databases enable multiple users and applications to access and share data concurrently. They provide a centralized and controlled environment for managing data, allowing for seamless integration of data from various sources. This promotes collaboration, data consistency, and eliminates data redundancy. - Data Security and Access Control:
Databases offer robust security features to protect sensitive data.
They allow administrators to set access permissions and implement user authentication to ensure that only authorized users can access and modify the data. Databases also provide backup and recovery mechanisms to prevent data loss in case of system failures or disasters.
SECTION B - PRACTICALS
Answer all Questions
a. Design a table to hold data about the Chamber of Mines members.
the attributes of the table should include;
i. Name Of Business
ii. Membership number of the business
ii. The business address (include street, city, country)
iv. Telephone number (mobile numbers only)
v. name of managing director of the business
b. Create a table in Access, add descriptions to fields that do not have appropriate field names and create membership of the business as the primary key. Create a customized form for the table and append 25 records.
c. Use the table to answer the following:
i. Create a query that shows the membership number, member name and
address sort by city
ii. Create a report on the entire table.
iii. Save your work as MINING
iv. Print your work.
