Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The aim of this project is to design and develop an Information System for a university library. Specifications: A list of bibliographic information on books

The aim of this project is to design and develop an Information System for a university library.
Specifications:
A list of bibliographic information on books should be stored
Number of copies of each book and the status of each copy should be stored.
Status of books on order should be stored.
Information on members should be stored
Information on books loaned should be stored.
The system should be able to print at least the following list of reports (This is just a reccomended list, please dont forget that every additional report implemented by the project team will effect their ranking in the class):
o List of books
o List of books on loan
o List and status of books ordered
o List of books due on a certain date
o List of books with problems (such as late books including the number of days it is overdue)
o A reminder letter to be issued to a borrower on a specified time (near to the due date for return).
o And etc...
The system should be able to perform and reply at least the following on-line queries (This is just a recommended list, please dont forget that every additional query implemented by the project team will effect their ranking in the class):
o Communication information about a member.
o Status of a certain book.
o Number of books on loan.
o Number of books loaned by a certain member.
o Name of the member who borrowed a certain book, etc.
Project Requirements:
Design a database to store all necessary data
User interface on Access
o Tables
o Queries
o Forms
o Reports
It should be designed as a Relational Data Base and implemented such that it can be used on a single PC with an accompanying printer.
All input data should be entered into screen forms and all modifications should be done on screen forms. Ergonomic features of the user interface should be taken into account.
The written report should include the objectives of the system, the results of the system analysis, a design and implementation critique and a USER MANUAL.
The report should be neatly written with proper content in addition to sections like TABLE OF CONTENTS, INTRODUCTION, ....., CONCLUSION, REFERENCES
SAMPLE Project Report Specifications (YOU DONT HAVE TO FOLLOW THE SAME STRUCTURE)
TABLE OF CONTENTS
LIST OF TABLES
LIST OF FIGURES
Chapter 1 Introduction
Chapter 2 Planning/Methodology
Chapter 3- System Analysis
Chapter 4 Design
Explain the system created using MS Access with providing user interfaces.
Chapter 5 Conclusion
REFERENCES

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Design For Mere Mortals

Authors: Michael J Hernandez

4th Edition

978-0136788041

More Books

Students also viewed these Databases questions