Whitechapel College BTEC Higher National Diploma in Computing and System Development Student Name Syed Tufayel Ahmed Student No. 0000680 Assessor Unit 33 Data Analysis and Design Unit Code: Handout Date Submission Date Student Declaration: I certify that the work submitted for this assignment is my own. Where the work of others has been used to support my work then credit has been acknowledged. Signature: Date: Assessor Comments: Student Comments: Sign&Date: Grade Date Assessor Sign Internally Verified (Y/N) Internal Verifier Sign Date
Assessment Grid indicating their pass, merit and distinction Unit Outcomes Outcome Evidence for the criteria to pass. Feedback Assessor’s Decision LO1. Understand data models and database technologies. i. Critically compare different data models and schemas. Choose the best model for your database. Present your comparison in appropriate format. [M3] ii. Critically discuss the benefits and limitations of different database technologies. [P2] iii. Analyse different approaches to database design. [P3] iv. Examine database tools and techniques. [P4] LO2. Be able to design and implement relational database systems. i. Create system requirements documentation for database development. [P5]
ii. Design a relational database system to meet a given requirement. [M2] iii. Identify and apply a range of database tools and techniques to build the relational database system based on the system requirements specification with enhanced user interface. [M1] LO3. Be able to use manipulation and querying tools. i. Explain the benefits of using manipulation and query tools in a relational database system. [P8] ii Implement query language into your relational database system and generate appropriate reports and queries. Provide one sample query. [P9] iii. Critically evaluate how meaningful data has been extracted through the use of query tools. [D1]
LO4. Be able to test and document relational database systems. i. Apply all testing procedures to critically review and test your relational database system and take responsibility to control the quality of the product. [D2] ii. Create documentation to support the implementation and testing of a relational database system. [P12] iii. Create user documentation for a developed relational database system. [P13] iv. Explain how verification and validation has been addressed in your system. [P14] v. Explain how control mechanisms have been used. [P15]
vi. Demonstrate convergent, lateral and creative thinking in relational database system development. [D3] MERIT Grades M1 M2 M3 DISTINCTION Grades D1 D2 D3 Grade Awarded Internal Verifier Comments: Internal Verifier Name: Sign : Date:
QCF Level 5 BTEC Higher National Unit 33: Data Analysis and Design Unit Code: H/601/1991 Credit Value:15 Aim: To provide learners with the knowledge and skills needed to understand, design, query and implement database systems.
You've reached the end of your free preview.
Want to read all 13 pages?
- Spring '16
- Relational Database