in JAVA, that automates a library [login to view URL] PostgreSQL database

The task:

Design a desktop or console application in JAVA that automates a library system. Your application should access a PostgreSQL database to keep information about aspects of the database. In your database, you should keep information about students (id, name, lastname, address, date of birth, gender), books (ISBN, title, year published, category, authors, number of pages, publisher name, location), publisher (publisher name, address, telephone no), information about which books are in the library and which have been checked out, the due date of checked out books etc. that are needed to answer the queries below.


Your application should enforce the rule that a student can have at most 3 books checked out at any time. Furthermore, if a book is late when it is returned, a penalty of 5 YTL per day should be computed for each day the book is late. If a student has an overdue book, he should not be allowed to check out any other book until all his overdue books are returned.

Program Functionality:

Your application should be menu-driven (it can be a textual menu: list the options, read the user input, do the required action).Here are the menu items for your application.

* Insert a student (make sure a student is entered only once!)

* Insert a book

* Insert a publisher

* List all the books written by an author

* List all books ever checked out by a student

* List all books checked out by a student and that have not been returned yet

* List all books checked out by a student and that have not been returned yet and are overdue (use today's date)

* Most popular book in a given time period (which book has been checked out most from date1 to date2)

* Student who has checked out all the books of a specific author

* Most popular author in a given time period

* Student checks out book

* Student returns book (determine if the book is overdue, and compute penalty)

* Overdue books (i.e. books that have been checked out, and not returned by the return date, which was before today's date)

* Quit

Constraints: The program must be written in Java, using JDBC.

Evner: Java

Se mere: overdue library book java, library system using postgresql, list of books by author, java 1.5 for each, c list library, books by author, books and authors, book authors needed, authors of the books, overdue book java, library database desktop application java, overdue books report java, book library system java, task driven, postgresql any, most popular, list of book and authors, author address, student java, Student information system, student database, read books, postgresql c++, options java, library

Om arbejdsgiveren:
( 0 bedømmelser ) ankara, Turkey

Projekt ID: #257564

14 freelancere byder i gennemsnit $132 på dette job


Please see your PM

$130 USD in 3 dage
(9 bedømmelser)

Will provide you with additional options that makes system user friendly. The application will be completely menu driven.

$100 USD in 10 dage
(0 bedømmelser)

Dear Sir I have gone through your requirement doc i can develop it with fulfill all your requirement. I have more than 3 year experience in java, swing, different type of data access layer include JDBC.

$160 USD in 10 dage
(0 bedømmelser)

Hi, Pls. check the pm.

$150 USD in 15 dage
(0 bedømmelser)

I can take this work. It will be desktop application

$110 USD in 5 dage
(0 bedømmelser)

check the pm pls.

$150 USD in 6 dage
(0 bedømmelser)

I have made a similar project when I was in college Note: It will be console application

$100 USD in 2 dage
(0 bedømmelser)

i can do this project

$100 USD in 10 dage
(0 bedømmelser)

Hi, I have develop the application like this, and The UI is swing based. Until now my application is still under development. So just modify to your requirement. thanks sugiarto

$150 USD in 10 dage
(0 bedømmelser)

i can finish within 8 days

$100 USD in 30 dage
(0 bedømmelser)

I have nearly 4 years of experience in developing standalone as well as web based applications. I have worked with pioneer companies like IBM in IT domain. I have good exposure in technologies and designing large scale Flere

$200 USD in 10 dage
(0 bedømmelser)

project will be delivered on the specified date, might be before the deadline....:) please give me a chance to work with u.........

$80 USD in 3 dage
(0 bedømmelser)

I have experience in Java , I can do it

$250 USD in 25 dage
(0 bedømmelser)

I am professional java programmer ,can deliver the automated library project in 10 days.

$70 USD in 10 dage
(0 bedømmelser)