Devam Ediyor


CMP556 Spring Project 1 Part 1

Library Management System

This project is supposed to develop a database system for the local library. Your finished product should contain information about books, book authors, publishers, and borrowers.

1. Create following tables. These attributes are required. You may add any other attributes that you think they are useful.

Book: ISBN, Title, PublisherID, AuthorID, PublishDate, AvailableCopies

Author: AuthorID, Name, Email

Publisher: PublisherID, Name, Address, Phone

Borrower: CardNo, Name, Address, Phone

Book_Borrow: ISBN, CardNo,BorrowDate

2. Insert minimum five records into each table.

3. Create a Netbeans Java Project “LMS”, in which you implement:

a. A text based menu, which provides the options:

1. Search a book by ISBN

2. Search a Book by Title

3. Search an Author by Name

4. Search a Borrower by CardNo

5. Insert a New book

6. Insert a New Author

7. Insert a New Borrower

8. Check Out a Book

9. Return a Book

10. List All Books

11. Exit

b. When user selects one of those menu-options listed above, your program prompts a message, receives a user input, and fulfills the request. For the search result, your program displays all matching records. To insert a new record, you program requires user to provide data for all columns.

c. If the user input is not valid, your program should prompt corresponding messages, and ask for reenter.

d. Borrower can borrow multiple books, but one at a time.

e. When you search a borrower, display borrower information and the list of books that the borrower currently checked out.

f. Initially each book has five copies available.

g. When user enters a new book, publisher and author must be selected from the existing list.

h. To test your code, you have to include your oracle user name and password in your source code. Please change your oracle user password to something that is different from your other passwords. DO NOT use your email account password for oracle user account.

i. Comment your source code as much as possible, so that I can understand what you are thinking.

j. Your code should compile and run. You will not receive credit if your code does not compile.

k. Part I implementation is very similar to the examples we have seen in the class. You can refer to the code examples on Blackboard.

What to submit:

A single zip file that includes your NetBenas project, all related sources, driver, and resource files. Zip file name should be:

Your last name _ your first name

Beceriler: Java, MySQL

Daha fazlasını gör: part time driver, oracle e source, list of books by author, library part, email is not valid, email address is not valid, comment oracle, c list library, cardno, books and authors, what is java spring, what is account management, time management test, list of book and authors, k to 12 program, the thinking h, result system, records management , library management, library information, database system, data management system, credit management, book authors, java library database management system

İşveren Hakkında:
( 0 değerlendirme ) India

Proje NO: #6500651



A proposal has not yet been provided

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD
(0 Değerlendirme)

Bu iş için 2 freelancer ortalamada $30 teklif veriyor


Dear hiring manager, I have read your job description very attentively. I have fully understood what you need to done.. We have a team of professionals.. I can work full time and have the ability to finish the pr Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(1 Yorum)