Recently Updated Pages

Week 8

NoSQL Underlying philosophy Start with asking the question, "what queries do I need to support?...

Week 7 Lecture 2

Criticisms of relational DBMSs Distribution and performance When databases become so big that t...

Lecture 1

Organising Data Data is organised for a number of reasons: Ease of access to information Effi...

Week 2 Lecture 2

Set Operations union, intersect, except operate on relations and correspond to the respective al...

Week 3 - Lecture 1

Views In some cases, it is not desireable that all users can see the entire logical model (the r...

Week 3 Lecture 2

Types of DBMS Relational (tables), graph (nodes and edges), documents (text documents, PDFs, etc...

Week 4 Lecture 1

Participation constraints Enforcing each entity in an entity set to participate in the relations...

Week 4 Lecture 2

Generalisation/Specialisation Generalisation/specialisation induces IS-A relationships between e...

Week 5 Lecture 1

Group assignement information 5 group meetings ER Modelling meeting Each group member does...

Week 5 Lecture 2

ER to relational conversion Rules A strong entity set reduces to a schema with the same attrib...

Week 6 Lecture 1

Database normalisation First normal form This enforces that tables should be "strictly relation...

Week 6 Lecture 2

Non-intersecting decompositions When there is no intersection, decomposition tends to be lossy. ...

Week 7 Lecture 1

A functional dependency A -> B is said to exist when each value (combination) of A is associ...

Command line arguments

#include <iostream> #include <string> using namespace std; int main(int argc...

Lecture 5

Template functions Templates allow for use of the same code for a range of data types. The idea ...

Lecture 4

Operator overloading You can overload most operators such as +, -, ++, --, ==, !=, += etc so tha...

Misc

See CSC2045 deliverables diagram Use case diagram will not be a single button click. It will li...

Lecture 3

Class definition The header file defines a class. Example: #ifndef STACK_H #define STACK_H ...

Extra notes - Use cases

Use case A use case is a description of a set of sequences of actions, including variants, that ...

Chapter 6 - Testing Strategies

Typically a fault leads to an error, and the error will ultimately lead to a failure. Failure: a...