This comprehensive guide from Armstrong Computers College provides detailed answers to all questions from the May/June 2023 Level Two Database Management examination. Use this interactive resource to enhance your understanding and prepare effectively for your upcoming exams.
Get the complete question paper with all sections for offline practice
SECTION A (50 MARKS)
b. List any three (3) types of keys used in Database.
a. A key in DBMS is a field or set of fields used to uniquely identify a record in a table.
b. Types of keys: Primary Key, Foreign Key, Candidate Key
b. List any three (3) uses of Database Management System.
a. Metadata is data that describes other data, such as data types, formats, and structures in a database.
b. Uses of DBMS: Data storage, Data security, Easy retrieval of information
a. Data Definition Language
b. Data Manipulation Language
a. DDL is used to define database structure (e.g., CREATE, ALTER).
b. DML is used to manipulate data (e.g., INSERT, UPDATE, DELETE).
1. Entity Integrity: Ensures each table has a primary key and that key is unique and not null.
2. Referential Integrity: Ensures foreign keys correctly reference primary keys in other tables.
Click on the last row → Press Tab or Insert Record → Enter data in the new row.
Advantages: Data consistency, Easy access, Improved data sharing
Disadvantages: Cost of setup, Complexity of management
c. State any three (3) components of a Database window.
a. A database window/interface is the graphical interface where users manage tables, queries, forms, etc.
Components: Tables, Queries, Reports
b. What is a Query by Example?
a. Row = horizontal record, Column = vertical field/attribute
b. QBE is a visual query method that lets users fill out a grid to build queries without SQL.
Primary Key: Unique identifier in the table. Cannot be null.
Foreign Key: Refers to a primary key in another table. Can be duplicated and null.
b. Explain two (2) types of attributes in DBMS.
a. An attribute is a field or property of a database entity (e.g., Name, Age).
b. Simple Attribute – Cannot be divided (e.g., Age).
Composite Attribute – Can be split into sub-parts (e.g., Full Name).
SECTION B: PRACTICAL (50 MARKS)
- Create a database and name it Market Record
- Enter the data:
Full Name Age Item Location Mr. Oppong 43 Provision Taifa Aunty Ama 39 Cassava Dansoman Mr. Dadzie 50 Meat Lapaz Awuara Ama 45 Vegetable Madina Aunty Mansah 38 Cereal Circle - Bold the column headings
- Add a second table named Kaneshie Market with assumed items
- Expand column widths and create a report for both tables
- Print your work and close all programs
Exam Preparation Tip: Practice these database concepts regularly and try creating sample databases to reinforce your understanding. Hands-on experience is crucial for mastering database management skills.
Get the complete question paper with all sections for offline practice