[gabriel]

Hi,

I am new to database concepts and look to develop my skills in it.

I am confused about the difference between "TABLES" and "DATABSASES"...are they the same thing? I read about "employee tables" "customer tables" and then i read about "employee databases" and "customer databases"...my questions are:

1) are tables and databses same thing? (And used interchangeably?)
2) How many databases are there typically in small-sized companies (say a company with 100 employs and about 600 customers)...what do you think will be the ideal number of databases in a company of that size?
3) Will running an Oracle Database for such a company (with 100 employees and 600 customers) is fees able?

Thanks! -
gabriel

[ScottHughes]

Tables are inside the database. The database can have multiple tables. Each table has it's own information, because each table has rows and columns.

You connect to the database, and then you can access any of the tables for that database. The different tables are all seperate.

[shavei7]

for a small company as you have mentioned, it still depends on the transactions being done on the daily basis. it could be a company of 10 with only 100 customers but they could be running a more complicated business (can't think of any right now). either way, the DB design and choice of what DB to use will most likely depends on where/how you're going to use it.