Design and implement a relational database for a local print

Assignment Help Database Management System
Reference no: EM132124083

Database Design & Development Assignment -

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

Learning Outcome -

  • Use an appropriate design tool to design a relational database system for a substantial problem.
  • Develop a fully functional relational database system, based on an existing design.
  • Test the system against user and system requirements.
  • Produce technical and user documentation.

Purpose of this assignment - The work undertaken in this assignment should be used to design, implement, test and document a database solution to a given business problem.

Scenario -

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. 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.
  • User interface design and design of any reports that are needed for output to the user.
  • A report assessing the effectiveness of the design in relation to user requirements.

You should include any additional design documentation that you feel will support the development of your database.

Task 2 -

Develop a fully functional database using Access based on the design you carried out in Task 1. This should include:

  • A fully functional database in line with your design documentation. This database should incorporate all the queries required in the specification.
  • Security and database maintenance procedures as part of your database build.
  • A report assessing whether meaningful data was obtained from the queries you implemented in task 1.
  • A report evaluating the effectiveness of your database solution.

You may be asked to demonstrate your database as part of the marking process.

Task 3 -

Develop a robust test plan. This should include:

  • 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.
  • A report assessing the effectiveness of your testing including an explanation of your choice of test data.

Task 4 -

Develop technical/user documentation. This should include:

  • 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.
  • Diagrams showing the flow of data through the system and flowcharts describing how the system works.
  • A report assessing any future improvements to the database which would ensure that your system remains robust and relevant.

Reference no: EM132124083

Questions Cloud

Using intellectual property protection mechanisms : What are the costs and benefits of using intellectual property protection mechanisms?
Describe tracking metrics : Describe the business situation, including the macro-environmental and microenvironmental conditions facing the organization.
Template-based data found in electronic health record : Describe template-based data found in the electronic health record.
Ethics is now very important in the global environment : Due to issues in international business such as the case of Enron, ethics is now very important in the global environment.
Design and implement a relational database for a local print : Database Design & Development Assignment, Bradford College UK. Design and Implement a Relational Database for a local Print and Ink Refill Business
Discuss a theme of the work illustrated in the quote : For each quote, you must do three things: 1. Identify work and author; 2. Discuss a theme of the work illustrated in the quote.
CISG cannot be applied to in settlement of disputes : Buyer argues that the law of the US has been specifically mentioned in the contract and hence the CISG cannot be applied to in the settlement of disputes.
What is the root cause of lorettas problem : "Loretta marched in here thinking she knows everything. She doesn't want to listen to any of our ideas. It's her way or the highway."
Elvira is an abstract painter with incredible talent : Elvira is an abstract painter with incredible talent but little fame. Is there anything that Elvira can do? Explain.

Reviews

len2124083

9/27/2018 2:03:56 AM

In this assessment you will have the opportunity to present evidence that shows you are able to: Design a relational database system using appropriate design tools and techniques containing at least four interrelated tables, with clear statements of user and system requirements. Produce a comprehensive design for a fully functional system which includes interface and output designs, data validations and data normalisation. Assess the effectiveness of the design in relation to user and system requirements. Develop the database system with evidence of user interface, output and data validations, and querying across multiple tables.

len2124083

9/27/2018 2:03:50 AM

Implement a query language into the relational database system. Implement a fully functional database system which includes system security and database maintenance. Assess whether meaningful data has been extracted through the use of query tools to produce appropriate management information. Evaluate the effectiveness of the database solution in relation to the user and system requirements and suggest improvements. Test the system against user and system requirements.

len2124083

9/27/2018 2:03:43 AM

Assess the effectiveness of the testing, including and explanation of the choice of test data used. Evaluate the effectiveness of the database solution in relation to the user and system requirements and suggest improvements. Produce technical and user documentation. Produce technical and user documentation for a fully functional system including diagrams showing the movement of data through the system and flowcharts describing how the system works. Assess any future improvements that may be required to ensure the continued effectiveness of the database system.

len2124083

9/27/2018 2:03:38 AM

Evidence checklist - Summary of evidence required by student - Your 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. If you create hand drawn diagrams, plans or sketches etc. for the design task, these should be scanned, saved as a suitable image file and included electronically as part of a word-processed document. Task 1 The planning documentation for your database saved as single word-processed file. Task 2 Your completed database. Task 3 A single word-processed report that documents the testing processes that you carried out. Task 4 Your completed user guide.

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd