ICT 285 Database Murdoch | SQL

Running head: ICT 285 DATABASE MURDOCH
ICT 285 DATABASE MURDOCH
Name of the Student
Name of the University
Author Note

ICT 285 DATABASE MURDOCH1
Table of Contents
Relational algebra:.....................................................................................................................2
SQL – SELECT queries:............................................................................................................4
Further SQL:..............................................................................................................................7
Normalization:..........................................................................................................................11
Conceptual Design:..................................................................................................................12
Bibliography:............................................................................................................................14

ICT 285 DATABASE MURDOCH2
Relational algebra:
Answer a:
 LecturerName, UniversityName (LECTURER)
Answer b:
 LectureName (σ Topic = ‘Biological Diversity’ (LECTURE))
Answer c:
 StudentName (σ Topic = ‘Biological Diversity’ OR Topic = ‘Bugs and Bubs’
(UNIVERSITY * U.UniversityName = S.UniversityName STUDENT) * (U.UniversityName
= LC.UniversityName LECTURER) * LC.LecturerName = L. LecturerName LECTURE)))
Answer d:
 StudentName (σ Country = ‘Malaysia’ (UNIVERSITY * U.UniversityName =
S.UniversityName STUDENT)* U.UniversityName = L.UniversityName LECTURER)
Answer e:
 StudentName (σ UniversityName = ‘Murdoch University’, AND country = ‘Italy’
AND Topic = ‘Biological Diversity’ (UNIVERSITY * U.UniversityName =
S.UniversityName STUDENT) * (U.UniversityName = LC.UniversityName LECTURE) *
LC.LecturerName = L. LecturerName LECTURE)))
Answer f:
 LectureNo, LectureName, Topic, StudentName (UNIVERSITY *
UNIVERSITY.UniversityName = STUDENT.UniversityName STUDENT) *

ICT 285 DATABASE MURDOCH3
(UNIVERSITY UNIVERSITY.UniversityName = LECTURER.UniversityName
LECTURER) * LECTURER LECTURER.LecturerName = LECTURE. LecturerName
LECTURE)))
Answer g:
 StudentName (σ LectureName = ‘Introduction to Biology’ AND LectureName =
‘Darwin 101’ (UNIVERSITY * UNIVERSITY.UniversityName =
STUDENT.UniversityName STUDENT) * (UNIVERSITY UNIVERSITY.UniversityName
= LECTURER.UniversityName LECTURER) * LECTURER LECTURER.LecturerName =
LECTURE. LecturerName LECTURE)))
Answer h:
 LecturerName, Biography, UniversityName (σ Country = ‘Greece’ (UNIVERSITY
* UNIVERSITY. UniversityName = LECTURER. UniversityName LECTURER))
Answer i:
 StudentName (STUDENT)
MINUS
 StudentName (σ LectureName = ‘Grassland Cultivation Masterclass’ (UNIVERSITY *
UNIVERSITY.UniversityName = STUDENT.UniversityName STUDENT) *
(UNIVERSITY UNIVERSITY.UniversityName = LECTURER.UniversityName
LECTURER) * LECTURER LECTURER.LecturerName = LECTURE. LecturerName
LECTURE)))
Answer j: