Reference no: EM133266159

Data modeling provides a logical representation of the system data. This is a high-level view that is not concerned with how or where the data will be stored or accessed. Data modeling allows the systems analyst to describe how the data will flow through the business processes.

During the analysis phase, the systems analyst creates logical data models. Entity relationship diagrams (ERD) are used to model the data.

Case J: University Library Borrowing System Try to create a set of use cases for a university library borrowing system.

The system will record the books owned by the library and will record who has borrowed what books. Before someone can borrow a book, he or she must show a valid ID card that is checked to ensure that it is still valid against the student database maintained by the registrar's office (for student borrowers), the faculty/staff database maintained by the personnel office (for faculty/staff borrowers), or against the library's own guest database (for individuals issued a "guest" card by the library).

The system must also check to ensure that the borrower does not have any overdue books or unpaid fines before he or she can borrow another book. Every Monday, the library prints and mails postcards to those people with overdue books. If a book is overdue by more than 2 weeks, a fine will be imposed and a librarian will telephone the borrower to remind them to return the book(s).

Sometimes, books are lost or are returned in damaged condition. The manager must then remove them from the database and will sometimes impose a fine on the borrower.

Using your use cases as your basis, complete the following:

Try to create entity relationship diagrams (ERD) that depict how the data flow through this new system.