What is the reason of having Multiple table in databases,why not a huge single table?

Answer 1

In relational databases this would take up too much resources to store not only data but also relations between them. It would also hamper data retrieval efficiency, especially in a multiuser environment.

In non-relational dbs, this kind of happens, but it is being managed differently.

Answer 2

Thank you everyone:-)

Answer 3

@Kuba just reminded me:

SugarCRM (free) uses MySQL. MySQL supports relational tables, but SugarCRM uses tables as if they had multiple row types.

This means they have all these extra columns depending on immediate row type, plus several "linking tables" that just record relationships. The tables can reference themselves, and when debugging you have to stop and check what kind of record you have. It works, but it feels weirder than necessary.

Answer 4

keep consitancy
various missing rows..
if all data in one table then its vary difficult to access the unique data

Answer 5

Thank you:-) #hasana madusanka

Answer 6

ya my name is sadiya :-D#hasana madusanka

Answer 7

Efficiency why lookup for 1000 records when u want only one.Thats y we have to learn DBMS.

Answer 8

Resource tradeoffs (time, space, cycles, etc). MongoDB just throws everything together, and its name is no accident:
"HuMONGOus" + "DataBase"

Answer 9

there are various reasons to separate data across multiple table..
data access
Data redundancy

Go through the Database Normalisation Concept you will understand why multiple tables and read Codd Rules it will definitely help you to learn DBMS.

Answer 10

yeh....beautiful name....

Answer 11

👍👍👍

Answer 12

sadiya......

Answer 13

welcome....