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

Closed Posted 5 years ago Paid on delivery
Closed Paid on delivery

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

Database Administration Database Development Database Programming Oracle SQL

Project ID: #18025682

About the project

2 proposals Remote project Active 5 years ago

2 freelancers are bidding on average ₹12222 for this job

magiciantuby

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)
0.0