Search Filters
Content Type

Exact Matches
Tag Searches
Date Options
Updated after
Updated before
Created after
Created before

Search Results

96 total results found

CSC2045 - Software Engineering

Software Engineering

Lecture 18-10-16 Many to Many Links

CSC1018 Databases

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

Computer Networks

CSC1018 Networks

Networking The generic term node or host refers to any device on a network. A file server is a c...

The Internet

CSC1018 Networks

Composition There are 4 tiers in the composition of the internet Tier-1 ISPs Top level of th...

Types of Network

CSC1018 Networks

Mobile Phone Cell Towers Typically have 3 sectors, each operating at a different frequency so t...

Address Registers

CSC1018 Architecture Test 3

An address register is a box containing the address of a location in main memory. Each address re...

Shift Instructions

CSC1018 Architecture Test 3

Used to move a group of bits one or more places to the left or right. If the contents of the data...

Creating a loop

CSC1018 Architecture Test 3

A loop is created using a loop counter and the conditional branch instruction BNE. Choose a dat...

Branch Instructions

CSC1018 Architecture Test 3

Unconditional Branch Instructions Branch Always - BRA Regarded as the simplest branch instruct...

Condition Flags

CSC1018 Architecture Test 3

Four condition flags Carry flag - C Overflow flag - V Zero flag - Z Negative flag - N Thes...

Lecture 26/10/16 - Planning a database

CSC1018 Databases

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

Lecture 25/10/16 - Database datatypes

CSC1018 Databases

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

Other database operations

CSC1018 Databases

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

Lecture 10/10/16 - Keys

CSC1018 Databases

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

Databases

CSC1018

Dr. Brian Murphy

Lecture 11/10/16 - Selecting from multiple tables

CSC1018 Databases

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

[Extra Notes] 2.5 - Querying the Database

CSC1018 Databases

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

Lecture 2.2

CSC1018 Databases

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

Lecture 2.1

CSC1018 Databases

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

Lecture 1.3 - Accessing and searching a database

CSC1018 Databases

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

Lecture 1

CSC1018 Databases

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

Revision Notes

CSC2045 - Software Engineering

Computer Architecture (Exam Revision)

CSC1018

Architecture Test 3

CSC1018

Week 11 Test Revision Notes

CSC1020

Semester 2

CSC1020

Networks

CSC1018

Paul McMullan

Internet Addressing and Protocol

CSC1018 Networks

IPv4 Internet Addressing A 32 bit number, often written in dotted decimal format. There are only...