Top "Database-design" questions

Database design is the process of specifying the structure and thus the logical aspects of a database.

Best practices for storing postal addresses in a database (RDBMS)?

Are there any good references for best practices for storing postal addresses in an RDBMS? It seems there are lots …

database database-design types street-address postal-code
How to implement a many-to-many relationship in PostgreSQL?

I believe the title is self-explanatory. How do you create the table structure in PostgreSQL to make a many-to-many relationship. …

sql database postgresql database-design many-to-many
PostgreSQL: Which Datatype should be used for Currency?

Seems like Money type is discouraged as described here My application needs to store currency, which datatype shall I be …

sql postgresql database-design
Database design for audit logging

Every time I need to design a new database I spend quite some time thinking on how I should set …

database-design logging audit
Table Naming: Underscore vs Camelcase? namespaces? Singular vs Plural?

I've been reading a couple of questions/answers on StackOverflow trying to find the 'best', or should I say must …

database database-design
List of Constraints from MySQL Database

How do I get a list of all constraints from a particular database?

mysql database-design constraints
Database schema design for a double entry accounting system?

Does anybody know or have any links to websites describing details of how to design a database schema for a …

database database-design accounting
Relational table naming convention

I'm starting a new project and would like to get my table- and column names right from the start. For …

database database-design coding-style naming-conventions relational-database
Is there common street addresses database design for all addresses of the world?

I am a programmer and to be honest don't know street address structures of the world, just how in my …

sql database-design street-address postal-code