Database: Design, Create, Populate, and Test

To achieve the criteria the evidence must show that the learner is able to Task none Evidence Create and populate a informationbase SMS 3 Import selective information from an external source Create features in data entry forms to ensure rigour and integrity of data Perform queries using multiple tables and multiple criteria VI Export data to an external source Include an advanced feature in a database design Implement an automated function Test a relational database SMS, RL Discuss how potential errors in the design and construction of a database buttocks be avoided III 4 Evaluate a database against the specified user needLearner Declaration certify that the work submitted for this assignment is my own. I pass on clearly referenced every sources used in the work. I understand that false declaration is a form of malpractice. Learner Signature Title Date Assignment Design, create, populate and depict the features of a relational database. Purpose of this assignment The aim of thi s unit is to enable students to understand the features of relational databases and develop the necessary skills to design, create, populate and study a relational database incorporating advanced features. Task 3 ScenarioImplement the database design from confinement 2 in Microsoft Office Access Task 3 3. 1 Implement the database design from task 2 in Microsoft Office Access by creating at least five tables. Create all the tables as identified in your data exercise Set up relationships and enforce referential integrity to allow cascade updating and deletion of linked records Populate tables with valid and sensible test data Export all table definitions to a Word document This Provides evidence for CPA 3. 2 Create test data in a spreadsheet and import into the pertinent tables. You will need to document each step of this processThis Provides evidence for MM 3. 3 Design and implement all the forms (including at least one sub-form) that have been draw in the Requirements Specific ation (see task 2 in the Systems Analysis and Design assignment). A consistent of style must be used in enounce to create a professional mage to allow users to interact with the system. Your implementation must include at least three features for ensuring data validity. Demonstrate and explain your forms to your coach who will provide a source statement confirming your success. This Provides evidence for CPA 3. 4Perform three different types of queries using multiple tables and multiple criteria to search and sort data that are required from the output requirements (see task 2 in the Systems Analysis and Design assignment). Demonstrate and explain your queries to your tutor who will provide a find statement confirming your success. This Provides evidence for UP 3. 5 Export the results of a query to another application. This Provides evidence for MM 3. 6 Design and implement all the reports that have been outlined in the requirements taking care to ensure consistency in line wit h your form designs.Create a Main Menu form as detailed in the requirements and implement at least one advanced feature. This Provides evidence for MM 3. 7 Demonstrate and explain the process to your tutor who will provide a witness Implement at least one automated feature from the list below Macro Scripts program code This Provides evidence for AS 3. 8 Once you have completed the database, you will need to make sure that the database is working correctly. You are required to create a test plan that tests the main database functionality. Any test failures should be corrected and annotated using screen shots in a est. log.