Name of Centre:

Learner achievement (please circle) NB: All learner achievement is provisional until confirmed at the AVA Awards Board.

Level Achieved:

L3

Achievement

(Level 3 units only)

P

M

D

Resubmission?

Y

N

Title of Access to HE Diploma: Computing

(e.g. Science)

Unit title(s):    Practical Relational Database Development

Unit code(s):

Learner:   

Tutor/Assessor: 

Description of Assignment: 

Task 1

Analyse the attached case study and derive a set of normalised tables from it.   Create a conceptual class diagram, then analyse the diagram, resolving any many-to-many relationships and create a resulting Entity-Relationship diagram.   (AC 1.1)

Task 2

From the ER diagram created in Task 1, design a database.   The designs for this database must include table structures, entry forms, meaningful reports, and queries used to support the reports.   Design a menu system to allow the user to interact with the database.   Set this up as a database application, so that the menu displays on start and all database development aspects of the program are hidden.   (AC 2.1, 3.1, 4.1)

Task 3

From the designs created in Task 2, build a working database application.  (AC 5.1)

Task 4

Write user documentation for the database, explaining how to use the database in detail.  Include a troubleshooting section to cover any possible common problems.  (AC 5.1)

Date set:  24/2/2020

Date for draft submission

(if applicable): 

Date for final

submission:  8/5/2020

Extension date 

(if agreed): 

Signed by Tutor/Assessor to agree extension: 

Date

submitted:

Internal Moderation:   Yes / No

Date:

Signed by internal moderator:

ON TIME          /           LATE

Learner declaration:

 The explanations and evaluations in this work have been developed and written by me.

 I have not submitted material copied from the Internet, text books or other sources in place of my own thinking and writing.

 When I have referred to the work of others I have done so to discuss, comment on or argue their ideas.

 I have kept quotation and paraphrasing to an absolute minimum and only to support points I have made.

 I understand that referencing the names of authors whose ideas I have used without including my own interpretation of those ideas, does not meet the assessment criteria and cannot attract the Pass, Merit or Distinction grades.

 I have not copied the work of my peers.

Learner comments: (please use this space to comment on any aspect of the assignment when handing in your work)

Signature:

Date: 

Level 3

Unit title: 

Learning outcomes

Assessment criteria

This is what you will learn on the unit.

This is what you must be able to demonstrate that you can do in your assignment in order to achieve the unit.

The learner will:

The learner can:

1.    Apply the concept of database modelling to a case study.

1.1.  Draw Entity Relationship Diagrams which appropriately reflect the case study.

2.    Understand the concept of shared, non-redundant data.

2.1.  Design and produce appropriate relational tables.

3.    Understand the concept of normalised data structures.

3.1.  Produce normalised data tables which reflect the case study.

4.    Design Input Screens, Menu Screens and Reports using user-friendly Interface concepts.

4.1.  Design and produce a range of Menus, Input Screens and Reports, satisfying the case study.

5.    Use appropriate software to develop a functional relational database application.

5.1.  Develop and produce a working database application to represent the case study with suitable user documentation.

Level 3 units only:

Learners achieve a Pass if they meet all Level 3 Assessment Criteria for a unit.  You will achieve a Merit or Distinction by meeting the following Grade Descriptors.  Your tutor will give you feedback for all three grades.

Grade Descriptor

Merit

(Choose one or more relevant grade components)

Distinction

(Choose one or more relevant grade components)

GD3: Application of Skills

The student, student’s work or performance generally selects appropriate skills, techniques and methods and applies appropriate skills, techniques and methods with very good levels of consistency, creativity, precision, accuracy and efficiency.

The student, student’s work or performance consistently selects appropriate skills, techniques and methods and applies appropriate skills, techniques and methods with excellent levels of consistency, creativity, precision, accuracy and efficiency.

Grade Descriptor

Merit

(Choose one or more relevant grade components)

Distinction

(Choose one or more relevant grade components)

GD7: Quality

The student, student’s work or performance taken as a whole, demonstrates a very good response to the demands of the brief/assignment.

The student, student’s work or performance taken as a whole, demonstrates an excellent response to the demands of the brief/assignment.

Grade Guidance: Learners must carefully read the guidance below which is linked to the components above

MERIT: (e.g. To achieve a Merit your work will show…..)

You will analyse the case study and derive the major entities from it.   You will create an outline class diagram and then refine this so that you create a fully normalised data structure.   You will design forms for all of your tables, design at least three reports with associated query designs.   You will build a working database with a menu system.  You will write user documentation that covers the major functions of the database with some troubleshooting information.

DISTINCTION: (e.g. To achieve a Distinction your work will show…..)

You will fully analyse the case study and derive all the entities from it.   You will create detailed class and ER diagrams that cover all of the requirements of the case study.   You will use these to create a fully normalised data structure.   You will design forms for all of your tables that are very user friendly.   You will design at least five different reports with associated queries that pull data from multiple tables and that meet a business need for your client.   You will build a fully functioning database application with a fully developed multilevel menu system.   You will write complete user documentation that includes screen shots and sample data.   Your documentation will include a fully detailed FAQ and troubleshooting guide