150 total results found
CSC2039 - Architecture and networks
Architecture and Networks
Lecture 26/10/16 - Planning a database
Things to consider NOT NULL for important fields Length of data in fields
WHERE conditions on SELECT Test on numbers = < <= > >= != Tests on text = ...
[Extra Notes] 2.5 - Querying the Database
SELECT SELECT syntax All rows from specified columns SELECT column1Name, column2Name,... FROM...
Lecture 11/10/16 - Selecting from multiple tables
SELECT * FROM table1, table2 WHERE table1.value = table2.value
Lecture 10/10/16 - Keys
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
Solution to this: Junction Table A junction table is purely a link between 2 other tables to all...
Other database operations
Updating an existing row UPDATE tableNameSET field = newValue, field2 = newValue2[WHERE field3 =...
Lecture 25/10/16 - Database datatypes
Numeric INT Whole numbersFLOAT Approx real numbersDECIMAL Exact storage of real numbers Date...
Four condition flags Carry flag - C Overflow flag - V Zero flag - Z Negative flag - N Thes...
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...
Unconditional Branch Instructions Branch Always - BRA Regarded as the simplest branch instruct...
Creating a loop
A loop is created using a loop counter and the conditional branch instruction BNE. Choose a dat...
Used to move a group of bits one or more places to the left or right. If the contents of the data...
An address register is a box containing the address of a location in main memory. Each address re...
Types of Network
Mobile Phone Cell Towers Typically have 3 sectors, each operating at a different frequency so t...
Composition There are 4 tiers in the composition of the internet Tier-1 ISPs Top level of th...
Networking The generic term node or host refers to any device on a network. A file server is a c...
Structured Query Language A data definition language Data manipulation language Industrial st...
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
CSC2042 - Information Modelling
CSC2045 - Software Engineering
Waze Ireland Townland Datasets
Documentation for the townland-clipper script and the accompanying wme-datasets website.
Dr. Brian Murphy
Week 11 Test Revision Notes
Computer Architecture (Exam Revision)
Dataset Download Website
Documentation for the website where files can be downloaded by county as created by the Townland ...
Data Structures and Algorithms
Documentation for the townland clipper script which splits up open townland datasets provided by ...
Internet Addressing and Protocol
IPv4 Internet Addressing A 32 bit number, often written in dotted decimal format. There are only...