Search Filters
Content Type

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

Search Results

150 total results found

CSC2039 - Architecture and networks

Architecture and Networks

Lecture 26/10/16 - Planning a database

CSC1018 Databases

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

Lecture 2.2

CSC1018 Databases

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

[Extra Notes] 2.5 - Querying the Database

CSC1018 Databases

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

Lecture 11/10/16 - Selecting from multiple tables

CSC1018 Databases

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

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 ...

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...

Other database operations

CSC1018 Databases

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

Lecture 25/10/16 - Database datatypes

CSC1018 Databases

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

Condition Flags

CSC1018 Architecture Test 3

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

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...

Branch Instructions

CSC1018 Architecture Test 3

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

Creating a loop

CSC1018 Architecture Test 3

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

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...

Address Registers

CSC1018 Architecture Test 3

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

Types of Network

CSC1018 Networks

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

The Internet

CSC1018 Networks

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

Computer Networks

CSC1018 Networks

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

Lecture 2.1

CSC1018 Databases

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

Lecture 1

CSC1018 Databases

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

CSC2040 - Data Structures, Algorithms and Programming Languages

Data Structures, Algorithms and Programming Languages

Architecture Test 3

CSC1018

CSC2042 - Information Modelling

Information Modelling

CSC2045 - Software Engineering

Software Engineering

Waze Ireland Townland Datasets

Documentation for the townland-clipper script and the accompanying wme-datasets website.

Databases

CSC1018

Dr. Brian Murphy

Networks

CSC1018

Paul McMullan

Semester 2

CSC1020

Week 11 Test Revision Notes

CSC1020

Computer Architecture (Exam Revision)

CSC1018

Dataset Download Website

Waze Ireland Townland Datasets

Documentation for the website where files can be downloaded by county as created by the Townland ...

C++

CSC2040 - Data Structures, Algorithms a...

One

CSC2042 - Information Modelling

Two

CSC2042 - Information Modelling

Data Structures and Algorithms

CSC2040 - Data Structures, Algorithms a...

Networks

CSC2039 - Architecture and networks

Architecture

CSC2039 - Architecture and networks

Revision Notes

CSC2045 - Software Engineering

Townland Clipper

Waze Ireland Townland Datasets

Documentation for the townland clipper script which splits up open townland datasets provided by ...

Internet Addressing and Protocol

CSC1018 Networks

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