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: |
|||||||
TO THE LEARNER: Please attach
this assignment brief to any written work you are handing in for assessment, or
submit the brief as instructed.
YOUR WORK CANNOT BE ASSESSED
UNLESS YOU HAVE SIGNED AND SUBMITTED THIS FORM
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 |
Get Free Quote!
445 Experts Online