Questions tagged [relational-database]

11

votes

6

answers

Migrate data from relational DB to NoSQL

asked 2013-07-24T11:07:22.787

18

votes

3

answers

One-to-Many relationship in MySQL - how to build model?

mysql relational-database

asked 2013-06-11T13:01:30.023

12

votes

3

answers

Any reason to still use snake case for database tables and columns?

mysql database database-design relational-database

asked 2013-04-29T21:31:29.870

28

votes

2

answers

How to structure and query an appointment system based on time slots where each bookable entity has a different time table daily?

mysql database-design relational-database

asked 2013-03-26T00:41:28.253

34

votes

2

answers

Decomposing a relation into BCNF

relational-database database-normalization decomposition

asked 2013-02-27T01:13:35.700

9

votes

1

answers

How should I store user "favorites" in mySQL table?

mysql relational-database

asked 2013-02-15T20:32:58.980

17

votes

2

answers

How to store a one to many relation in MySQL database?

mysql sql database join relational-database

asked 2012-09-13T08:36:20.497

24

votes

3

answers

How to store bidirectional relationships in a RDBMS like MySQL?

mysql database-design relational-database relationship

asked 2012-05-29T22:58:02.813

9

votes

8

answers

How to implement uniqueness where the order of the fields does not matter

sql sql-server relational-database primary-key foreign-key-relationship

asked 2012-03-14T16:56:58.863

40

votes

5

answers

Safe modelling of relational data in Haskell

haskell relational-database type-safety in-memory-database

asked 2012-02-10T20:11:23.310

64

votes

5

answers

Database design: 3 types of users, separate or one table?

mysql database database-design user-interface relational-database

asked 2011-12-12T18:46:26.717

190

votes

6

answers

Difference between 3NF and BCNF in simple terms (must be able to explain to an 8-year old)

database relational-database database-normalization 3nf

asked 2011-12-08T21:30:28.270

17

votes

3

answers

Most elegant approach for writing JSON data to a relational database using Django Models?

python django json django-models relational-database

asked 2011-12-03T12:23:07.073

32

votes

3

answers

Can one make a relational database using MongoDB?

mongodb relational-database rdbms

asked 2011-11-14T23:14:40.680

14

votes

2

answers

natural key vs surrogate key an innodb foreign key

mysql database database-design foreign-keys relational-database

asked 2011-11-01T19:11:44.013

14

votes

7

answers

What is the relational database equivalent of Factorial and the Fibonacci function?

sql database relational-database

asked 2011-10-26T22:06:56.163

35

votes

4

answers

Query the contents of stored procedures on SQL Server

sql-server sql-server-2005 t-sql relational-database

asked 2011-10-07T11:13:46.697

439

votes

4

answers

How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

sql database-design foreign-keys relational-database relationship

asked 2011-09-04T01:17:36.723

11

votes

5

answers

How to model a database with many m:n relations on a table

database-design relational-database entity-relationship database-schema

asked 2011-08-16T19:13:57.570

9

votes

1

answers

MySQL relational tables and Primary Keys data types

mysql relational-database

asked 2011-08-12T19:09:07.627

17

votes

5

answers

Best practices for migrating database content from one very poor structure to one very logical?

mysql database database-design migration relational-database

asked 2011-08-07T14:44:01.560

29

votes

3

answers

Is it OK to name a MySQL index the same as the column it indexes?

mysql relational-database indexing

asked 2011-06-27T18:24:46.597

9

votes

2

answers

Tracking User activity log - SQL vs NoSQL?

mysql mongodb database-design relational-database nosql

asked 2011-05-22T22:40:16.313

10

votes

3

answers

Is storing graphs in MySQL a good idea?

mysql sql graph relational-database

asked 2011-03-06T09:01:18.257

10

votes

3

answers

PostgreSQL: Why does this simple query not use the index?

database postgresql relational-database database-performance

asked 2011-02-04T22:43:58.607

86

votes

8

answers

What is the difference between a Relational and Non-Relational Database?

relational-database non-relational-database

asked 2011-01-27T00:21:32.620

11

votes

2

answers

Data Modeling: Logical Modeling Exercise

database database-design relational-database database-schema identifying-relationship

asked 2011-01-23T00:23:45.367

171

votes

15

answers

Difference between one-to-many and many-to-one relationship

sql relational-database one-to-many many-to-one

asked 2011-01-05T07:23:07.497

1624

votes

8

answers

What are the options for storing hierarchical data in a relational database?

sql database tree relational-database hierarchical-data

asked 2010-10-29T00:23:33.310

18

votes

9

answers

What's the point of a candidate key?

database database-design entity-relationship relational-database

asked 2010-10-18T17:01:56.543

9

votes

7

answers

Referential Data Integrity: Necessity, nice-to-have, or old hat?

ruby-on-rails nosql relational-database referential-integrity

asked 2010-08-31T11:57:31.033

9

votes

7

answers

Are all modern RDBMS row oriented? Why?

database relational-database

asked 2010-08-17T21:22:29.747

57

votes

4

answers

What are the known ways to store a tree structure in a relational DB?

mysql design-patterns tree relational-database

asked 2010-07-29T12:59:06.773

14

votes

7

answers

Options for eliminating NULLable columns from a DB model (in order to avoid SQL's three-valued logic)?

sql null relational-database three-valued-logic

asked 2010-06-20T16:01:22.213

14

votes

4

answers

(Database Design - products attributes): What is better option for product attribute database design?

relational-database entity-attribute-value database-design

asked 2010-05-31T17:23:16.073

145

votes

8

answers

Use cases for NoSQL

sql mongodb couchdb relational-database nosql

asked 2010-05-20T15:46:38.507

33

votes

10

answers

Is MongoDB a valid alternative to relational db + lucene?

java lucene mongodb relational-database

asked 2010-03-30T15:31:47.710

81

votes

6

answers

Pros/cons of document-based databases vs. relational databases

database nosql couchdb relational-database document-database

asked 2008-12-03T14:44:29.580

421

votes

8

answers

When and why are database joins expensive?

database performance join relational-database denormalization

asked 2008-10-06T09:52:19.473

Questions tagged relational-database