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
I have 10+ years JAVA experience and more than 600 projects completed on this platform. I am very interested to work on this assignment. Ready to start ASAP.
Hi,
I have a pretty talented team of members having experience in the software industry between 4 - 12 years and have created mock up screens several complicated applications. Already we have developed and delivered one android application and Real Estate Development application with 5 star ratings. Even we have completed many of the technical exams with above 90 percentile. This is our knowledge and talent. We can deliver any product on time and on budget. We are available always over phone / email to provide update / support.
Thanks
Paul
Dear sir,
I have done many projects in Java for student around the world and got some positive feedback from clients. You can check my profile for more information. Let me help you. I'm ready to get started right now.
Thanks and best regards,
Tinh Nguyen
do you already have a project developed and want modifications into existing project?
Or you want to develop a fresh new project?
i will help you just let me know what you have right now in hand or you have nothing
Hello,
I have read your project description about a Java-MySQL assignment and I would appreciate if you can open discussion with me and we see how we can work together. Am a graduate in Computer Science currently and have build a school management system using java and MySQL. With this knowledge I believe I can deliver exactly what you need.
I will work closely with you throughout the whole process, communicating continuously at every stage with updates requesting any revisions or additions that need to be made. I will also work with you until the project comes to fruition, in perfect condition, and ready for submission. I realize that each academic project is unique and requires thoughtful research. With care and planning we can work together to create something which can fulfill your expectations.
Hope to work with you soon!
Looking forward to hear from you
Thanks
nyarOnyari
Hello,
I am an experienced java programmer. I have experienced in working with mysql databases.
If you budged can be bigger then is written in you post and if you are interested in discussing with me please send me a private message.
Best regards,
Gabriel Bica
I have 10+ years of experience working in java/j2EE projects.
I am certified Java Enterprise architect. I should be able to help you fix the errors in your project and import to eclipse.
My Professional Certifications:
· Sun Certified Java Programmer(SCJP 1.4)
· Sun Certified Web Component Developer(SCWCD 5)
· Sun Certified Business Component Developer(SCBCD 5)
· Rational Application Developer v7(000-136)
· Advanced Rational Application Developer v7(000-137)
· Oracle Certified Master, Java EE 5 Enterprise Architect.
I have done the similar projects. so i can know the edge cases easily. As,i have hands on experiences in using java, mysql and as i know the project in and out, i can add extra features(if you want) to it.
I am already working on a library project that can be hosted as SaaS on digital ocean or on AWS.
It contains, API Level, UI Level developed in Laraval Framework. I can finish it in 15 days.
Here we are having a team of expert developers and they are very much proficient in all kinds of software development work. I have understood all your requirements and will make the execution in accordance with your instructions. Our past experiences include software like Attendance Management System, Students portal, Hospital management system, Inventory management system and currently we are working on largest E-comm platform. So in the same manner we can create your library management system with lots of effective features. I am always available for the conversation. Looking forward to work with you. Thanks & Regards
Why me? Because I'm actively using JavaFX 8 UI toolkit for my projects. Result of that approach is MVC architecture of code and software that doesn't just function well, but also looks pretty.
I'm new on freelancer, but i'm interested for this project becouse i have the complete project done. Please contact me, i'll send you pictures of the project how it looks like (php & mysql bases)... Waiting for you .....
