Database design standards

Question

I'm looking for a document/text/book about the database design standards, until now I've found this but it is a custom set of rules about design, I need something like an IEEE standard or such.

Thanks in advance.

Answer 1

As far as I know there is no such thing as an official IEEE standard regarding database design. However there is the Entity-Relationship-Model and the theory of database normalization. For the more mathematically inclined there is relational algebra.

It is also common to make a distinction between physical, logical and conceptual schemata in database design. What is most important area of those 3 would also determine in what kind of material you should be looking into.

Answer 2

This is the book I used a few years ago when I initially learned about database design in school: http://www.amazon.com/Database-System-Concepts-Abraham-Silberschatz/dp/0073523321/ref=sr_1_1?ie=UTF8&s=books&qid=1279133097&sr=1-1

For online research, make sure you look into "3rd normal form" designs for your databases. It allows for the most flexibility and maintenance.