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

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

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

View Full Document

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

View Full Document
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 student’s 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

## This note was uploaded on 05/13/2010 for the course COMPRO CS401 taught by Professor Just during the Spring '10 term at Maharishi.

### Page1 / 13

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

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

View Full Document
Ask a homework question - tutors are online