answers - SOLUTIONS - INTERNAL Part A Problem 1 . Total...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: SOLUTIONS - INTERNAL Part A Problem 1 . Total marks : [ 40 ] a) Define an ER model/diagram that describes the data to be stored in a database for a sports ... [ 30 ] A correct solution to this question is provided on the next page. Alternative solutions are possible. If a solution does not totally comply with the herein proposed solution it does not mean it is totally incorrect. It is the marker who should assess the level of correctness of variations to the solution proposed herein. If the level of correctness of a solution proposed by a student is say P%, then the final mark achieved by the student will be 30 x P%. Marking scheme for the proposed solution: correct identification and representation of entities 5 marks (see the note on relationships; if M:M relationships are used in the model, then certain entities that are present in the solution presented herein will not exist in the students model; if the model is correct, award full marks) correct identification of strong/weak entities 2 marks correct representation of relationships between weak and strong entities 2 marks correct identification and representation of attributes 4 marks correct identification and representation of relationships 5 marks correct identification and representation of cardinality of relationships 4 marks (not all the relations have to be 1:M; M:M relationships are accepted, as long as they are correctly identified and represented; if M:M relationships are accepted, then more care must be taken when marking the translation of the ER model into a relational model) correct identification and representation of participation constraints 3 marks (the student might make some different assumptions, such that the participation constraint will not correspond with the one presented here; if the model is correct according to their assumptions then award full marks) Total 25 marks inclusion of optional part 5 marks (if a different but correct model is proposed for this part, awards marks proportionally with the amount of given information correctly modelled by the student) TOTAL 30 marks CIS209 - 2001 - Internal - solutions 1 support-staff support-staff- allocation event competition contender contender allocation registers consists of participates has contender is overseen oversees registration receives 1 M M 1 M M 1 M 1 M 1 M 1 1 security doctor referee d individual team d role sex speciality level of intervention accreditation id name tel location type compulsory level number day time venue result id name regulations deadline id address tel alias/name date wins 1 1 name age med probs doctor's certificate member list captain gender optional optional winner accepted as possibility to relationship b) Transform the ER model into a relational model, specifying... [ 10 ] CIS209 - 2001 - Internal - solutions 2 COMPULSORY part of MODEL 1 mark per correct relation TOTAL 7 marks Contender ( id, alias, address, tel, gender ) PK : id Competition...
View Full Document

Page1 / 13

answers - SOLUTIONS - INTERNAL Part A Problem 1 . Total...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online