ICT285 – Assignment 1
Table of Contents
QUESTION 1..........................................................................................................................................1
QUESTION 2.................
...
ICT285 – Assignment 1
Table of Contents
QUESTION 1..........................................................................................................................................1
QUESTION 2..........................................................................................................................................2
QUESTION 3..........................................................................................................................................7
QUESTION 4..........................................................................................................................................9
QUESTION 5........................................................................................................................................10
QUESTION 1
a) PROJECTStaffName, Email (STAFF)
b) PROJECTRoomNo, Capacity (RESTRICT BuildingName=’Science & Computing’ AND Capacity>=30(LAB *
LAB.BuildingNo=BUILDING.BuildingNo BUILDING))
c) PROJECTSoftwareName, Version (RESTRICT BuildingName=’Science & Computing’ AND TeachingPeriod=’Semester 2’
(((REQUEST * REQUEST.SofwareID=SOFTWARE.SoftwareID SOFTWARE) REQUEST * REQUEST.RoomNo=LAB.RoomNo
LAB) LAB * LAB.BuildingNo=BUILDING.BuildingNo BUILDING))
d) PROJECT RoomNo (RESTRICT SoftwareName = ‘Microsoft Visio’ (REQUEST* REQUEST.SoftwareID=SOFTWARE.SoftwareID
SOFTWARE)) MINUS PROJECT RoomNo (RESTRICT TeachingPeriod=’Semester 2’ (REQUEST))
e) PROJECT SoftwareName, Version, RoomNo, BuildingName, StaffName (RESTRICT TeachingPeriod=’Semester 2’ ((((REQUEST
* REQUEST.SoftwareID=SOFTWARE.SoftwareID SOFTWARE) REQUEST * REQUEST.StaffNo=STAFF.StaffNo STAFF)
REQUEST * REQUEST.LabNo=LAB.LabNo LAB) LAB * LAB.BuildingNo=BUILDING.BuildingNo BUILDING))
f) PROJECT Email (STAFF * STAFF.StaffNo=REQUEST.StaffNo REQUEST) MINUS PROJECT Email (RESTRICT
TeachingPeriod=’Semester 2’ (STAFF * STAFF.StaffNo=REQUEST.StaffNo REQUEST))
g) PROJECT SoftwareName (RESTRICT BuildingName=’Law’ OR StaffNo=’S2019876’ OR (BuildingName=’Law’ AND StaffNo=’S2019876’)
((((SOFTWARE * SOFTWARE.SoftwareID=REQUEST.SoftwareID REQUEST) REQUEST * REQUEST.StaffNo=STAFF.StaffNo
STAFF) REQUEST * REQUEST.LabNo=LAB.LabNo LAB) LAB * LAB.BuildingNo=BUILDING.BuildingNo BUILDING))
h) PROJECT RequestID, StaffNo, RoomNo (RESTRICT SoftwareName=’Oracle SQL Developer’ AND Progress=’user acceptance testing’,
‘deployed’ (REQUEST * REQUEST.SoftwareName=SOFTWARE.SoftwareName SOFTWARE))
i) PROJECT RoomNo, Capacity, BuildingNo (RESTRICT Progress=’deployed’ ((LAB * LAB.RoomNo=REQUEST.RoomNo
REQUEST) REQUEST * REQUEST.SoftwareID=SOFTWARE.SoftwareID SOFTWARE))2
j) PROJECT BuildingName, SoftwareName (RESTRICT BuildingName=’Law’ (((LAB * LAB.BuildingNo=BUILDING.BuildingNo
BUILDING) LAB * LAB.RoomNo=REQUEST.RoomNo REQUEST) REQUEST * REQUEST.SoftwareID-SOFTWARE.SoftwareID
SOFTWARE))
QUESTION 2
a) SELECT WorkID, Copy, Medium, Description, LastName
FROM dtoohey.ARTIST
INNER JOIN dtoohey.WORK
ON dtoohey.ARTIST.ARTISTID = dtoohey.WORK.ARTISTID
WHERE Medium = 'High Quality Limited Print';
[Show More]
.png)
.png)
.png)
.png)
.png)
