Do My MS Access Assignment with ERD

Question - Bradford College QualificationUnit number and titleBTEC HND Computing and Systems DevelopmentUnit 33: Data Analysis and DesignStudent name and numberAssessor nameSophia MianDate issuedCompletion dateSubmission detailsThursday 24th October 2013Friday 13 December 2013All files compressed into a single rar or zip file and uploaded to Moodle no later than 1600. Assignment titleDesign and Implement a Takeaway Restaurant Relational Database (Assignment 2 of 2)Learning OutcomeOutcomeAssessment CriteriaIn this assessment you will have the opportunity to present evidence that shows you are able to:Task no.e (Page no)LO2Be able to design and implement relational database systems2.1Design a relational database system to meet a given requirement2.2Bui ...Read More ld a relational database system based on a prepared design2.3Apply a range of database tools and techniques to enhance the user interfaceLO3Be able to use manipulation and querying tools3.1Explain the benefits of using manipulation and query tools in a relational database system.3.2Implement a query language into the relational database system

achieve the following Merit and Distinction grades: tools3.3Critically evaluate how meaningful data has been extracted through the use of query toolsLO4Be able to test and document relational database systems4.1Critically review and test a relational database system4.2Create documentation to support the implementation and testing of a relational database system4.3Create user documentation for a developed relational database system4.4Explain how verification and validation has been addressed4.5Explain how control mechanisms have been usedGrade DescriptorIndicative CharacteristicsContextualisationM2Select/design and apply appropriate methods/techniques•Relevant theories and techniques have been appliedA range of methods and techniques have been appliedTo achieve M2, you should demonstrate that the theories, concepts, tools and techniques that you researched in the first part of this assignment have been practically applied in the production of a functional database that accurately meets the given specification.D2Take responsibility for managing and organising activities•Activities have been managedTo achieve D2 you should provide evidence of an ability to design, develop and test a database in a coherent and structured way. There should be a direct and coherent relationship between your research, your planning and your implementation.D3Demonstrate convergent/lateral/creative thinking•Problems have been solvedproduce testing documentation that offers a clear and full technical explanation of any problems encountered and the steps taken to arrive at a solution. Learner declaration

I certify that the work submitted for this assignment is my own and research sources are fully acknowledged. Student signature: Date: Assignment briefUnit number and titleUnit 33: Data Analysis and DesignQualificationBTEC HND Computing and Systems DevelopmentStart dateThursday 24th October 2013Deadline/hand-in Friday 13 December 2013AssessorSophia MianAssignment titleDesign and Implement a Takeaway Restaurant Relational Database (Assignment 1 of 2)Purpose of this assignment carry out research and analysis into a range of database models and database technologies. The work undertaken in this part of the assignment should now be used to design, implement, test and document a database solution to a given business problem.Scenario a delivery schedule. The system should be able to input the customer details and the required order, and from this generate an invoice and item billing. It would be useful if the system could identify frequent customers and provide them with discounts and bargains for their customer loyalty. The delivery route could also be generated for a satellite navigation system from the post codes provided so that a number of deliveries could be planned over an optimised route for the driver, as this would shorten the times for delivery and reduce fuel consumption of the vehicle. could be generated by the system when items reach a minimum stock level, thereby providing a margin of time for him to re-order before running out completely. provide weekly and monthly earnings. This would help the manager identify trends in his business and indicate possible requirements to advertise and market special offers through brochures and leaflet delivery. requirements. As the manager and staff are not technical people, they will need the use of an attractive and “easy to use” interface for the system. Having built the system, you will also need to provide a technical user guide on how to install, maintain and use the system.

Task 1 (Learning outcome 2.1, 4.4) specification. As a minimum this should include: An Entity Relationship Diagram •A Data Dictionary for each entity (with data normalised to Third Normal Form) showing data types selected. •Details of how you will validate and verify data your database.Task 2 (Learning outcomes 2.2, 2.3 ) You may be asked to demonstrate your database as part of the marking process. that your database will offer the businessTask 3 (Learning outcomes 4.1, 4.2,) and the expected outcome. Your documentation should indicate where the expected outcome was not met and the actions taken to resolve the problems.Task 4 (Learning outcomes 3.1, 3.3, 4.3, 4.5) user guide should start with an overview of the database an explanation of how the queries and data manipulation processes that you have implemented will produce information of benefit to the business Evidence checklistSummary of evidence required by studentEvidence presentedYour work for all four tasks should be compressed into a single rar or zip file. You should ensure that this file contains a folder structure and uses appropriate file and folder names to allow the marker to easily access your work for each task. saved as a suitable image file and included electronically as part of a word-processed document. Task 1The planning documentation for your database saved as single word-processed file. Task 2Your completed database.

A single word-processed report that documents the testing processes that you carried out. Task 4Your completed user guide.

Achievement Summary QualificationBTEC HND Computing and Systems DevelopmentSophia MiantitleUnit 33: Data Analysis and Designand numberCriteria ReferenceTo achieve the criteria the evidence must show that the student is able to:Achieved? (tick)LO2Be able to design and implement relational database systems2.1Design a relational database system to meet a given requirement2.2Build a relational database system based on a prepared design2.3Apply a range of database tools and techniques to enhance the user interfaceLO3Be able to use manipulation and querying tools3.1Explain the benefits of using manipulation and query tools in a relational database system.3.2Implement a query language into the relational database system3.3Critically evaluate how meaningful data has been extracted through the use of query toolsLO4Be able to test and document relational database systems4.1Critically review and test a relational database system4.2Create documentation to support the implementation and testing of a relational database system4.3Create user documentation for a developed relational database system4.4Explain how verification and validation has been addressed4.5Explain how control mechanisms have been used(tick)(tick)M1: Identify and apply strategies to find appropriate solutions D1: Use critical reflection to evaluate own work and justify valid conclusions

Assignment Feedback appropriate methods / techniques D2: Take responsibility for managing and organising activitiesM3: Present and communicate appropriate findings D3: Demonstrate convergent/lateral/creative thinkingFormative Feedback: Assessor to Student

Summative feedback ...Read Less

Solution Preview - No Solution Preview Available

Original Question Documents

N/A