Sale!
Placeholder

Data Management For The Database Modules Website (65 pages: chapter 1-7)

15,000 5,000

Topic Description

 ALL listed project topics on our website are complete material from chapter 1-5 which are well supervised and approved by lecturers who are intellectual in their various fields of discipline, documented to assist you with complete, quality and well organized researched materials. which should be use as reference or Guild line...  See frequently asked questions and answeres



Summary


The overall aim of this project is to analyse the problems and needs of the DB Modules teaching staff with regard to the management of the modules’ data, then to re-design and produce a web based solution that will replace the current system. The motivation for this is to improve the efficiency and eradicate the failings of the current system.
This was achieved by setting the following objectives:
• To gather requirements from the teaching staff on which to base the data management system.
• To conduct a functional dependency analysis on each of the tables in the current database and re-design where necessary.
• To re-write the SQL for the current front end of the web site.
• To implement and evaluate a new web-based data entry interface that replaces the current functionality of the Access-based system.
On completion of the project several goals were achieved. A complete working system was created which met the requirements of the users. Enhancements over the current system were implemented and the minimum requirements surpassed. The main stages of the project are outlined in the report that follows.
In addition to the system that was created, the project helped me gain a better understanding of databases and active server pages and was invaluable in enhancing my project management skills.

Chapter 1 – INTRODUCTION
1.1 BACKGROUND
The University of …….. Computing department has been providing on-line resources in support of its DB (Database) modules for several years. These resources present information on lectures, lecturers, reading and events, and also offer lectures slides for the School of Computing DB modules. The
existing system uses a database implemented in SQL Server to store the module information, which is managed via a rather basic Access 2000 front end. Active Server Pages, with the aid of SQL code, are used to obtain the information required from the database and produce the web pages. Currently the tables are not fully normalised and therefore not ideal when inputting and extracting data. This deficiency requires an analysis and possible re-design of the database. The front end is also far from perfect. With the front end being implemented in Access, the current system requires Access to be open when modifying the data and a browser to also be open. A browser is required to confirm that the modifications are working correctly with the web pages. It would be much simpler to have a browser-based front end to manage the data. The requirements of the new system are to enhance the design of the database so that it is easier to update and interact with. The process of updating the database and then inspecting the changes on the web needs to be improved so that it is easier and less time consuming than the current system. The new system should also improve the appearance and functionality of the current front-end.


1.2 OBJECTIVES
After an initial meeting with the ‘problem owner’, Stuart Roberts, the following set of objectives were agreed upon:
• To gather requirements from the teaching staff on which to base the data management system.
• To conduct a functional dependency analysis on each of the tables in the current database and re-design where necessary.
• To re-write the SQL for the current front end of the web site.
• To implement and evaluate a new web-based data entry interface that replaces the current functionality of the Access-based system.

]]>

GET COMPLETE MATERIAL

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.