lcor
asked on
Database Design NULLs
I have inherited a database schema from previous set of developers. I notice that alot of values in tables are NULL.
This tells me the database has not been normalized. Am I correct?
Doesn't 3rd Normal Form prevent excessive null values in your schema?
I'm still trying to understand database design and if someone could explain this concept, it would be a great help.
This tells me the database has not been normalized. Am I correct?
Doesn't 3rd Normal Form prevent excessive null values in your schema?
I'm still trying to understand database design and if someone could explain this concept, it would be a great help.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
![Avatar of Guy Hengel [angelIII / a3]](https://filedb.experts-exchange.com/files/public/2013/11/25/ddbe0ea6-aa6e-4279-b781-57b735dd3ea0.jpeg){kind=small}
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I'm not sure why retrieving NULL's would be a problem. If the data is NULL it's NULL, I would WANT to retrieve NULL..
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
great input from everyone
glad we could help