A relational database has been created to store data about subjects that students are studying. The following is a
selection of some data stored in one of the tables. The data represents t he student's name, the personal tutor group,
the personal tutor, the subject studied, the level of study and the subject teacher but there is some data missing:
Xiangfei 3 MUB Computing A DER
Xiangfei 3 MUB Maths A BNN
Xiangfei 3 MUB Physics AS DAB
Mahesh 2 BAR History AS IJM
Mahesh 2 BAR Geography AS CAB
Define the terms used to describe the components in a relational database table using examples from
this table.
ii If this represented all of the data, it would have been impossible to create this table.
What is it that has not been shown here and must have been defined to allow the creation as a relational
[2]
database table? Explain your answer and suggest examples of the missing data.