I have hit a crisis in the development of my web application for my web development course and I need your help because I am all out of ideas. I am creating a web application in Dreamweaver using ASP ...

In a database design there are many fields with information that needs to be normalized. For instance for an address record countries can be normalized but also the address type (i.e. private address, ...

I'm designing a Staging+NDS+DDS Data Warehouse system, where an ETL is going to normalize data from [Staging] and load it into [NDS], which will hold all history.
I've pretty much finished the T-SQL ...

I have a database with 5 tables.
In every table there is a column for checking status.
If i give the name to that column which is same in all the 5 tables;
What will happen?
Is it correct according ...

I have a MySQL table (~10,000 rows) with a pk id (int) column and a name (varchar) column (as well as a few other unimportant columns for this question).
The name column contains unique values that ...

Is there an official PostreSQL convention regarding capitalization in DB, Table and field names?
The examples on the official site suggest a lowercase and _ word separation, and I wonder whether this ...

In terms of generic variable naming or even everyday geek discussion, do shorter and "cleaner" terms exist for one-to-one, one-to-many, and many-to-many relationships.
For example, in discussion of ...

Why is it that different platforms (linux vs windows) does not support the same naming conventions? I'm stunned by the fact that the documentation uses file names as an excuse for this.
Yes, windows ...

I am doing more extensive work with supertyping and subtyping as it solves some problems in a very useful way. In particular, I am enhancing a web application where many things need to be subject to ...

I was taught not to use the name Id for the identity column of my tables, but lately I've just been using it anyways because it's simple, short, and very descriptive about what the data actually is.
...

What standard should I follow when naming tables and views? For instance, is it a good idea to put something like tbl_ at the beginning of table names? Should I designate code/lookup tables in some ...