Database Design & Development - Technical and User Documentation - IT Assignment Help

Assignment Task:

Unit Learning Outcomes:
LO1 Use an appropriate design tool to design a relational database system for a substantial problem.
LO2 Develop a fully functional relational database system, based on an existing system design. 
LO3 Test the system against user and system requirements. 
LO4 Produce technical and user documentation

Assignment Brief and Guidance:
You are employed as a Database Developer for a large IT consultancy company. The company has been approached by FPT university which is expanding due to the growth of the number of students. FPT is currently facing difficulties in dealing with managing the university. It decided to develop several academic systems to manage the university easier including: Online Library system, Student Grading System, Attendance System, CMS System, Scheduling System, Enrolment Systems, and so on.

You are tasked to select one of those systems to develop a database for FPT university. Your tasks are to:

Work with FPT to find out about current requirements for each system
Analyze the requirements and produce clear statements of user and system requirements.
Design a relational database system using appropriate design tools and techniques
Develop a fully functional relational database system, based on an existing system design.
Test the system against user and system requirements. 
Produce technical and user documentation

Part 1 (assignment 1)
Before you start the development process, your manager has asked you to produce a report for the CEO of FPT, containing:
1. Clear statements of user and system requirements. 
2. The design of the relational database system using appropriate design tools and techniques. It should contain at least four interrelated tables.

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 lik on the report your assessment of the effectiveness of the design in relation to user and system requirements.

Part 2 (Assignment 2)

Once the designs have been accepted by your manager you have been asked to:
1. 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 include in the report:
2. Assessing whether meaningful data has been extracted through the use of query tools to produce appropriate management information.
3. Evaluating the effectiveness of the database solution in relation to user and system requirements, and suggest improvements.
4. 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.
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.

This IT Assignment has been solved by our IT Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.