YEAR I
Computer Science
coverING foundational knowledge of computer systems, the development of Python code for digital humanities, and the design and querying of SQL databases.
Computer Science
MODULES
CS1201 – Introduction to Computer SystemsCS1205 – Programming Fundamentals ICS1206 – Programming Fundamentals IICS1204 – Databases for Digital Humanities
Previous
Next
Tue Feb 11 2025
Fooditude: Minimize Waste, Maximize Taste
Approximately one-third of the food produced worldwide is wasted and never consumed. Thisis a major problem for a variety of reasons, including the…
Read more
Tue Feb 11 2025
SVG – Scalable Vector Graphics: Face
Read more
Tue Feb 11 2025
Assignment 1: Input, Output, Expressions
Read more
Tue Feb 11 2025
Lab 1 Databases
SELECT FName, LName, Address FROM STAFF WHERE Salary<20000;
SELECT FName, LName, Address FROM STAFF WHERE Salary<20000 AND Gender=’M’;
…
Read more
Tue Feb 11 2025
Lab 2 Databases
SELECT DISTINCT Job FROM STAFF WHERE Salary >15000;
SELECT Comment, Date FROM VIEWING WHERE PropertyNo=‘PG28’;
SELECT StaffNo, FName, LName FROM STAFF WHERE BranchNo=‘B7’ AND (Job=‘manager’ OR Job=‘deputy’);
SELECT Street, Area, City, PropertyNo FROM PROPERTY WHERE BranchNo=‘B3’ AND ((Type=‘apartment’ AND Rooms>3) OR Type=‘house’);
SELECT FName, LName, BranchNo FROM STAFF WHERE Job = ‘assistant’ AND Salary < 10000 AND Address LIKE ‘%Cork%’ ORDER BY LName;
SELECT FName, LName, Gender, Job FROM STAFF WHERE Salary >20000 AND Address LIKE ‘%Dublin%’;
SELECT FName AS ‘First Name’, LName AS Surname, Job AS Position, Salary FROM STAFF WHERE Gender=‘M’;
SELECT Street, Area, City, Rent FROM PROPERTY WHERE Type=‘apartment’ AND Rooms=3 AND BranchNo=B2’ AND Rent>400 AND Rent<500;
Read more
Tue Feb 11 2025
Lab 3 Databases
SELECT RENTER.FName, RENTER.LName, RENTER.AddressFROM RENTER, VIEWINGWHERE VIEWING.RenterNo=RENTER.RenterNo;
SELECT PROPERTY.Type, PROPERTY.RoomsFROM PROPERTY, STAFFWHERE STAFF.Job=’manager’ AND PROPERTY.StaffNo=STAFF.StaffNo;
SELECT OWNER.FName, OWNER,LNameFROM PROPERTY, OWNERWHERE PROPERTY.Type=’apartment’ AND PROPERTY.OwnerNo=OWNER.OwnerNo;
SELECT STAFF.FName, STAFF.LName, STAFF.BranchNoFROM PROPERTY, STAFFWHERE PROPERTY.City=’Cork’ AND STAFF.StaffNo=PROPERTY.StaffNo;
SELECT RENTER.FName, RENTER.LNameFROM RENTER, VIEWING, PROPERTYWHERE PROPERTY.Rooms>2 RENTER.RenterNo=VIEWING.RenterNo AND VIEWING.PropertyNo=PROPERTY.PropertyNo;
SELECT STAFF.FName, STAFF.LNameFROM STAFF, PROPERTY, OWNERWHERE …
Read more
Tue Feb 11 2025
Lab 4 Databases
SELECT STAFF.FName, STAFF.LNameFROM RENTER, STAFF, OWNERWHERE RENTER.FName=STAFF.FName AND OWNER.FName=STAFF.FName AND RENTER.LName=STAFF.FName AND OWNER.FName=STAFF.FName;
SELECT STAFF.FName, STAFF.LNameFROM BRANCH, STAFFWHERE STAFF.BranchNo=BRANCH.BranchNo AND BRANCH.City=’Dublin’ ANDSTAFF.TelNo LIKE ’021%’;
SELECT R1.FName, R1.LName, R1.TelNo, R2.FName, R2.LName, R2.TelNo FROM RENTER AS R1, RENTER AS R2 WHERE R1.Address=R2.Address AND (R1.FName, R1.LName) <> (R2.FName, R2.LName);
SELECT RENTER.TelNoFROM VIEWING, RENTERWHERE RENTER.RenterNo=VIEWING.RenterNo AND VIEWING.Comment LIKE ‘%damp%’ AND …
Read more
Tue Feb 11 2025
Lab 5 Databases
SELECT StaffNoFROM STAFFWHERE StaffNo NOT IN(SELECT StaffNoFROM PROPERTY);
SELECT TelNoFROM STAFFWHERE StaffNo NOT IN(SELECT StaffNoFROM …
Read more