Data Analysis and Design - Design and Implement a Relational Database for a local Print and Ink Refill Business

Qualification - BTEC Higher National Diploma in Computing and System Development

Unit number and title - Unit 33 Data Analysis and Design

QFC Level - Level 5

Unit Code - H/601/1991

Assignment title - Design and Implement a Relational Database for a local Print and Ink Refill Business

Purpose of this assignment

This is the second part of a two-part assignment. In the first part of Data Analysis and design assignment, you are asked to 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.

A local printing and ink refill business requires a method of recording telephone orders from customers (business and individual) to create 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.

The manager is considering how the order system could tie in with the stock control so that warnings 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.

It would also be useful for the business to keep a running total of takings for each day of business, and 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.

You are required to design, implement and test a relational database that will meet the above 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
Develop design documentation that will enable you to develop a database that meets the above 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, and the appropriate validations required.

Details of how you will validate and verify data
You should include any additional design documentation that you feel will support the development of your database.

Task 2
Use appropriate software to develop a fully functional database in line with your design documentation. You may be asked to demonstrate your database as part of the marking process. that your database will offer the business

Task 3
Produce testing documentation for your database that shows what is to be tested, the testing criteria 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
Produce a user guide that will allow the take away owner to install, maintain and use the system. Your 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

LO2 Be able to design and implement relational database systems
2.1 Design a relational database system to meet a given requirement
2.2 Build a relational database system based on a prepared design
2.3 Apply a range of database tools and techniques to enhance the user interface

LO3 Be able to use manipulation and querying tools
3.1 Explain the benefits of using manipulation and query tools in a relational database system.
3.2 Implement a query language into the relational database system
3.3 Critically evaluate how meaningful data has been extracted through the use of query tools

LO4 Be able to test and document relational database systems
4.1 Critically review and test a relational database system
4.2 Create documentation to support the implementation and testing of a relational database system
4.3 Create user documentation for a developed relational database system
4.4 Explain how verification and validation has been addressed
4.5 Explain how control mechanisms have been used







Are You Looking for Relational Database Assignment Help?

Are you Looking for BTEC Higher National Diploma in Computing and System Development Assignment Help?

Have unsolved Unit 33 Data Analysis and Design assignment and need qualified writers for QFC Level - Level 5, Unit Code - H/601/1991 assignment help?

Assignment title - Design and Implement a Relational Database for a local Print and Ink Refill Business

 Do you need a book report or a research paper? At Miracleskills, you can get any kind of paper. We began our administration with the reason to give a wide range of assignment help services covering all the courses taught at the UK based university. We have experts with degrees from the UK's top notch universities. We can deal with any point. Simply make a point to pick the right specialty in the request structure! 

In the event that you are worried and have no opportunity to compose your paper, simply recall that help is here. Our expert writers are prepared to assist you with the majority of your paper-composing needs! We are the main, article composing administration picked by UK understudies! See with your own eyes how the most experienced, custom-composing administration in UK can assist you with your assignments. 

We can convey any sort of paper you need. Every single request is shrouded by a specialist in a pertinent branch of knowledge. We've employed proficient writers with degrees in Relational Database. Thereby, under our Relational Database Assignment Help, we compose write-ups like:- 

  • Assignments 
  • Custom paper 
  • Research paper 
  • Case study
  • Essay
  • Thesis 

Relational Database is a lot of officially portrayed tables from which information can be gotten to or reassembled from numerous points of view without revamping the database tables. The standard client and application programming interface (API) of a social database is the Structured Query Language (SQL) 

There are a couple of things that keeps on popping up in the minds of the students like inadequate availability of the time, poor understanding of the subject, occupied with a number of activities like internships, part-time jobs, etc, heavy burden of meeting the finances like the educational cost charges, books, scholastic records, lodging expenses, mess charges, and so on. After all these, it turns out to be about outlandish for the understudies to pay for the task help administrations. 

Recollecting this, our expenses are set to a flat out least so when an understudy enrolls for our Relational Database Assignment Help, by then he would get more affordable organizations, yet furthermore premium quality reviews. Other than being pocket all around arranged, our Experts under, Relational Database Assessment Help are open constant to give all out assistance in light of the fact that an academic emergency may strike whenever of time paying little mind to what time it is, regardless of whether it's day or night. With a notoriety of serving countless understudies, our Relational Database Assignment Help is acclaimed, over 98.7 percent understudies are content with our organizations and we have been getting referrals all the time endorsed by our standard understudies. Along these lines, if you are looking for scanning for premium quality Relational Database Assignment Help, by then we should be your choice. Plus, you'll get moderate errand help, anyway you'll in like manner acknowledge phenomenal features each time as seeks after; 

The reviews under Relational Database Assignment Help will be 100 percent one of a kind, copyright encroachment free and etymologically right. Our reviews under Relational Database Assignment Help will agree to the time limitation, making it without question that there is no deferment from our side. Endless amendments is a cool and strong factor under Relational Database Assessment Help, thereby one can avail as many reviews as he wishes and for these we won't charge anything extra.  We understand the significance of the credibility of the write-ups, thereby; our reviews under Relational Database Assignment Help are set up from valid, invigorated and genuine references. 

We in like manner give free Formatting of the reviews under, Relational Database Assignment Help paying little heed to what gathering is required. Further, paying for organizations is too much straightforward and totally secure. 


We are sure by now you would have understood the way we can help you achieve your academic goals, thereby under our Relational Database Assignment Help, we have set up an excellent plan to assist you in all terms and conditions. All you need to do is simply, fill in the details asked in the order form available over our site and based upon your inquiry we will provide you best suitable quotation.