Riverdale book library database application

Undertaking Title

Riverdale book library database application

Hire a custom writer who has experience.
It's time for you to submit amazing papers!


order now

Undertaking Brief Description

Riverdale Greaves Vanderpuyle ( RGV ) Limited is a private library headquartered in Accra, Ghana. It specializes in leasing out books to its member clients. The first subdivision of RGV Ghana was established in 1990 in Accra Ghana, but the company has now grown and has many subdivisions throughout West Africa.

The company ‘s success is due to the first-class services it provides to its members and the varied stocks of books available for rent. RGV Limited presently has about 500 staff working in 20 subdivisions.

Each subdivision of RGV has a stock of books for hire or rent. Each book point is unambiguously identified utilizing a catalogue figure. However, in most instances, there are several transcripts of each point at a subdivision, and the single transcripts are identified utilizing the index figure.

s RGV has grown, so hold the troubles in pull offing the increasing sum of informations used and generated by the company. To guarantee the continued success of the company ‘s operations, the Directors of RGV Limited have desperately requested that a database system be designed to assist work out the increasing jobs of informations direction. The undermentioned demands were besides identified:

Functional Requirements

  • Enable users to add, alter delete and interrogate records in the undermentioned files: Customers and Books maestro files.
  • Enable user to bring forth bills to be sent to clients.
  • Produce a study demoing clients who have non paid their measures within 30 yearss.
  • bring forth a hard currency flow of the existent income generated.
  • Produce a hard currency flow of proposed income generated.

As a database adviser and developer, it is required that an analysis an on the library application sphere be performed, and d effectual database scheme that will back up the production of the above functional demands, designed, utilizing the appropriate tools and diagrams.

Project Scope

The undertaking aims to bring forth a database design and execution, utilizing an appropriate relational database direction system ( MS-Access 2003 ) , and an application plan that will let users of the book library to add, cancel, amend and pull strings the information in the library database.

For the database design, Enhance Entity Relation Diagramming ( EERD ) and the physical database will be used. Microsoft Access 2003 or MySQL 5.0. will besides be applied in this database design. However, with the front-end application Java GUI ( Graphical User Interface ) API will be used to construct the interface along side Java Database Connectivity that will enable connexion to the database.

Visits have to be scheduled to Riverdale-Greaves Library and the staff interviewed about what sort of informations they collect. The main bibliothecs have besides agreed to reply any inquiries related to the manual system that will enable the mold of the database utilizing Enhanced Entity Relation Diagram, which will function as a design to construct the database tabular arraies, Fieldss and relationships amongst the tabular arraies. Besides the company ‘s input signifiers, which they use to roll up information, will be studied, together with the bill layout and content, to enable the constitution of a realistic information system that will successfully replace the manual system with small or no trouble.

For the scheduling and development of the front-end, surveies and research on the Java Programming linguistic communication, peculiarly the swing bundle and Java database connectivity that allows client application to link to external database and issue SQL questions, have been carried out.

Java really does non hold any built-in database sub-language so a standard linguistic communication, like ANSI-SQL, must be used to construct the question, of which I have several books, both electronic books and physical 1s as mention, in instance farther research is needed.

Undertaking Main sub-tasks

Analysis

During analysis, Riverdale Greaves Vanderpuyle ( RGV ) Limited will be visited to interview the staff and other directors, and besides to analyze the system of operations in order to appreciate and derive an apprehension of the old-timers concern. As the expression goes, one can non construct information systems suited for a company unless one understands the job at manus. The information gathered at this point will assist in patterning the operations of the old-timer concern utilizing dataflow diagram ( DFD ) , and entity relation diagram ( ERD ) . The terminal consequence of the analysis will be a certification which will incorporate the above diagram, and other narrations called requirement specification.

Design

Whereas analysis is concerned with specifying, or doing clear, a demand, design is concerned with developing a solution at the abstract degree. Design is really in two parts planing the information theoretical account that will back up the system, and the front-end application that will pull strings the information. The information theoretical account will be used as a blue-print for the database, and the DFD procedures will be converted to flowchart or pseudo-codes.

