by Editorial | Feb 27, 2021 | Grade 11, Grade 12, Grade 12 - Search and Sort, PWC grade 12 - All
The bubble sort algorithm offers a simple solution to sorting items in an array; the array can be of a primitive data type e.g. int or it can be an array of objects. The bubble sort works for both numerical values as well as for String and char. SORT NUMBERS On...
by Editorial | Feb 19, 2021 | Grade 12, Grade 12 - Normalization
Normalization videos 1NF, 2NF and 3NF. Check out Caleb Curry’s normalization videos on YouTube. Database Design 35 – Introduction of Database Normalization. Database Design 36 – 1NF Database Design 37 – 2NF Database Design 38 –...
by Editorial | Feb 19, 2021 | Grade 12 - Normalization, PWC grade 12 - All
Shows the process from zero-normal-form 0NF to 3NF Click here...
by Editorial | Feb 19, 2021 | Grade 12, Grade 12 - Normalization
In this un-normalized spreadsheet (one table database) look for examples of: Redundant data, repeating groups and anomalies (insert, deletion and update). Click here for exercise Click here for some possible answers...
by Editorial | Feb 19, 2021 | Grade 12 - Normalization, PWC grade 12 - All
Normalization is the processes needed when someone has started a “database” in a spreadsheet i.e. a single table with many fields and now a proper database is needed. A “proper” database has more than one table. Each table stores related data....
by Editorial | Jan 18, 2021 | Grade 12, Grade 12 - text files
Write the following 2 class programs – version one followed by version three. They are different because the layout of the text file has changed. Version one has a single field on a single line (therefore no delimiter required.) Version three has three fields on...
