Question: Please use Microsoft Visio You are going to to draw DFDs for a university library. This is typically what happens in the university library: To

Please use Microsoft Visio
 Please use Microsoft Visio You are going to to draw DFDs

You are going to to draw DFDs for a university library. This is typically what happens in the university library: To borrow books from the university library, a student shows her student card and the books to the library employee at the checkout. The employee swipes the student card to retrieve her records from the database. The student might not be able to borrow those books for many reasons. For example, the student has already borrowed 10 books (the upper limit) or the student has not returned books already due. If the student is able to borrow the books, then for each book borrowed, 1 a borrowing record is generated, and 2) the status of the book is updated to "held by borrower and not available". To return a book, a student can return the book to the checkout, or the drop slot near library entrance. In both cases, the book will be scanned to retrieve information about the book from database. Then 1) a return record is generated, and 2) the status of the book is updated to "available in library" At the end of each day, the library information systems scans the database. If a borrowed book is due within 3 days, a notice will be emailed to the student to remind her. If a borrowed book is overdue, 1) the amount of fine will be calculated and updated every day ($0.5 fine per day), 2) the status of the corresponding student will be labeled as "not able to borrow books", and 3) an email with fine amount is sent to the student. Note that there are four major entities in the library database: book, student, transaction (borrow/return), and fine

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!