Part 1
Before you start the development process, your manager has asked you to produce a report for the CEO of Double Pane, containing:
1. The design of the relational database system using appropriate design tools and techniques. It should contain at least four interrelated tables.
2. Clear statements of user and system requirements.
You would prefer to produce a more detailed document, so you will produce a comprehensive design for a fully functional system which will include interface and output designs, data validations and cover data normalisation.
Your manager would like a separate report on your assessment of the effectiveness of the design in relation to user and system requirements.
Part 2
Once the designs have been accepted by your manager you have been asked to develop the database system using evidence of user interface, output and data validations and querying across multiple tables.
You want to include more than just the basics so you will implement a fully functional database system which will include system security and database maintenance features.
You have decided to implement a query language into the relational database system.
The developed system will be demonstrated to your manager.
Your manager has asked you to produce a report:
1. Assessing whether meaningful data has been extracted through the use of query tools to produce appropriate management information.
2. Evaluating the effectiveness of the database solution in relation to user and system requirements, and suggest improvements.
Part 3
Once the system has been developed, you will test the system and your manager will complete a witness statement indicating how your tests are performing against user and system requirements.
You will produce a brief report assessing the effectiveness of the testing, including an explanation of the choice of test data used.
Your report should also assess any future improvements that may be needed to ensure that the database will continue to be effective.
Lastly you will produce technical and user documentation which will be given to the company.
You want to provide some graphical representations for ease of reference in the technical guide, so you have decided to produce a technical and user documentation for a fully functional system, including diagrams showing movement of data through the system, and flowcharts describing how the system works.