Data Analysis and Design-Btechnd Assignment

Achievement Summary
Criteria:Achieved: (Y/N)Feedback and advice for improvement:
P3

P3.1 explain the benefits of using manipulation and query tools in a relational database system

P3.2 implement a query language into the relational database system

P3.3 critically evaluate how meaningful data has been extracted through the use of query tools

P4P4.1 critically review and test a relational database system

P4.2 create documentation to support the implementation and testing of a relational database system

P4.3 create user documentation for a developed relational database system

P4.4 explain how verification and validation has been addressed

P4.5 explain how control mechanisms have been used

M2select/design and apply appropriate methods/techniques

 

Complex information/data has been synthesised and processed

M3present and communicate appropriate findings

 

The communication is appropriate for familiar and unfamiliar audiences and appropriate media have been used

D2

take responsibility for managing and organising activities

The importance of interdependence has been recognised and achieved

 

Quality of work including spelling, grammar, punctuation, vocabulary and referencing:
General comments including commitment, effort and advice for improvement:
Assessor’s signature:Date:
Referral Date (if appropriate): 
Assessment and Grading Criteria

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

Understand data models and database technologies

P1.1 critically compare different data models and schemas

P1.2 critically discuss the benefits and limitations of different database technologies

P1.3 analyse different approaches to database design

M1

identify and apply strategies to find appropriate solutions

 

Complex problems with more than one variable have been explored

 

D1

use critical reflection to evaluate own work and justify valid conclusions

 

Conclusions have been arrived at through synthesis of ideas and have been justified

P2

Be able to design and implement relational database systems

P2.1 design a relational database system to meet a given requirement

P2.2 build a relational database system based on a prepared design

P2.3 apply a range of database tools and techniques to enhance the user interface

M2

select/design and apply appropriate methods/techniques

 

Complex information/data has been synthesised and processed

D2

take responsibility for managing and organising activities

 

The importance of interdependence has been recognised and achieved

P3

Be able to use manipulation and querying tools

P3.1 explain the benefits of using manipulation and query tools in a relational database system

P3.2 implement a query language into the relational database system

P3.3 critically evaluate how meaningful data has been extracted through the use of query tools

M3

present and communicate appropriate findings

 

The communication is appropriate for familiar and unfamiliar audiences and appropriate media have been used

D3

Demonstrate convergent/lateral/creative thinking

Problems have been solved

P4

Be able to test and document relational database systems

P4.1 critically review and test a relational database system

P4.2 create documentation to support the implementation and testing of a relational database system

P4.3 create user documentation for a developed relational database system

P4.4 explain how verification and validation has been addressed

P4.5 explain how control mechanisms have been used

 

Assignment 1
Assignment 2
Scenario

Mitch’s Motors is a small car garage which fixes small and large vehicles for the general public as well as having contracts with large organisations such as Parcel Power and Rent-A-Motor where vehicles are repaired for a discounted rate.

When customers bring in their car for work to be carried out, all their details are taken down and transferred to a job sheet manually even if they have visited the garage before. Also enterprise customers usually have various vehicles and a separate job sheet is collected for each job and vehicle.

Mitch is unable to easily see the past history of customers and how much they have spent with the company. Also if people phone up to enquire about work they have booked in or for quotes on work, it is often hard to work out how much they have spent with the company or agree to larger discounts by enterprise customers.

Sometimes quotes for work are based on guesswork of how much parts will cost and when it comes to ordering the parts after accepting the work, the parts can be unavailable or cost more than was estimated. This can leave Mitch with the difficult decision of whether to re-negotiate or suffer a loss on that particular job.

Normally when an engineer takes on a job, they retrieve the job sheet from the filing cabinet and go and begin working on the car. Sometimes if an engineer is off work on a particular day, when a customer is enquiring, they have to wait until the engineer is back to have their question answered. In addition to this, job sheets can go missing meaning details of the work needed is lost as well as the price that was agreed.

After various complaints from angry customers and increasing completion and aggressive marketing from rival garages Mitch realises he needs to modernise and has hired you to develop a computerised system to replace the paper-based systems and he hopes the system will offer the following features:

·        Store details of all customers and their cars and allow easy searching by name, reg number, post code, etc.

·        Offer family discounts if 2 or more family members bring their own car in for work

·        Allow an individual discount for all enterprise customers

·        Allow engineers to post progress updates on work being carried out on vehicles

·        Store all history of previous work on a particular car

·        Allow instant quotes to be generated including cost of parts, availability of parts from suppliers, cost of labour, etc.

·        When customers phone, email or visit in person it will be possible to quickly tell the status of their job/s by their member number, name or registration number

They would also like a Web presence where customers can book appointments to come in and have their cars looked at and track the status of their repairs. This will be a separate system but will need to interface with the office system so the two systems remain in sync with each other.

