by Editorial | Aug 17, 2020 | Grade 11, Grade 11 - Text Files, Grade 12, Grade 12 - PAT, Grade 12 - SQL, Grade 12 - text files
In your three class OOP programs – when working with textfiles, while-loops, creating an array of objects and databases . . . . there is a golden thread of consistency that you must adhere to ie the fields, the field types, number of fields and their order, must...
by Editorial | May 16, 2020 | Grade 12, Grade 12 - SQL
Here is a SQL Term Test based on the Ms Access database “BP Challenge” (Slightly modified. I do not know who the original author of this database is.). The database can be opened and SQL queries written in SQLBrowser (so you don’t need to have a copy...
by Editorial | May 2, 2020 | Grade 10 - SQL, Grade 11 - SQL, Grade 12 - SQL
If you do not have Ms Access you can still run SQL queries using SQLBrowser. Click to download SQLBrowser for Windows. (note: it only works with Ms Access databases with the old “mdb” extension. It does not work with “accdb”) NOTE: In Access...
by Editorial | Mar 15, 2020 | Grade 12, Grade 12 - SQL
I have shown you how to join tables using the WHERE clause. This is a great way to start understanding joins. But there is a better way ie using the JOIN keyword (inner joins and outer joins) Here is a very cool video explaining inner and outer joins in SQL. More SQL...
by Editorial | Mar 14, 2020 | Grade 11 - SQL, Grade 12 - SQL
Retrieving data out of a relational database is done mainly through the SELECT keyword in SQL. Here is a great video to explain the SQL SELECT statement. Part One. Note that our version of SQL supports TOP 1 and not LIMIT. Here is the link to SQL SELECT statement Part...
by Editorial | Feb 27, 2020 | Grade 12 - SQL, PWC grade 12 - All
Here is the IEB 480 SQL cluster test from 2018. The Ms Access DB will download into your downloads folder but the question paper and memo which are pdf documents will render in your browser. AnimalDB Test Paper...
