Reference no: EM132582413

Learning Outcome 1: Explain database concepts, and principles of data modelling, process modelling and systems development project management, and apply them in designing a simple workgroup-based business application to meet user requirements in a multi-user environment.

Learning Outcome 2: Demonstrate an understanding of a systems development project life cycle by developing and implementing the workgroup-based business application in line with its design.

Scenario 1: Library Management System

InfoRec, an Auckland based software development company has recently received a request form Auckland city council to computerize their library management system, which overlooks the public libraries in Auckland city council area.

A library management system is, "An integratedlibrary system(ILS), also known as alibrary management system(LMS), is an enterprise resource planning systemfor alibrary, used to track items owned, orders made, bills paid, and patrons who have borrowed" . For more details of different operations of library, conduct a bit of research of your own.

The required tool (software) is supposed to handle all the operations of the library, which includes but not limited to, keeping track of all the information about the books in the library, their cost, their complete details and total number of books available in the Library. It aims to make easy for the users to manage records in this automated system rather than using the manual system. The library system contains a repository where all the information will be stored in an organized and secured way. The required system is user-friendly and error free, which mean a thorough testing before implementation.

The proposed system uses a standalone system to manage day to day library activities. It contains different users including general users, the Administrator, and the Receptionist. General users are registered to the system via the registration process managed by the receptionist; they can search and borrow the books. The Administrator can purchase books, manage books, and manage the reports as well as the users' authorities and the receptionist login. The receptionist is responsible for library user registration and lending and receiving books.

Other requirements
1. Library registration: The first procedure is the registration of the people (Customer/general user) who arrive to the library. The receptionist has the authority to enter the name, address and contact number of the people who visit the library.

2. Book search: Customers are allowed to search specified books with titles or topics. (Programmers may add more searches like searching by author, publisher, etc.)

3. Session time: Customers' entry and exit time to the library system will be noted down. This calculates the total amount of time they spent in the library system for each login.

4. Borrowing books: A customer borrows books for 1 week to 3 weeks. Late return penalty applies to the customer based at the rate of $1 per each late day. If the borrower loses any books, the full cost of the book is considered to be the fine.

5. Books: Admin has the authority to add, delete or modify the details of the book available to/from the system.

6. Purchase books: Admin can also add the details of the book purchased from shops along with the shop name. He also has the authority to delete from or modify book's record to the database.

7. Reports: Book report, no return report, fine report, and book purchased report to be viewed by Administrator and Receptionist.

Assume you are the team leader at InfoRec and responsible for building the new system based on the above case study and your own research, how would you respond to the questions given in the tasks section below:

Task 1: Data Modelling and Databases

1.1 In analysing the library system processes, how will the use of databases and database management system help automate them (the procecesses).

1.2 Identifyand listthe basic entities, attributes of the entities, and relationships between different entities of the library management system. (Tabulate them)

1.3 Use Entity Relationship (ER) diagrams to depict different entities of the proposed system. Use any tool of your choice to draw the ERD.

1.4 Identify and list all the things (classes) in the system. Also find the association, and generalizations of different sub-class.

1.5 Use class diagrams to depict different classes of the proposed system. Use any tool of your choice to draw the class diagram.

Task 2: Use Case Modelling

2.1 List all the various use case scenarios you can identify and their interaction with the system.In listing them make a table with two headings - user and use case - and for each user list all the identified use cases.

2.2 Model a use case diagram for the system using the list provided in 2.1. (Limit your answer to not more than 3 scenarios with not more than 5 use cases per scenario)

2.3 Use generalization, extension, and inclusion association in at least one use case. You can add any of these from your own understanding to the use case in 2.2 if not available in the case study.

2.4 Illustrate at least one fully developed use case description for a selected use case.

Task 3: Activity Modelling

3.1 Select any two (2)use case in(2.1), and list different activities involved in building the new system. Follow the proper user-system scenario to show the list of activities.

3.2 Use activity diagrams to show all the activities for each use case in (3.1).Use one activity diagram for each use case.

Task 4: System Development Life Cycle (SDLC)

4.1 Being a team leader at InfoRec and responsible for building the system, define the core process for developing the library management system.

4.2 What will be your detailed analysis activities for the proposed system? List and define such activities.

Task 5: Work breakdown structure

5.1 Provide a work breakdown structure for all the system analysis and design activities for the development of the system in the case study.

5.2 Using Gantt chart (MS project, projectLibre) show the sequence of activities, along with their preceding and succeeding activities. Suppose you are given a two-month time to finish the two phases of this project.

Attachment:- system analysis assignment.rar