We need to use two or three tables. So we will need a database. The software is going to be written in a normal PC(no server availability) and is going to be deployed in a normal PC . No relation to internet and stuff. Anything we use has to be downloaded from net only. Can’t buy software. So , which is the development tool to be used and what is the database that best suits? Can oracle database be used(that’s the only database we know)? Are there any more requirements?
Oracle can certainly be used. But the only free version is Oracle Express Edition 10gR2 (http://www.oracle.com/technetwork/database/express-edition/downloads/index.html). It is free with some limitations (like storage not to exceed 5GB, windows or linux only, no support).
The other versions of Oracle (Standard 1, Standard and Enterprise) are free only for evaluation, development and demonstrations. If your application progresses to a full production environment, then you will not be allowed to use those without proper licensing.
Other than that there are a number of open source databases that are license-free: MySQL (now owned by Oracle) or PostGres are good candidates. If you look for something very simple and vary light, you could also look at SQLLite.