User Todd Everett

33 votes

Accepted

Database Design: New Table versus New Columns

answered May 25, 2012 at 14:14

25 votes

Entity relationship problem

answered Aug 29, 2015 at 18:55

17 votes

Database design for products with bundles of products

answered Feb 19, 2016 at 12:37

14 votes

Best way to store units in database

answered May 30, 2012 at 1:16

12 votes

Accepted

What are the practical reasons behind learning relational algebra?

answered Aug 19, 2015 at 4:37

10 votes

Need help on my first ER diagram

answered Sep 1, 2015 at 19:31

10 votes

Why the term "relation(al)"?

answered May 19, 2017 at 19:40

9 votes

Functional dependencies applies to whole database or to a particular relation?

answered Sep 16, 2015 at 20:21

9 votes

Conditional Foreign Key Relationship

answered Sep 3, 2015 at 23:39

9 votes

What database technologies do big search engines use?

answered Jun 1, 2012 at 12:28

9 votes

Accepted

What is a "database"?

answered Jun 2, 2012 at 16:11

8 votes

Accepted

Is it possible to get rid of so-called 'Spurious Tuples' completely?

answered Nov 18, 2015 at 23:25

8 votes

Accepted

Is splitting a CSV column into a separate table (enforcing 1NF) unnecessary complication?

answered Dec 8, 2015 at 13:25

6 votes

Accepted

What could justify a non explicit - non atomic primary key

answered Nov 30, 2015 at 23:12

6 votes

Accepted

Normalizing a database without access to source data?

answered May 8, 2013 at 14:51

6 votes

Accepted

How to enforce a constraint over multiple tables?

answered Aug 16, 2015 at 16:03

5 votes

Accepted

Database Schema for Resume/CV and Separate Sections

answered Aug 19, 2015 at 13:36

5 votes

Accepted

The key of the relation resulting from a full outer join

answered Aug 20, 2015 at 21:59

5 votes

How can I design a database to track each individual's stat changes weekly, in a group?

answered Aug 25, 2015 at 0:36

5 votes

Is this proper way to link parent and child tables with logical data instead of parent and child using primary and foreign key

answered Aug 12, 2016 at 12:27

5 votes

Needing A Database Design Book

answered Oct 15, 2015 at 15:56

5 votes

Accepted

If a table with a surrogate key has a column known to have unique non null values (eg SSN), does it violate 3NF?

answered Oct 22, 2015 at 20:04

3 votes

Accepted

UPDATED: Relational (or NoSQL) Database Design

answered Sep 1, 2015 at 1:48

3 votes

Survey Database - Respondent Table (1NF or 3NF - Pros and Cons)

answered Feb 3, 2016 at 14:36

3 votes

Should I maintain relationships diagrams in the back-end and the front-end?

answered Aug 25, 2015 at 13:28

3 votes

Do I relate entities that are indirectly related when creating a student-course ERD?

answered Aug 16, 2015 at 20:41

3 votes

Accepted

Using surrogate key after merging the person's data?

answered May 28, 2012 at 1:07

3 votes

Supertype/Subtype deciding between category: complete disjoint or incomplete overlapping

answered Apr 18, 2012 at 15:53

3 votes

Good reason to denormalize?

answered May 25, 2012 at 11:49

2 votes

Accepted

Does a dual key or single key lookup perform better on a table with a lot of data?

answered May 27, 2012 at 17:47

Stack Exchange Network

52 Answers

Database Design: New Table versus New Columns

Entity relationship problem

Database design for products with bundles of products

Best way to store units in database

What are the practical reasons behind learning relational algebra?

Need help on my first ER diagram

Why the term "relation(al)"?

Functional dependencies applies to whole database or to a particular relation?

Conditional Foreign Key Relationship

What database technologies do big search engines use?

What is a "database"?

Is it possible to get rid of so-called 'Spurious Tuples' completely?

Is splitting a CSV column into a separate table (enforcing 1NF) unnecessary complication?

What could justify a non explicit - non atomic primary key

Normalizing a database without access to source data?

How to enforce a constraint over multiple tables?

Database Schema for Resume/CV and Separate Sections

The key of the relation resulting from a full outer join

How can I design a database to track each individual's stat changes weekly, in a group?

Is this proper way to link parent and child tables with logical data instead of parent and child using primary and foreign key

Needing A Database Design Book

If a table with a surrogate key has a column known to have unique non null values (eg SSN), does it violate 3NF?

UPDATED: Relational (or NoSQL) Database Design

Survey Database - Respondent Table (1NF or 3NF - Pros and Cons)

Should I maintain relationships diagrams in the back-end and the front-end?

Do I relate entities that are indirectly related when creating a student-course ERD?

Using surrogate key after merging the person's data?

Supertype/Subtype deciding between category: complete disjoint or incomplete overlapping

Good reason to denormalize?

Does a dual key or single key lookup perform better on a table with a lot of data?