User MDCCL

33 votes

Accepted

Why the term "relation(al)"?

answered May 19, 2017 at 23:02

32 votes

Accepted

Designing a friendships database structure: Should I use a multivalued column?

answered Apr 20, 2016 at 16:56

28 votes

Modelling a database structure for multiple user types and their contact information

answered Aug 9, 2017 at 21:17

26 votes

Accepted

Implementing versioning system with MySQL

answered Aug 26, 2015 at 19:41

24 votes

Accepted

How to model an entity type that can have different sets of attributes?

answered Sep 17, 2016 at 17:53

21 votes

Accepted

Storing a Billing Address Best Practice in Orders Table

answered Aug 14, 2015 at 21:47

20 votes

Modeling a scenario in which each Music Artist is either a Group or a Solo Performer

answered May 20, 2015 at 17:48

18 votes

Accepted

Designing a database for a video game business domain with multiple many-to-many relationships

answered Jun 6, 2016 at 22:57

15 votes

Storing created/retired dates for a large amount of different entities

answered Jul 21, 2015 at 0:59

15 votes

Accepted

Developing a database for a funds transfers business where (a) people and organizations can (b) send and receive money

answered Jul 13, 2017 at 1:59

14 votes

Accepted

How would I track all price changes in a db in order to get the price of 'x' product on 'y' date

answered Jun 22, 2017 at 17:32

14 votes

Accepted

Conceptual ERD Multi-table many to many, or possibly recursive?

answered Jun 29, 2015 at 0:57

13 votes

Accepted

Advice on a basic design, first time database design

answered Jun 19, 2015 at 21:30

13 votes

Accepted

Best data modelling approach to handle redundant foreign keys in a database about Surveys, Questions and Responses

answered Nov 8, 2015 at 4:49

13 votes

Accepted

Integrity constraints in a relational database - should we overlook them?

answered Nov 3, 2016 at 14:23

11 votes

Accepted

Which one is an ER diagram?

answered May 11, 2016 at 19:13

11 votes

Accepted

Redesign the storage of large amounts of sensor data

answered Jun 27, 2017 at 17:22

11 votes

Accepted

When to use unique composite keys?

answered Feb 5, 2017 at 16:32

11 votes

How to avoid a cyclic dependency (circular reference) between 3 tables?

answered Dec 17, 2015 at 23:20

10 votes

How to remove data redundancy in product table if multiple suppliers are there for same product

answered Feb 4, 2016 at 20:15

10 votes

Accepted

Database schema for entities with two possible owner/parent types?

answered Jul 24, 2015 at 3:38

10 votes

Creating a Friendships database that includes a Block Friend option

answered Oct 8, 2018 at 18:53

9 votes

Does the concept of candidate key exist only in theory?

answered Feb 21, 2019 at 22:20

9 votes

Storing two integers as a decimal

answered Apr 27, 2018 at 3:23

9 votes

Accepted

Entity-relationship diagrams and application program functionalities

answered Sep 13, 2017 at 23:36

9 votes

Accepted

Designing a database structure for companies and stock owners

answered Oct 4, 2017 at 13:56

9 votes

Accepted

Third Normal Form: Composite PRIMARY KEY vs System-Generated Surrogate (IDENTITY)

answered Dec 16, 2016 at 20:13

9 votes

Accepted

Should I create multiple tables for different entity states, statuses or stages?

answered Dec 22, 2016 at 19:47

9 votes

Accepted

Designing Database for Longitudinal Survey Data

answered Oct 19, 2016 at 21:33

9 votes

Accepted

Normalizing a table with a field that generally uniquely identifies a row, but is sometimes null

answered Apr 26, 2016 at 23:27

Stack Exchange Network

69 Answers

Why the term "relation(al)"?

Designing a friendships database structure: Should I use a multivalued column?

Modelling a database structure for multiple user types and their contact information

Implementing versioning system with MySQL

How to model an entity type that can have different sets of attributes?

Storing a Billing Address Best Practice in Orders Table

Modeling a scenario in which each Music Artist is either a Group or a Solo Performer

Designing a database for a video game business domain with multiple many-to-many relationships

Storing created/retired dates for a large amount of different entities

Developing a database for a funds transfers business where (a) people and organizations can (b) send and receive money

How would I track all price changes in a db in order to get the price of 'x' product on 'y' date

Conceptual ERD Multi-table many to many, or possibly recursive?

Advice on a basic design, first time database design

Best data modelling approach to handle redundant foreign keys in a database about Surveys, Questions and Responses

Integrity constraints in a relational database - should we overlook them?

Which one is an ER diagram?

Redesign the storage of large amounts of sensor data

When to use unique composite keys?

How to avoid a cyclic dependency (circular reference) between 3 tables?

How to remove data redundancy in product table if multiple suppliers are there for same product

Database schema for entities with two possible owner/parent types?

Creating a Friendships database that includes a Block Friend option

Does the concept of candidate key exist only in theory?

Storing two integers as a decimal

Entity-relationship diagrams and application program functionalities

Designing a database structure for companies and stock owners

Third Normal Form: Composite PRIMARY KEY vs System-Generated Surrogate (IDENTITY)

Should I create multiple tables for different entity states, statuses or stages?

Designing Database for Longitudinal Survey Data

Normalizing a table with a field that generally uniquely identifies a row, but is sometimes null