Answer to Question #258074 in Databases | SQL | Oracle | MS Access for Joy

Question

Assume you have been contracted to develop a database system for the University library, you are required to use a systems development life cycle approach to discuss how you are going to approach the project. Discuss the various user groups that will be involved during the requirements analysis. What are the key issues that need to be answered

Answer 1

In our existing system all the transaction of books are done manually, So taking more time like borrowing a book or returning a book and also for searching of members and books. Another major disadvantage is that to preparing the list of books borrowed and the available books in the library will take more time, currently it is doing as a one day process for verifying all records.Through our software user can add members, add books, search members, search books, update information, edit information, borrow and return books in quick time

Requirements :

• -The Library Management System shall be required to maintain information about its users and books.
• - It shall store databases for students, teachers and books.
• - The student database stores information about a student’s roll no, name, address, course and year.
• -The book database stores information about a book title, author, publisher, cost, bill number, year of publishing and pages.
• - The teacher database stores information about a teacher’s id, name, department, designation, address and telephone number

Methodology to be used for the project -----> SDLC – WATERFALL MODEL:

The Waterfall Model was first Process Model to be introduced. It is also referred to as a linear sequential life cycle model. It is very simple to understand and use. In a waterfall model, each Phase must be completed before the next phase can begin and there is no overlapping in the phases. Waterfall model is the earliest SDLC approach that was used for software development.

Groups :

• Student ( attribute1, .......)
• teacher  (attribute1, .......)
• books ( attribute1, .......)
• library ( attribute1, .......)

key issues that need to be answered during fact finding

1. ADD BOOK
2. ADD MEMBER
3. ISSUE BOOKS/RETURN BOOK
4. LIST OF BOOK
5. LIST OF MEMBER
6. EDIT