Top "Database-design" questions

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

What is the most efficient way to store tags in a database?

I am implementing a tagging system on my website similar to one stackoverflow uses, my question is - what is …

database database-design tags tagging
Schema for a multilanguage database

I'm developing a multilanguage software. As far as the application code goes, localizability is not an issue. We can use …

database-design localization multilingual
When/Why to use Cascading in SQL Server?

When setting up foreign keys in SQL Server, under what circumstances should you have it cascade on delete or update, …

sql-server database-design foreign-keys rdbms cascade
Syntax error: missing expression (ORA-00936)

I have 2 tables, Facilities and Services. CREATE TABLE Facilities ( facility_id NUMBER(2) NOT NULL, facility_name VARCHAR2(20) NOT NULL, CONSTRAINT …

sql oracle database-design foreign-keys ora-00936
How big can a user agent string get?

If you were going to store a user agent in a database, how large would you accomdate for? I found …

http database-design http-headers user-agent
How big is too big for a PostgreSQL table?

I'm working on the design for a RoR project for my company, and our development team has already run into …

sql ruby-on-rails performance postgresql database-design
Are soft deletes a good idea?

Are soft deletes a good idea or a bad idea? Instead of actually deleting a record in your database, you …

sql database database-design data-modeling soft-delete
MySQL: multiple tables or one table with many columns?

So this is more of a design question. I have one primary key (say the user's ID), and I have …

mysql database-design
What is a table prefix?

What is a table prefix, and what are their advantages and disadvantages? This is in relation to MySQL.

mysql database database-design prefix
How entity framework works for large number of records?

I see already a un-answered question here on. My question is - Is EF really production ready for large application? …

c# entity-framework database-design entity-framework-6