7 Answered Questions
[SOLVED] What are the options for storing hierarchical data in a relational database?
- 2010-10-29 00:23:33
- orangepips
- 203446 View
- 1166 Score
- 7 Answer
- Tags: sql database tree relational-database hierarchical-data
2 Answered Questions
[SOLVED] Is there any rule of thumb to construct SQL query from a human-readable description?
- 2015-11-26 21:29:09
- user366312
- 863 View
- 3 Score
- 2 Answer
- Tags: sql database relational-database heuristics human-readable
4 Answered Questions
[SOLVED] How to design a product table for many kinds of product where each product has many parameters
- 2009-03-30 01:19:06
- StoneHeart
- 41314 View
- 117 Score
- 4 Answer
- Tags: database-design relational-database database-schema
1 Answered Questions
[SOLVED] How to describe performance issue in relational database?
- 2016-01-24 11:50:59
- Marmite Bomber
- 258 View
- 2 Score
- 1 Answer
- Tags: oracle performance relational-database query-optimization
3 Answered Questions
[SOLVED] Does the join order matter in SQL?
- 2012-03-08 08:48:30
- Ogrish Man
- 97544 View
- 145 Score
- 3 Answer
- Tags: sql join relational-database
3 Answered Questions
[SOLVED] Foreign Key to multiple tables
- 2011-10-21 02:51:45
- Darthg8r
- 85606 View
- 96 Score
- 3 Answer
- Tags: sql-server relational-database
3 Answered Questions
[SOLVED] How to create multiple one to one's
- 2012-02-07 09:57:51
- Luckyl337
- 4009 View
- 7 Score
- 3 Answer
- Tags: sql sql-server database database-design relational-database
2 Answered Questions
[SOLVED] What is the best design for a database table that can be owned by two different resources, and therefore needs two different foreign keys?
- 2012-11-09 15:43:20
- Logan Serman
- 3376 View
- 6 Score
- 2 Answer
- Tags: database database-design foreign-keys relational-database
7 Answered Questions
[SOLVED] When and why are database joins expensive?
- 2008-10-06 09:52:19
- Rik
- 64809 View
- 325 Score
- 7 Answer
- Tags: database performance join relational-database denormalization
5 Answered Questions
[SOLVED] designing database to hold different metadata information
- 2010-07-13 20:06:13
- Obaid
- 14959 View
- 27 Score
- 5 Answer
- Tags: database-design database relational-database
26 Answered Questions
[SOLVED] How do you like your primary keys?
- 2008-12-31 21:14:11
- Perpetualcoder
- 21235 View
- 81 Score
- 26 Answer
- Tags: algorithm database-design relational-database primary-key ddl
1 Answered Questions
[SOLVED] Sql - Indirect Foreign Key
- 2013-12-30 15:47:09
- Andrew Walters
- 1706 View
- 3 Score
- 1 Answer
- Tags: database-design foreign-keys relational-database
9 Answered Questions
[SOLVED] NoSql vs Relational database
- 2010-11-12 00:57:53
- user496949
- 99026 View
- 145 Score
- 9 Answer
- Tags: database database-design nosql relational-database rdbms
1 Answered Questions
[SOLVED] SQL: Creating a relation table with 2 different auto_increment
- 2015-04-14 23:31:58
- Ahmet Ertan
- 2393 View
- 6 Score
- 1 Answer
- Tags: mysql sql relational-database auto-increment
2 Answered Questions
[SOLVED] What to do with null values when modeling and normalizing?
- 2016-11-22 03:51:45
- Kavi
- 1031 View
- 2 Score
- 2 Answer
- Tags: postgresql null relational-database database-normalization
3 Answered Questions
[SOLVED] Relational database design multiple user types
- 2012-12-06 17:52:12
- silkAdmin
- 5325 View
- 9 Score
- 3 Answer
- Tags: mysql database-design relational-database
5 Answered Questions
[SOLVED] Relational table naming convention
- 2011-01-15 23:17:05
- Andreas
- 60445 View
- 124 Score
- 5 Answer
- Tags: database database-design coding-style naming-conventions relational-database
1 Answered Questions
[SOLVED] Laravel - Eloquent "Has", "With", "WhereHas" - What do they mean?
- 2015-05-14 07:36:36
- user4898812
- 118462 View
- 142 Score
- 1 Answer
- Tags: laravel orm eloquent relational-database relationship
6 Answered Questions
[SOLVED] Difference between 3NF and BCNF in simple terms (must be able to explain to an 8-year old)
- 2011-12-08 21:30:28
- Arnab Datta
- 175755 View
- 134 Score
- 6 Answer
- Tags: database relational-database database-normalization 3nf
7 Answered Questions
[SOLVED] MySQL query, MAX() + GROUP BY
- 2011-04-14 01:02:08
- codinghands
- 54744 View
- 26 Score
- 7 Answer
- Tags: mysql sql database relational-database
6 Answered Questions
[SOLVED] Pros/cons of document-based databases vs. relational databases
- 2008-12-03 14:44:29
- user2427
- 40560 View
- 69 Score
- 6 Answer
- Tags: database nosql couchdb relational-database document-database
8 Answered Questions
[SOLVED] How to create relationships in MySQL
- 2008-11-04 00:25:31
- Josh Hunt
- 232869 View
- 83 Score
- 8 Answer
- Tags: sql mysql foreign-key-relationship relational-database
7 Answered Questions
[SOLVED] How can I find MAX with relational algebra?
- 2011-03-30 23:30:13
- Ifiok Idiang
- 54771 View
- 52 Score
- 7 Answer
- Tags: database relational-database relational-algebra
5 Answered Questions
[SOLVED] Database schema which can support specialized properties
- 2010-11-29 13:31:03
- Anders
- 3379 View
- 8 Score
- 5 Answer
- Tags: database-design properties relational-database
2 Answered Questions
[SOLVED] How to Implement Referential Integrity in Subtypes
- 2011-02-04 10:17:18
- Mark
- 3731 View
- 6 Score
- 2 Answer
- Tags: sql database relational-database foreign-key-relationship
13 Answered Questions
[SOLVED] When I should use one to one relationship?
- 2012-09-07 13:15:36
- Pavel Shchegolevatykh
- 24149 View
- 68 Score
- 13 Answer
- Tags: database database-design relational-database
1 Answered Questions
[SOLVED] Minimum no of tables that exists after decomposing relation R into 1NF?
- 2016-05-27 10:42:33
- Mithlesh Upadhyay
- 216 View
- 1 Score
- 1 Answer
- Tags: database database-design relational-database normalization database-normalization
9 Answered Questions
[SOLVED] Use cases for NoSQL
- 2010-05-20 15:46:38
- robjmills
- 29676 View
- 142 Score
- 9 Answer
- Tags: sql mongodb couchdb relational-database nosql
8 Answered Questions
[SOLVED] Still Confused About Identifying vs. Non-Identifying Relationships
- 2010-05-11 21:09:25
- JasCav
- 68947 View
- 69 Score
- 8 Answer
- Tags: database database-design relational-database identifying-relationship
4 Answered Questions
[SOLVED] What are the known ways to store a tree structure in a relational DB?
- 2010-07-29 12:59:06
- Itay Moav -Malimovka
- 34290 View
- 39 Score
- 4 Answer
- Tags: mysql design-patterns tree relational-database