MDCCL's user avatar
MDCCL's user avatar
MDCCL's user avatar
MDCCL
  • Member for 8 years, 10 months
  • Last seen more than a month ago
  • Ibero-America
33 votes
Accepted

Why the term "relation(al)"?

32 votes
Accepted

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

28 votes

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

26 votes
Accepted

Implementing versioning system with MySQL

24 votes
Accepted

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

21 votes
Accepted

Storing a Billing Address Best Practice in Orders Table

20 votes

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

18 votes
Accepted

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

15 votes

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

15 votes
Accepted

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

14 votes
Accepted

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

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

14 votes
Accepted

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

13 votes
Accepted

Advice on a basic design, first time database design

13 votes
Accepted

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

11 votes

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

11 votes
Accepted

Redesign the storage of large amounts of sensor data

11 votes
Accepted

When to use unique composite keys?

11 votes
Accepted

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

11 votes
Accepted

Which one is an ER diagram?

10 votes

Creating a Friendships database that includes a Block Friend option

10 votes

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

10 votes
Accepted

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

9 votes
Accepted

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

9 votes

Does the concept of candidate key exist only in theory?

9 votes

Storing two integers as a decimal

9 votes
Accepted

Entity-relationship diagrams and application program functionalities

9 votes
Accepted

Designing a database structure for companies and stock owners

9 votes
Accepted

Designing Database for Longitudinal Survey Data

9 votes
Accepted

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