Advanced Database Systems (CE00332-3) Marking Scheme Page 1 of 3
Marking Scheme
The breakdown of marks for this assignment is as defined below:
Group marks (70%)
The marks allocated for the various sections (Design, Implementation, Query, Object etc. with
proper justifications) mentioned in the assignment will be factored down to 70% and assigned as
group marks.
Individual marks (30%)
20% Problem analysis and understanding of database development
10% Peer assessment (Use Excel Sheet formatted peer assessment form provided along with
the assignment)
Level-3 Asia Pacific Institute of Information Technology 2010
Advanced Database Systems (CE00332-3) Marking Scheme Page 2 of 3
Assessment Criteria:
Note: A single table design will receive zero marks for all elements of the assignment even if
there is some functionality.
The following guidelines indicate the standard that will be expected for each grade. Each
demonstration will be assessed individually and weaknesses in some areas may be compensated
by strengths in other areas.
All members of the group must participate in the demonstration. Group members may be
awarded different marks depending on the quality of the contribution to the demonstration.
Marks will also be adjusted to reflect peer assessment.
Grade A
Demonstrates an excellent understanding of the problem. The ERM model will be
implementable and any errors and/or omissions will be minor. The database will be implemented
to a high standard of functionality and will be appropriately normalized. Advanced data
modeling features will be used and there will be some use of PL/SQL. Queries will have been
attempted and all or most queries will function. Other elements to a high standard.
Documentation will be to a high standard. The group will be able to discuss their implementation
at demonstration and will be able to explain to describe the way in which they have attempted
the project.
Grade B
Demonstrates a good understanding of the problem. The EERM model will be implementable
and errors and/or omissions will be minor. The database will function and will be appropriately
normalized although with some errors and/or omissions. Advanced data modeling features will
be used. PL/SQL will be used but with some errors or omissions. Queries will have been
attempted and most queries will function. Other elements attempted and generally satisfactory.
Documentation will be satisfactory. The group will be able to discuss their implementation at
demonstration and will be able to explain to describe the way in which they have attempted the
project.
Grade C
Demonstrates an adequate understanding of the problem. The EERM model will be
implementable although with some errors and/or omissions. The database will function and will
be appropriately normalised although with some errors and/or omissions. Queries will have been
attempted and the majority of queries will function. Most other elements attempted although with
errors and/or omissions are satisfactory. Documentation will be adequate. The group will be able
to discuss their implementation at demonstration and will be able to explain to describe the way
in which they have attempted the project.
Level-3 Asia Pacific Institute of Information Technology 2010
Advanced Database Systems (CE00332-3) Marking Scheme Page 3 of 3
Grade D
Demonstrates some understanding of the problem. The EERM model will be implementable
although with errors and/or omissions. The database will function although with some errors
and/or omissions. Most data will be in 3NF but there may be some normalisation issues. Queries
will have been attempted and some queries will function. Most other elements attempted
although with errors and/or omissions. Documentation will be adequate but explanations may be
limited.
Grade E (fail)
Demonstrates limited understanding of the problem. The EERM model will be not be
implementable or will not cover major aspects of the scenario. The database will function but
will have major errors and/or omissions. Queries may not have been attempted or very limited
queries have been produced. Other elements limited or not satisfactory. Documentation may be
limited or not to an acceptable standard. Explanations will be limited but sufficient to
demonstrate that the group understands the work that has been submitted.
Grade F (fail)
Demonstrates poor understanding of the problem. The EERM model will be not be
implementable or will not cover major aspects of the scenario. The database may have limited
functionality and major errors and/or omissions are likely. Queries may not have been attempted
or very limited queries. Other elements not attempted or not satisfactory. Documentation very
limited or not to an acceptable standard. Explanations will be limited but sufficient to
demonstrate that the group understands the work that has been submitted.
Zero marks will be awarded for non submission, single table implementation or insufficient
explanations to demonstrate that the group understands the work that has been submitted.
Level-3 Asia Pacific Institute of Information Technology 2010