Top "Relational" questions

What's the best practice for primary keys in tables?

When designing tables, I've developed a habit of having one column that is unique and that I make the primary …

sql sql-server database relational
Using Tuples in Ruby?

Does anyone use tuples in Ruby? If so, how may one implement a tuple? Ruby hashes are nice and work …

ruby tuples relational
What is Normalisation (or Normalization)?

Why do database guys go on about normalisation? What is it? How does it help? Does it apply to anything …

database-design database-normalization relational
Superkey, candidate key & primary key

Can any kind soul clarify my doubts with a simple example below and identify the superkey, candidate key and primary …

sql oracle primary-key relational
Why should I use document based database instead of relational database?

Why should I use document based database like CouchDB instead of using relational database. Are there any typical kinds of …

database couchdb relational non-relational-database
SQL selecting rows where one column's value is common across another criteria column

I have a cross reference table that looks like this: id document_id subject_id 1 8 21 2 5 17 3 5 76 4 7 88 5 9 17 6 9 76 7 2 76 It matches documents to subjects. …

sql relational
SQL two tables and creating a link table

I have two tables: Employee (ID, Name, Address) and Store(ID,Address) and I would like to record information about …

sql sql-server tsql relational-database relational
How do you document your database structure?

Many database systems don't allow comments or descriptions of tables and fields, so how do you go about documenting the …

sql database documentation relational
use relational operators in switch

Is there a way to use relational operators (<,<=,>,>=) in a switch statement? int score = 95; switch(score) { …

java operators switch-statement relational
HTML 5 / Javascript flowchart tools / prezi style?

Does anyone know if there is sort of an open-source Prezi tool that works with HTML5 / javascript? I'm looking for …

html mapping visualization relational prezi