Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using Visual Studio with C#: The Tiny College has a Tiny Library that needs a Windows Forms desktop application with a database to keep track

Using Visual Studio with C#: The Tiny College has a Tiny Library that needs a Windows Forms desktop application with a database to keep track of its books. When the application runs, a login form appears with a textbox for username, another textbox for password, and a Combobox for user role with data pulled from a database table. There are four roles in Tiny Library: admin, librarian, faculty, and student. A user must match username, password, and role to log in. Usernames and passwords are stored in a database table. A user also has a first name and last name. A user can have multiple roles. When an admin user logs in, a form for user management appears. The admin user can: 1) Add a user; 2) Delete a role of a user; 3) Add a new role to an existing user. If the admin user selects "Add a user", a new form will appear allowing the admin to add a username, password, first name, last name, and pick a role for a new user. If the admin selects "Delete a role of a user", a new form appears allowing the admin to find the user and remove one or more roles of the user. The user will not be removed from the system, just one or more roles of the user can be removed. If the admin user selects "Add a new role to an existing user", a new form appears and the admin user can find a user and then select a new role to add. The role in the Combobox dropdown should be new roles to the user(the roles the user are already in wont appear in the dropdown). When a librarian is logged in, a new form appears. It allows the user to: 1) Add a new title; 2) Adjust copies; 3) View borrowers of a book; 4) View checked out book of a borrower; 5) View overdue books. If the librarian selects "Add a new title", a new form appears allowing the user to enter a new title, copyright year, ISBN13, location(eg. Room 101), total copies, and authors. When entering a new author, the librarian should first search if an author is already in the system. The search result should include the author's name and about_the_author. The librarian can also add a new author to the system which also add the author to the book. Two authors may have the same name with different about_the_author descriptions. The librarian makes the decision if the two authors are the same or not. If the librarian selects "Adjust copies", a new form appears. This form is used when a new copy of an existing title arrives or a lost copy is reported. The form allows the user to search for a book and update its total copies. If the librarian selects "View borrowers of a book", a new form appears which allows the user to search for all current borrowers of a book by its ISBN. If the librarian selects "View checked out books of a borrower", a new form appears which allows the user to search for all the books a specific borrower checked out and not returned. If the librarian selects "View overdue books", a new form appears displaying all books that are checked out, but not returned and more than 30 days from the checkout date, including borrowers. When a faculty logins, the faculty form appears. A faculty can: 1) Check out a book; 2) Return a book. If the faculty selects "Check out a book", a new form appears. The faculty can search for a title with partial matches. Only those titles that are still available (checkout copies are less than total copies) appear in the search result. A faculty can check out a book only if the total number of unreturned copies are less than 3. Otherwise, display feedback like, you have reached the limit. if the faculty selects "return a book", a new form appears. All books checked out by the faculty will appear in a list box (yes, faculty can check out two copies of the same title). The faculty selects a book and clicks "return this book". The book will be removed from the Listbox and the database updated. A student user is almost the same as a faculty user except that a student can have a total of two books out at a time.

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

Intranet And Web Databases For Dummies

Authors: Paul Litwin

1st Edition

0764502212, 9780764502217

More Books

Students also viewed these Databases questions