Task 1
Explain the benefits of using manipulation and query tools in a relational database system in order to show how using them will help satisfy Mitch’s requirements. (P3.1)

 

Implement SQL into the relational database system you built by creating the following queries:

 

a)      Display all the customers who have work scheduled today that is not yet completed and what the work is with the engineer it is assigned to

b)      Find the engineers with free slots on a given date

c)       List only the customers who have made complaints in the past and not had any work done for the past year with their contact details

(P3.2)

 

Critically evaluate how meaningful data have been extracted through the use of query tools.How does this help to satisfy the requirements given in the scenario? (P3.3)

 

Task 2
Critically review and test your relational database system by entering test data and ensuring these can be correctly recorded in your system. (P4.1)

 

Create documentation to support the implementation and testing of your relational database system. This could include, for example,test plans, test models, etc. (P4.2)

 

Create user documentation for the relational database system you developed. This could include help documentation for the end user ora technical manual for a developer who will continue your project. (P4.3)

 

Explain how verification and validation has been addressed in your database to ensure a quality system has been produced, free from problems and bugs. (P4.4)

 

Explain how control mechanisms have been used to ensure a secure, well-managed system has been produced which complies with any data protection policies. (P4.5)

 

Task 3
Select/design and apply appropriate methods/techniques to enable the system to be easily interrogated by staff by producing additional functionality in addition to the queries produced in P3.2.Ensure that complex information/data has been synthesised and processed.(M2)

 

Present and communicate appropriate findings from M2 explaining the purpose and functionality of each query, function, procedure, etc. you have produced. Ensure that the communication is appropriate for familiar and unfamiliar audiences and appropriate media has been used which must include a PowerPoint presentation.(M3)

 

Task 4

Take responsibility for managing and organising activities in the construction of various parts of the interface, expanding on the initial interface you worked on in P2.3 from Assignment 1.Make sure that the importance of interdependence has been recognised and achieved throughout the system and the functionality is suitable and consistent.(D2)

Evidence Checklist

(Maximum suggested word count is 4,000 words)

Task 1:Report¨
Task 2:Report¨
Task 3:Report& PowerPoint¨
Task 4:Report¨
References / Resources
 

Books

 

·         Avison D and Fitzgerald G – Information Systems Development: Methodologies, Techniques andTools (McGraw Hill Higher Publishing Company, 2006) ISBN 0077114175

·         Chao L – Database Development and Management (CRC Press, 2006) ISBN 0849392381

·         Connolly T and Begg C – Database Systems: A Practical Approach to Design, Implementation andManagement (Addison Wesley, 2004) ISBN 0321210255

·         Howe D – Data Analysis for Database Design (Butterworth-Heinemann Ltd, 2001)ISBN 0750650869

·         Kroenke D – Database Concepts, 2nd Edition (Prentice Hall, 2004) ISBN 0131451413

·         Ponniah P – Database Design and Development: An Essential Guide for IT Professionals: VisibleAnalyst Set (John Wiley & Sons Inc, 2006) ISBN 0471760943

·         Ritchie C – Relational Database Principles (Thomson Learning, 2002) ISBN 0826457134

 

 

Websites

 

·         http://geekgirls.com/category/office/databases/

Assignment Answers
Task 1 – P3.1

Explain the benefits of using manipulation and query tools in a relational database system in order to show how using them will help satisfy Mitch’s requirements.

Task 1 – P3.2

Implement SQL into the relational database system you built by creating the following queries:

a)    Display all the customers who have work scheduled today that is not yet completed and what the work is with the engineer it is assigned.

b)   Find the engineers with free slots on a given date

c)    List only the customers who have made complaints in the past and not had any work done for the past year with their contact details

Task 1 – P3.3

Critically evaluate how meaningful data have been extracted through the use of query tools. How does this help to satisfy the requirements given in the scenario?

Task 2 – P4.1

Critically review and test your relational database system by entering test data and ensuring these can be correctly recorded in your system

Task 2 – P4.2

Create documentation to support the implementation and testing of your relational database system. This could include, for example, test plans, test models, etc.

Task 2 – P4.3

Create user documentation for the relational database system you developed. This could include help documentation for the end user or a technical manual for a developer who will continue your project.

Task 2 – P4.4

Explain how verification and validation has been addressed in your database to ensure a quality system has been produced, free from problems and bugs.

Task 2 – P4.5

Explain how control mechanisms have been used to ensure a secure, well-managed system has been produced which complies with any data protection policies.

Order Now

Leave a Reply

Your email address will not be published.

1 Step 1
GET INSTANT ASSIGNMENT HELP BY PHD EXPERTS FROM UNITED KINGDOM
keyboard_arrow_leftPrevious
Nextkeyboard_arrow_right