DATABASE IN TERMS OF IT

QUESTION

FIT9003 Assignment 1b Marking Guide Name:

Assessed by:

Criterion
(equal weight)
N – two or more of the
Quality of the
Introductory Narrative
Overview
Quality of Design
Solution
Correctness of
Notation

Correctness of
Normalisation
Data Dictionary &
Assertions
following:
P1 – mostly the
following:
Missing or fails to outline the
business problems adequately
Minimal discussion of the
business problems,
basically correct.
Very little support for requirements. Most requirements
supported, at most one or
two missing.  Inelegant,
cumbersome solution
Significant errors.  Logical diagram
misrepresents 3NF relations
derived during normalisation
process or normalisation errors still
present.
Minor notational errors.
Missing relationship
names.  Some incorrect
cardinalities and
optionalities.
Major normalisation errors. Mostly correct
normalisation.  Some
misunderstandings of (at
most one) normal form.
Missing or significantly incomplete.
Major errors.
Minor errors.  DD contains
entries for all entities and
attributes.  Assertions
(possibly with errors) for
most required model
elements.
C – mostly the following:
D – all of the following:
Reasonable level of detail,
gives reader a good
understanding of the business
problems.
Minor misunderstanding of
requirements permitted.
Reasonable solution that
should work if implemented.
Very minor errors.  All
relationships and entities
named.
Minor errors in normalisation,
but clearly understands each
normal form.
No errors, some thought into
layout, basic contents.  Minor
errors in assertions.
Presentation
Poorly presented. Bound, word processed. Professional presentation. Significant thought gone into
presentation.
Acknowledgement of
Sources

Plagiarism or unauthorised
collaboration – AUTOMATIC FAIL

Comments: Grade:

HD – all of the criteria
for D plus one or more
of:
Excellent detail and
discussion, and good overview
of the solution aimed at a
business reader.
Design shows significant
insight into modelling the
problem, innovative and
elegant design.
No significant errors, and an
elegant solution.
No errors.
No errors, and evidence of
thought given to all DD
elements, including domain,
range, etc.  Assertion checklist
complete and correct.
SOLUTION

KI63