Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

If I am able to classify data based

Status
Not open for further replies.
spmall

spmall

IS-IT--Management
Oct 1, 2002
5
0
0
IN
If I am able to classify data based on certain criteria, then which one is preferable:

1. Having one table with criteria columns
2. Having a separate table for each criterion
3. Having separate users based on one criterion and separate tables under each user for remaining critaria

I am trying to visualize an ERP kind of senario. My criteria could be Company and Year.

Thanks in advance

S P Mall
 
Status
Not open for further replies.

Similar threads

Chopstik
  • Locked
  • Question
How to identify a package based on a code snippet 1
Replies
1
Views
157
Andrzejek
Andrzejek
sqlPower
  • Locked
  • Question
Help with Integer to Char to Datetime stamp
Replies
2
Views
152
SkipVought
S
TheLazyPig
  • Locked
  • Question
Oracle Data Validation 1
Replies
4
Views
74
TheLazyPig
TheLazyPig
TheLazyPig
  • Locked
  • Question
Inserting Text Decimal to Table Error
Replies
4
Views
186
carp
carp
Livia8
  • Locked
  • Question
Alternative to "locate" command
Replies
0
Views
152
Livia8
Livia8

Part and Inventory Search

Sponsor

Back
Top