Top "Database-design" questions

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

Storing sex (gender) in database

I want to store a user's gender in a database with as little (size/performance) cost as possible. So far, 3 …

sql database-design
What does principal end of an association means in 1:1 relationship in Entity framework

public class Foo { public string FooId{get;set;} public Boo Boo{get;set;} } public class Boo { public string BooId{get;…

c# entity-framework database-design foreign-key-relationship
Setting up an MS-Access DB for multi-user access

We're thinking of "growing" a little MS-Access DB with a few tables, forms and queries for multiple users. (Using a …

ms-access database-design multi-user
Relational Database Design Patterns?

Design patterns are usually related to object oriented design. Are there design patterns for creating and programming relational databases? Many …

design-patterns database-design rdbms
What's wrong with foreign keys?

I remember hearing Joel Spolsky mention in podcast 014 that he'd barely ever used a foreign key (if I remember correctly). …

database database-design foreign-keys referential-integrity data-integrity
Storing SHA1 hash values in MySQL

I have a simple question which occured when I wanted to store the result of a SHA1 hash in a …

mysql database-design hash sha1
Good tool to visualise database schema?

Are there any good tools for visualising a pre-existing database schema? I'm using MySQL if it matters. I'm currently using …

mysql database database-design schema visualization
NoSql vs Relational database

Recently NoSQL has gained immense popularity. What are the advantages of NoSQL over traditional RDBMS?

database database-design nosql relational-database rdbms
Database design for a survey

I need to create a survey where answers are stored in a database. I'm just wondering what would be the …

sql database-design
What's wrong with nullable columns in composite primary keys?

ORACLE does not permit NULL values in any of the columns that comprise a primary key. It appears that the …

database database-design