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:
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:
