Need one simple clarification

Databases
1

Hi,

pls clarify my doubt.

where ever i saw, two tables for users inoformation.

1)users
2)user_details table.

Even though it has been done for normalization, i need eay answer for this.

pleaseeeeeeeeeeeeeeeeeeeeeeeeeeeeeee send.

Thanks in Advance,
Sunil.

2

that design is oooooooooooooooooooooooooooooooooookay

so that’s your answer

:smiley:

3

Hi,

I need clarification why they are taking two tables instead of one table.

Regards,
Sunil.

4
  • because they felt like it?
  • because they ~thought~ they were normalizing?
  • because someone told them to?
  • because the user_details table is heavy with image blobs?
  • because the two tables are maintained by separate software modules?
  • …
5

cos without knowing the fields in both tables, it is not easy to know why there were two tables. although rudy has given some genuine reasons why above.