![]() |
All qualifications and part qualifications registered on the National Qualifications Framework are public property. Thus the only payment that can be made for them is for service and reproduction. It is illegal to sell this material for profit. If the material is reproduced or quoted, the South African Qualifications Authority (SAQA) should be acknowledged as the source. |
SOUTH AFRICAN QUALIFICATIONS AUTHORITY |
REGISTERED UNIT STANDARD: |
Design complex tables and queries using a graphical user interface (GUI) based database to solve a given problem |
SAQA US ID | UNIT STANDARD TITLE | |||
258881 | Design complex tables and queries using a graphical user interface (GUI) based database to solve a given problem | |||
ORIGINATOR | ||||
SGB Computer Sciences and Information Systems | ||||
PRIMARY OR DELEGATED QUALITY ASSURANCE FUNCTIONARY | ||||
- | ||||
FIELD | SUBFIELD | |||
Field 10 - Physical, Mathematical, Computer and Life Sciences | Information Technology and Computer Sciences | |||
ABET BAND | UNIT STANDARD TYPE | PRE-2009 NQF LEVEL | NQF LEVEL | CREDITS |
Undefined | Regular | Level 4 | NQF Level 04 | 5 |
REGISTRATION STATUS | REGISTRATION START DATE | REGISTRATION END DATE | SAQA DECISION NUMBER | |
Reregistered | 2018-07-01 | 2023-06-30 | SAQA 06120/18 | |
LAST DATE FOR ENROLMENT | LAST DATE FOR ACHIEVEMENT | |||
2024-06-30 | 2027-06-30 |
In all of the tables in this document, both the pre-2009 NQF Level and the NQF Level is shown. In the text (purpose statements, qualification rules, etc), any references to NQF Levels are to the pre-2009 levels unless specifically stated otherwise. |
This unit standard does not replace any other unit standard and is not replaced by any other unit standard. |
PURPOSE OF THE UNIT STANDARD |
This Unit Standard is intended for people who need to plan, produce and use small scale databases using a GUI based database application.
A person credited with this unit standard is capable to: |
LEARNING ASSUMED TO BE IN PLACE AND RECOGNITION OF PRIOR LEARNING |
It is assumed that the learner is competent in the following:
|
UNIT STANDARD RANGE |
Specific Outcomes and Assessment Criteria: |
SPECIFIC OUTCOME 1 |
Demonstrate an understanding of relational database theory. |
ASSESSMENT CRITERIA |
ASSESSMENT CRITERION 1 |
Data is organised in a relational database using the rules of normalisation. |
ASSESSMENT CRITERION 2 |
Relationship types are analysed in terms of their optimal implementation in database design. |
ASSESSMENT CRITERION RANGE |
Relationship types include one-to-many, one-to-one, many-to-man. |
ASSESSMENT CRITERION 3 |
The use of keys and indexes are analysed as to avoid redundancy and to speed up data access. |
ASSESSMENT CRITERION RANGE |
Keys and indexes include primary keys, unique records. |
SPECIFIC OUTCOME 2 |
Analyse unstructured data not populated to a relational database model. |
ASSESSMENT CRITERIA |
ASSESSMENT CRITERION 1 |
Unstructured data is analysed to determine the structure of the database. |
ASSESSMENT CRITERION 2 |
Data is categorised and the relevant tables are created to optimise access to the data. |
ASSESSMENT CRITERION 3 |
Data fields are created taking into account the data types, indexes and keys. |
ASSESSMENT CRITERION RANGE |
Data types, indexes and keys include but are not limited to data types, primary key, format, default value, validation rule. |
ASSESSMENT CRITERION 4 |
Tables are normalised in accordance with the normalisation rules. |
ASSESSMENT CRITERION 5 |
A relationship diagram is created and relationships implemented between tables. |
ASSESSMENT CRITERION RANGE |
Creation includes join types, referential integrity. |
SPECIFIC OUTCOME 3 |
Create queries using specific functions. |
OUTCOME NOTES |
Specific functions include multiple tables, comparison and logical operators. |
ASSESSMENT CRITERIA |
ASSESSMENT CRITERION 1 |
Built-in functions of the database program are used to shape data and constrain results. |
ASSESSMENT CRITERION RANGE |
Functions include but are not limited to date and time functions, text manipulation, inspection functions. |
ASSESSMENT CRITERION 2 |
Comparison and logical operators are implemented to constrain results to a specified range. |
ASSESSMENT CRITERION RANGE |
Logical operators include Equals, Greater Than, Less Than, Is Null, Is Not Null, and Like, And, Or, Not). |
ASSESSMENT CRITERION 3 |
A query is constructed using multiple tables. |
ASSESSMENT CRITERION RANGE |
Constructing includes related fields, join types. |
SPECIFIC OUTCOME 4 |
Create different types of queries. |
OUTCOME NOTES |
Types of queries include sub-queries, cross tab queries, duplicate and unmatched queries. |
ASSESSMENT CRITERIA |
ASSESSMENT CRITERION 1 |
A sub-query is created by using criteria resulting from another query. |
ASSESSMENT CRITERION RANGE |
Sub-query is created by amongst others checking values against a lookup table, comparing values against other values. |
ASSESSMENT CRITERION 2 |
A cross tab query is created by using specific tool provided by GUI relational database to pivot the existing data. |
ASSESSMENT CRITERION 3 |
A query is created to find duplicates in a table. |
ASSESSMENT CRITERION 4 |
An unmatched query is created to find values with no matching value in a related table. |
SPECIFIC OUTCOME 5 |
Create parameter queries and adding calculated fields. |
ASSESSMENT CRITERIA |
ASSESSMENT CRITERION 1 |
A parameter query is created to constrain the result set by way of entering a constraint in a textbox. |
ASSESSMENT CRITERION 2 |
A new field is created in a query by using an aggregation of existing fields by means of arithmetic calculations. |
ASSESSMENT CRITERION 3 |
A new field is created in a query by using an aggregation of existing fields by means of text manipulation. |
SPECIFIC OUTCOME 6 |
Create basic select queries using simple SQL syntax. |
ASSESSMENT CRITERIA |
ASSESSMENT CRITERION 1 |
A simple select statement is used to retrieve data. |
ASSESSMENT CRITERION RANGE |
Selection processes include but are not limited to the use of keywords, select, from. |
ASSESSMENT CRITERION 2 |
A simple select statement is used to retrieve data using constraints. |
ASSESSMENT CRITERION RANGE |
Constraints include where, order by. |
ASSESSMENT CRITERION 3 |
The distinct keyword is used to return one record. |
UNIT STANDARD ACCREDITATION AND MODERATION OPTIONS |
UNIT STANDARD ESSENTIAL EMBEDDED KNOWLEDGE |
UNIT STANDARD DEVELOPMENTAL OUTCOME |
N/A |
UNIT STANDARD LINKAGES |
N/A |
Critical Cross-field Outcomes (CCFO): |
UNIT STANDARD CCFO IDENTIFYING |
Identifying and solving problems in which responses display that responsible decisions using critical and creative thinking have been made when:
|
UNIT STANDARD CCFO WORKING |
Working effectively with others as a member of a team, group, organisation, and community during:
|
UNIT STANDARD CCFO ORGANISING |
Organising and managing oneself and one's activities responsibly and effectively when:
|
UNIT STANDARD CCFO COLLECTING |
Collecting, analysing, organising and critically evaluating information when:
|
UNIT STANDARD CCFO COMMUNICATING |
Communicating effectively using visual, mathematical and/or language skills in the modes of oral and/or written persuasion when:
|
UNIT STANDARD CCFO SCIENCE |
Using science and technology effectively and critically, showing responsibility towards the environment and health of others when:
|
UNIT STANDARD CCFO DEMONSTRATING |
Demonstrating an understanding of the world as a set of related systems by recognising that problem-solving contexts do not exist in isolation when:
|
UNIT STANDARD ASSESSOR CRITERIA |
N/A |
REREGISTRATION HISTORY |
As per the SAQA Board decision/s at that time, this unit standard was Reregistered in 2012; 2015. |
UNIT STANDARD NOTES |
N/A |
QUALIFICATIONS UTILISING THIS UNIT STANDARD: |
ID | QUALIFICATION TITLE | PRE-2009 NQF LEVEL | NQF LEVEL | STATUS | END DATE | PRIMARY OR DELEGATED QA FUNCTIONARY | |
Elective | 61591 | National Certificate: Information Technology: End User Computing | Level 3 | NQF Level 03 | Reregistered | 2021-06-30 | As per Learning Programmes recorded against this Qual |
PROVIDERS CURRENTLY ACCREDITED TO OFFER THIS UNIT STANDARD: |
This information shows the current accreditations (i.e. those not past their accreditation end dates), and is the most complete record available to SAQA as of today. Some Primary or Delegated Quality Assurance Functionaries have a lag in their recording systems for provider accreditation, in turn leading to a lag in notifying SAQA of all the providers that they have accredited to offer qualifications and unit standards, as well as any extensions to accreditation end dates. The relevant Primary or Delegated Quality Assurance Functionary should be notified if a record appears to be missing from here. |
1. | Abetech |
2. | Academy of Training and Development |
3. | AccTech Systems (PTY)LTD |
4. | Act of Grace 97 |
5. | Added Advantage Academy (Durban) |
6. | Affirmations Training |
7. | Anderson College (Pty) Ltd |
8. | Ankalite (Pty) Limited |
9. | Artshub Institute (Pty) Ltd |
10. | ATTI Nelspruit Pty Ltd |
11. | Bokamoso Competence (Pty) Ltd |
12. | Bonalesedi Computer Training |
13. | Calandra Trading 523(PTY) |
14. | Cape Innovation Technology Initiative |
15. | Cape Town Society for the Blind |
16. | Centretech Broadcasting |
17. | Clean Heat Academy |
18. | Columbus Consulting Pty Ltd |
19. | Competence computer and business management |
20. | Denwin's Computer & Business School |
21. | DIGMAC PTY LTD |
22. | Ditlotlo Trading Enterprise Cc |
23. | False Bay College |
24. | Gabasega Consulting and Training Centre |
25. | Gauteng College of Engineering and Technology (PTY) LTD |
26. | Gegana Computer Academy and Business Solutions cc |
27. | Giga Skills Training |
28. | Goodwill Institute Of Technology |
29. | iLearn Corporate Services PTY LTD |
30. | In Excess Trading 22 T/A ATTI Polokwane |
31. | Indonsa Consulting and Training cc |
32. | ISAMON VOCATIONAL COLLEGE OF EXCELLENCE |
33. | iSolve Business Solutions (Pty) Ltd |
34. | IT SA Computer Services Solutions (Pty) Ltd |
35. | IT Schools Innovation (Pty) Ltd |
36. | Johannesburg Institute of Engineering & Technology |
37. | John Taolo Gaetsewe Developmental Trust |
38. | Keybase Training Solutions Cc |
39. | King Sabata Dalindyebo TVET College |
40. | Kylix Information Systems |
41. | LA Gomme Training Centre |
42. | Leading Edge Business Solutions (Pty) Ltd |
43. | Leseding Computer Systems (Pty) Ltd |
44. | Limco Consulting and management (Pty) Ltd |
45. | Loja Trading cc |
46. | M-cot Corporate Training |
47. | Mackeys Computing (Pty) Ltd |
48. | Makhophila Business Enterprise |
49. | Mash Computer Training |
50. | Mkoneni Consulting (Pty) Ltd |
51. | Mosadikago Trading Cc |
52. | Mpande Technologies cc |
53. | Mthonyama Technologies cc |
54. | Mveelaphanda Development and Projects cc |
55. | Nyankwavi Inverstment |
56. | Ocule IT cc |
57. | Prompt It Solutions |
58. | Prophesy Training College (Pty) Ltd |
59. | Protech Business and Computer College Pty Ltd. |
60. | Rainbow Moon Trading 193 CC |
61. | Sed General Trading Enterprise |
62. | Sivile Housing Association RSA |
63. | Southern Africa Youth Project NPC |
64. | Speccon (Pty) Ltd |
65. | Star Light Consulting |
66. | Taballos Business Services |
67. | Terry Computer Services cc |
68. | The Graduate Institute of South Africa |
69. | The Ulwazi Computer Training Center |
70. | Tira Telecoms |
71. | Torque Technical Computer Training (Pty) Ltd |
72. | Tshiredo Training Academy Cc |
73. | Turnstone Trading 183 (Pty) Ltd |
74. | Waterberg TVET College |
75. | Work Skills Resources |
76. | Y2K COLLEGE |
77. | ZJ Africa Learn (Pty) Ltd |
All qualifications and part qualifications registered on the National Qualifications Framework are public property. Thus the only payment that can be made for them is for service and reproduction. It is illegal to sell this material for profit. If the material is reproduced or quoted, the South African Qualifications Authority (SAQA) should be acknowledged as the source. |