Unit 18 Database Design Assignment Brief 2015
Learner’s Comments ( What went well, What could you improve)
Assessor’s name:
Assessor’s signature:
Date:
Learner’s Declaration:
I declare that this assignment is my individual work. I have not worked collaboratively nor have I copied from any other student’s work or from any other source except where due acknowledgment is made explicitly in the text, nor has any part been written for me by another person.
Signed: ........................................................................................... Date: ................................
Learning Outcome Ref
Learning Outcome
Criteria reference
To achieve the criteria the evidence must show that the student is able to:
Met Yes or No
Student Evidence
(Page Nos)
Feedback (dated)
LO1
Understand the features of relational databases
P1
Explain the features of a relational database
P2
Design a relational database for a specified user need
M1
Explain referential integrity and the purpose of primary keys in building the relationships between tables
D1
Discuss how potential errors in the design and construction of a database can be avoided
LO2
Be able to design, create and populate a relational database.
P3
Create and populate a database
P4
Create features in data entry forms to ensure validity and integrity of data
P5
Perform queries using multiple tables and multiple criteria
P6
Include an advanced feature in a database design
M2
Import data from an external source
M3
Export data to an external source
M4
Implement an automated function
Learning Outcome Ref
Learning Outcome
Criteria reference
To achieve the criteria the evidence must show that the student is able to:
Met Yes or No
Student Evidence
(Page Nos)
Feedback
LO3
Be able to test a relational database
P7
Test a relational database
D2
Evaluate a database against the specified user need
Unit 18 - Database Design -
Assessor’s name:
Assessor’s signature:
Date:
Learner’s Declaration:
I declare that this assignment is my individual work. I have not worked collaboratively nor have I copied from any other student’s work or from any other source except where due acknowledgment is made explicitly in the text, nor has any part been written for me by another person.
Signed: ........................................................................................... Date: ................................
Learning Outcome Ref
Learning Outcome
Criteria reference
To achieve the criteria the evidence must show that the student is able to:
Met Yes or No
Student Evidence
(Page Nos)
Feedback (dated)
LO1
Understand the features of relational databases
P1
Explain the features of a relational database
P2
Design a relational database for a specified user need
M1
Explain referential integrity and the purpose of primary keys in building the relationships between tables
D1
Discuss how potential errors in the design and construction of a database can be avoided
LO2
Be able to design, create and populate a relational database.
P3
Create and populate a database
P4
Create features in data entry forms to ensure validity and integrity of data
P5
Perform queries using multiple tables and multiple criteria
P6
Include an advanced feature in a database design
M2
Import data from an external source
M3
Export data to an external source
M4
Implement an automated function
Learning Outcome Ref
Learning Outcome
Criteria reference
To achieve the criteria the evidence must show that the student is able to:
Met Yes or No
Student Evidence
(Page Nos)
Feedback
LO3
Be able to test a relational database
P7
Test a relational database
D2
Evaluate a database against the specified user need
Unit 18 - Database Design -