Copyright © T. H. Merrett

COMP 612              Principles of Database Programming                 Week 11

Assignment 10

Use a nested relation in Aldat to represent arrays of marks for student
assignments as follows.

	StudId		Mark[1]		Mark[2]		Mark[3]
	 1111		  22		  25		  26
	 2222		  24				  24
	 3333				  27		  23

Calculate the average mark for each student and show it together with the
StudId in a single, 1NF relation.

Calculate the average mark for each assignment and show it together with the
assignment number in a single, 1NF relation. Discuss any drawbacks of your
method.

ALL RELIX ASSIGNMENTS ARE TO BE SUBMITTED IN THE FORM OF AN UNEDITED TRACE
OF YOUR DEBUGGED FINAL RUN.

Shared marks for shared work: assignments should be your own work; marks
for joint assignments will be divided by the number of collaborators.
But please feel free to work in groups to learn or for extra work that
is not for marks. HINT: treat your own work for marks as top secret; treat
others' work, if you come across it, as personal and private to them.