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.

to what end? what kind of database and what are you designing? standards for database api's? standards for table structure? standards for representing commonly-recurring objects as tables? — eruciform, Jul 14 '10 at 18:51
for general guidelines this is a great resource -- http://www.amazon.com/Data-Modeling-Information-Professionals-Schmidt/dp/0130804509 — , Jul 14 '10 at 19:01
possible duplicate of [Good Resources for Relational Database Design](http://stackoverflow.com/questions/11615/good-resources-for-relational-database-design) — , Jul 14 '10 at 19:02
standards for table naming conventions, lengths of fields, all about table structure. — Felix, Jul 14 '10 at 19:06

score 0 · Answer 1 · answered Jul 14 '10 at 18:48

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.

score 0 · Accepted Answer · answered Jul 14 '10 at 18:49

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.

Database design standards

2 Answers2