Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 NULLs

Author  Topic 

andre
Constraint Violating Yak Guru

259 Posts

Posted - 2001-03-27 : 11:22:34
I have several Excel spreadsheets that need to be turned into a relational database. It is composed of different types of motors. The fields each motor will have depends on the type of motor.

My question is should I use 1 large table for all motors and have NULLs as values for the fields that don't apply to a certain record or should I break the data down into multiple tables? Does having NULLs as values for fields that don't apply to a certain record violate any rules of normalization?

   

- Advertisement -