The project involves the creation of a client-server application to be utilized by librarians (not book borrowers)

High level functionality supported by the application:

- User interface to perform all listed functions unless stated otherwise

- Load initial data (provided) using SQL Developer Import utility (no need to develop UI)

- Add authors

- Add Books

- Add borrowers

- Search books by various parameters: ISBN, title, author

- Check-out (loan) books

- Check-in books

Tools to be used:

• Database: Oracle Database 12c

• User Interface: Oracle Application Express 18.1: [login to view URL]

• ER Diagrams: MS Visio or other tool

Functional Requirements:

1. Graphical User Interface, Overall Design, Architecture

2. Data Load, Normalization, data generation

3. Book Search and Availability

4. Book Loans : Checking Out Books; Checking in (returning) Books

5. Borrower Management

6. Fines

7. Reports

A schema has been provided along with this. You will draw an ER diagram and depending upon the authenticity and complexity of ER diagram we will move forward. Will share other project details once we finalize on everything

Skills: Database Administration, Database Development, Database Programming, Oracle, SQL

See more: client server application vb60, wpf client server application, client server APPLICATION, vb6 client server application, programing client server application delphi, delphi access client server application, client server application visual basic, client server application socket programming, tcpip client server application windows, chat project free simple client server, build tcp client server application, access client server application web based, simple project client server application, eclipse rcp client server application, client server application net web based, socket programming java client server application, project client server application, project client server application android, project proposal client server application

About the Employer:
( 0 reviews ) India

Project ID: #18025682

2 freelancers are bidding on average ₹12222 for this job


Hello, I have more than 11 years of experience on oracle sql/plsql. Also have experience of two data migration projects where around 6 million customers were migrated into target system using PL/SQL and shell scrip More

₹7777 INR in 3 days
(0 Reviews)

I am Oracle Certified Programmer with 7 =years of experience. Please have a look on my linkedin profile: [login to view URL]

₹16666 INR in 3 days
(0 Reviews)