Scribd
Upload
6 views3 pages

Relational Database Design and Evaluation

The document outlines grading criteria for designing, developing, testing, and documenting a relational database system. It specifies learning outcomes (LOs) and associated performance (P), merit (M), and distinction (D) criteria for each stage of the database project. The focus is on user requirements, system functionality, and the effectiveness of the design and implementation.

Uploaded by

Yazhini Manoharan
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
6 views3 pages

Relational Database Design and Evaluation

The document outlines grading criteria for designing, developing, testing, and documenting a relational database system. It specifies learning outcomes (LOs) and associated performance (P), merit (M), and distinction (D) criteria for each stage of the database project. The focus is on user requirements, system functionality, and the effectiveness of the design and implementation.

Uploaded by

Yazhini Manoharan
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Grading Criteria Achieved Feedback

LO1 Use an appropriate design tool to design a relational


database system for a substantial problem

P1 Design a relational database system using appropriate


design tools and techniques, containing at least four
interrelated tables, with clear statements of user and
system requirements.
M1 Produce a comprehensive design for a fully functional
system that includes interface and output designs, data
validations and data normalization.

D1 Evaluate the effectiveness of the design in relation to


user and system requirements.

LO2 Develop a fully functional relational database system,


based on an existing system design

P2 Develop the database system with evidence of user


interface, output, and data validations, and querying across
multiple tables.

P3 Implement a query language into the relational


database system

M2 Implement a fully functional database system that


includes system security and database maintenance.

M3 Assess whether meaningful data has been extracted


using query tools to produce appropriate management
information.

LO3 Test the systems against user and system requirements


P4 Test the system against user and system requirements.

M4 Assess the effectiveness of the testing, including an


explanation of the choice of test data used.
LO2 & LO3
D2 Evaluate the effectiveness of the database solution in
relation to user and system requirements, and suggest
improvements.
LO4 Produce technical and user documentation

P5 Produce technical and user documentation.

M5 Produce technical and user documentation for a fully


functional system, including diagrams showing movement
of data through the system, and flowcharts describing how
the system works.

D3 Evaluate the database in terms of improvements


needed to ensure the continued effectiveness of the
system.

You might also like