ICT 285 Quiz 4 | Questions and Answers Latest Updated 2026 (Graded A+) - Murdoch University

ICT 285 Quiz 4 | Questions and Answers Latest Updated
2026 (Graded A+) - Murdoch University




Mark 0.00 out of 1.00




Flag question




Question text

Which of the following is the primary key of the table below (you can assume the
data are representative)?

BRANCH_NU POSITIO
STAFF_NUM STAFF_NAME BRANCH_ADDRESS
M N

S100 Smith, J B100 Pseudopolis Manager

S100 Smith, J B200 Ankh Sweeper

S295 Vetinari, H B100 Pseudopolis Patrician
S331 Colon, S B100 Pseudopolis Clerk
Select one:

a. STAFF_NUM


b. There is no primary key because STAFF_NUM repeats meaning this is not a valid

relation

c. BRANCH_NUM


d. STAFF_NUM, BRANCH_NUM

Feedback

Based on the sample data (STAFF_NUM, BRANCH_NUM) would be the Primary Key.
Neither STAFF_NUM nor BRANCH_NUM can be the PK because they both repeat -
however, the combination of those two does not repeat.
The correct answer is: STAFF_NUM, BRANCH_NUM

,Question 2
Incorrect

Mark 0.00 out of 1.00




Flag question




Given the following relation (called Student) from the Murdoch Student Records




Which of the following statements is FALSE?
Select one:




Mark 1.00 out of 1.00

, Flag question




A relation that contains data recording Murdoch students' performance in units has


(StudentNumber, StudentName, UnitCode, Year, Semester, Grade, Mark).




What would be an appropriate primary key for this relation?



a. (StudentNumber)




c. (StudentNumber, StudentName, UnitCode, Year, Semester, Grade, Mark)


d. (StudentNumber, UnitCode, Year, Semester)




The correct answer is: (StudentNumber, UnitCode, Year, Semester)




Mark 1.00 out of 1.00




Flag question




Question text

Given the functional dependency A --> (B,C), A is called a(n ) .
Select one: