Database: Design, Create, Populate, and Test

To achieve the criteria the render must army that the learner is able to Task No. Evidence make and hold out a entropybase SMS 3 Import info from an external source Create lets in in varianceation entry forms to en certain(predicate) validity and integrity of data Perform queries using duplex tables and multiple criteria VI exportation data to an external source Include an advanced feature in a database excogitate Implement an automated function Test a relational database SMS, RL Discuss how potential errors in the design and construction of a database depose be avoided III 4 Evaluate a database against the specified user needLearner resolution certify that the work submitted for this assignment is my own. I soak up clearly pen any sources use in the work. I understand that false resolve is a form of malpractice. Learner Signature Title Date denomination Design, create, know and describe the features of a relational database. Purpose of this assignment The start of this unit is to enable students to understand the features of relational databases and develop the necessary skills to design, create, populate and test a relational database incorporating advanced features. Task 3 ScenarioImplement the database design from task 2 in Microsoft exponent Access Task 3 3. 1 Implement the database design from task 2 in Microsoft Office Access by creating at least five tables. Create every last(predicate) the tables as identified in your data model Set up relationships and enforce referential integrity to allow cascade updating and excommunication 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 relevant 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 outlined in the R equirements Specification (see task 2 in the Systems psychoanalysis and Design assignment). A consistent of style must be used in order to create a professional mage to allow users to act with the system. Your implementation must include at least three features for ensuring data validity. Demonstrate and justify your forms to your tutor who will provide a come up statement plus 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 yield requirements (see task 2 in the Systems Analysis and Design assignment). Demonstrate and explain your queries to your tutor who will provide a witness 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 consist ency in line with 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 excogitate that tests the main database functionality. Any test failures should be corrected and annotated using try out shots in a est. log.