Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / General DB Topics / General DB Topics / February 2005

Tip: Looking for answers? Try searching our database.

number of attributes

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
GuyBrush Treepwood - 22 Feb 2005 20:11 GMT
Is there a maximum to how many attributes a table should have? I'm
implementing a user-based web-application for school. Should I, for
example, put all the user characteristics and preferences in one table or
should I split it in multiple tables.
--CELKO-- - 23 Feb 2005 01:06 GMT
How long is a piece of string?

The table should have enough attributes to describe the entity being
modeled.  Are  user characteristics separate from user preferences?
Probably, but i don't know.
Neo - 23 Feb 2005 05:38 GMT
> Is there a maximum to how many attributes a table should have?

Typically tables are limited to a maximum number of attributes. You
would need to check the specifics of yours db.

> Should I, for example, put all the user characteristics
> and preferences in one table or should I split it in
> multiple tables.

It depends on what trade-offs you are willing to accept. One table is
probably the easiest, at least initially, but might limit your
flexibility. Multiple tables may allow you to reduce data redundancy
and provide more flexibility in the long run but at the cost of
additional complexity.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.