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 Mark Mark 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.