Recently Updated Pages

Lecture 26/10/16 - Planning a database

Things to consider NOT NULL for important fields Length of data in fields

Lecture 25/10/16 - Database datatypes

Numeric INT  Whole numbersFLOAT  Approx real numbersDECIMAL  Exact storage of real numbers Date...

Other database operations

Updating an existing row UPDATE tableNameSET field = newValue, field2 = newValue2[WHERE field3 =...

Lecture 18-10-16 Many to Many Links

Solution to this: Junction Table A junction table is purely a link between 2 other tables to all...

Lecture 10/10/16 - Keys

A key is a value that uniquely indentifies every entry in a particular table. A candidate key is ...

Lecture 11/10/16 - Selecting from multiple tables

SELECT * FROM table1, table2 WHERE table1.value = table2.value  

[Extra Notes] 2.5 - Querying the Database

SELECT SELECT syntax All rows from specified columns SELECT column1Name, column2Name,... FROM...

Lecture 2.2

WHERE conditions on SELECT Test on numbers =  <  <=  >  >=  != Tests on text = ...

Lecture 2.1

Structured Query Language A data definition language Data manipulation language Industrial st...

Lecture 1.3 - Accessing and searching a database

Web Pages Static web page Browser sends request to the web server The server fetches the requ...

Lecture 1

Database Systems Made up of 3 main elements: Schema - design DBMS - hosts data efficiently an...

Lecture 27

Searching Linear Search If a number is to be found in a sequence of values that occur in arbitr...

Lecture 26

Recursion A technique that allows the break down of a problem into sub problems of the same type...

Lecture 24: Collections

Collections Framework Overview A collection is an object that represents a group of objects. Whe...

Lecture 21: Week 8 exam prep

No commenting required Java files given with initial information Call methods from the files ...

Lecture 20: Java FX

Java FX is a set of Java packages that lets you add graphical user interface to Java applications...

Lecture 19

UML diagrams in slides  

Lecture 18

|||| |||| || Not all setters will be shown on the UML. Check before generating getters and setters

Lecture 17: Structured Data

Structured data CSV File Each record is stored on a new line. Each field is separted by a comma...

Lecture 16: Introduction to File Input/Output

Reading from Text filesWriting to text filesOverview of exception handling for file I/OWorking wi...