To achieve a pass grade To achieve a merit grade To achieve a distinction the evidence must show the evidence must show grade the evidence must that the learner is able to: that, in addition to the show that, in addition to pass criteria, the learner the pass and merit is able to: criteria, the learner is able to: D1 Discuss how potential errors P1 Explain the features of a M1 Explain referential relational database integrity and the purpose of in the design and construction of primary keys in building the a database can be avoided relationships between tables P2 Design a relational database for a specific need P3 Create and populate a M2 Import data from an database external source P4 Create features in data entry forms to ensure validity and integrity of data P5 Perform queries M3 Export data to an external multiple tables and multiple source criteria P6 Include an advanced M4 Implement an automated feature in a database design function P7 Test a relational database D2 Evaluate a database against the specific need Scenario: You have been asked to computerize a veterinary practice. They are still using paper for most of their records. After discussing their requirements you have decided to implement a database in MS Access. You have been given copies of their paper records (on wiki under Unit 18) and a file of their current customers (Customer text File on wiki Unit 18). You have agreed to provide the following main functions: Adding and editing animals and owners Making appointments Recording treatments and prescriptions Printing prescriptions Printing a bill for the consultation, treatments and drugs Creating mailing lists for reminder letters of annual check ups A user interface will be provided hides and protects the database structure from the end user, as well as being easy to use All data entered by the user should be validated prior to being saved in the
To achieve a pass grade the evidence must show that the learner is able to: To achieve a merit grade the evidence must show that, in addition to the pass criteria, the learner is able to: To achieve a distinction grade the evidence must show that, in addition to the pass and merit criteria, the learner is able to: P1 Explain the features of a relational database 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 P2 Design a relational database for a specific need P3 Create and populate a database M2 Import data from an external source P4 Create features in data entry forms to ensure validity and integrity of data P5 Perform queries multiple tables and multiple criteria M3 Export data to an external source P6 Include an advanced feature in a database design M4 Implement an automated function P7 Test a relational database D2 Evaluate a database against the specific need Scenario: You have been asked to computerize a veterinary practice. They are still using paper for most of their records. After discussing their requirements you have decided to implement a database in MS Access. You have been given copies of their paper records (on wiki under Unit 18) and a file of their current customers (Customer text File on wiki Unit 18). You have agreed to provide the following main functions: Adding and editing animals and owners Making appointments Recording treatments and prescriptions Printing prescriptions Printing a bill for the consultation, treatments and drugs Creating mailing lists for reminder letters of annual check ups A user interface will be provided hides and protects the database structure from the end user, as well as being easy to use All data entered by the user should be validated prior to being saved in the
unit18assignment022014.docx