The project involves the creation of a client-server application to be utilized by librarians (not book borrowers)
₹1500-12500 INR
Paiement à la livraison
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
Nº du projet : #18025682
À propos du projet
2 freelances font une offre moyenne de 12222 ₹ pour ce travail
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 Plus
