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.
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.
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
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.
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