Execution

Execution implies utilizing the design as a templet for edifice or developing the application itself and its comrade informations. Java and SQL ( Structured Query Language ) books will be used for the front-end application and MS-Access 2003 for the database scheme.

Testing & A ; Evaluation

Testing is a manner of formalizing and verifying that the package or system developed will run into the specified demand as was documented at the analysis phase. There is the developer proving utilizing trial informations, both good and bad, and documenting the consequence. Then there is the user proving where the system is tested in the user ‘s environment and subjected to usability testing.

V-Model

A fluctuation on the waterfall theoretical account is the ‘V ‘ theoretical account, in which the successive phases are shown in a ‘V ‘ formation as in Appendix A. In the diagram, the left, downward leg of the V shows the advancement from analysis to plan to programming and the increasing dislocation of the system constituents. The right, upward leg shows the progressive assembly and testing, climaxing in the delivered merchandise.

The of import characteristic of this theoretical account is that it shows correspondence between the different phases in the undertaking. For case, the single plans or faculties are tested against the single faculty designs, the incorporate set of package is system-tested against the system design, and the concluding system is user acceptance-tested against the demands specification. This theoretical account demonstrates elements of quality confidence ( QA ) in the intervention of this correspondence.

The V-Model besides provides counsel for the planning and realisation of undertakings. The undermentioned aims are intended to be achieved by a undertaking executing:

  • Minimization of Project Risks: The V-Model improves undertaking transparence and undertaking control by stipulating standardised attacks and depicting the corresponding consequences and responsible functions. It permits an early acknowledgment of be aftering divergences and hazards and improves process direction, therefore cut downing the undertaking hazard.
  • Improvement and Guarantee of Quality: As a standardised procedure theoretical account, the V-Model ensures that the consequences to be provided are complete and have the desired quality. Defined interim consequences can be checked at an early phase. Uniform merchandise contents will better readability, comprehensibility and verifiability.
  • Decrease of Entire Cost over the Entire Project and System Life Cycle: The attempt for the development, production, operation and care of a system can be calculated, estimated and controlled in a crystalline mode by using a standardised procedure theoretical account. The consequences obtained are unvarying and easy retraced. This reduces the acquirer ‘s dependence on the provider and the attempt for subsequent activities and undertakings.
  • Improvement of Communication between all Stakeholders: The standardised and unvarying description of all relevant elements and footings is the footing for the common apprehension between all stakeholders. Therefore, the frictional loss between user, acquirer, provider and developer is reduced ( Forsberg, Mooz, 1998 ) .

Undertaking Plan and Agenda

The undermentioned tabular array is the Undertaking ‘s Activity Dependency Chart, and entire continuance for the undertaking is 280

Activity

Mention

Duration ( hours )

Precedence

Introduction

A

50

None

Analysis

Bacillus

70

A

Design

C

50

Bacillus

Execution

Calciferol

50

C

Test & A ; Evaluate

Tocopherol

30

Calciferol

Decision

F

30

Tocopherol

Entire Hours

280

Initial Literature

Systems Analysis and Design, Donald Yeates and Tony Wakefield, 2nd Edition, Prentice Hall, ISBN: 0273 65536 1, 2004

Java How to plan, H. M. Deitel and P. J. Deitel, 6th Edition. Prentice Hall, ISBN: 10:0-13-148398-6, 2004

MySQL Tutorial, Luke Welling and Laura Thompson, MySQL Press, ISBN: 0-672-32584-5

Forsberg, K. , Mooz, H. ( 1998 ) . System Engineering for Faster, Cheaper, Better. Center of Systems Management. hypertext transfer protocol: //web.archive.org/web/20030420130303/http: //www.incose.org/sfbac/welcome/fcb-csm.pdf.

x

Hi!
I'm Heather

Would you like to get such a paper? How about receiving a customized one?

Check it out