Skip to main content
70 votes

Is there an industry standard for gender model other than male and female?

First consider why you need to collect this data. Do not collect it if it is unnecessary. For example: You would like to address the individuals properly. Then, simply ask for their preferred form of ...
amon's user avatar
  • 135k
55 votes

Modeling first and lastname separately

First name and last name are not useful concepts. Names work differently in different countries. In most Asian countries, the family name is written first, but it is still used for sorting—so you may ...
Jan Hudec's user avatar
  • 18.3k
32 votes

Modeling first and lastname separately

The only argument that matters is what are the requirements of your system? Do you need to deal with just one culture? If so, conform to that culture. Otherwise plan for internationalization (as ...
Becuzz's user avatar
  • 4,835
26 votes
Accepted

Is there an industry standard for gender model other than male and female?

Sometimes the term gender may be used when sex is meant. Sex is defined by a person's biological traits whereas gender is determined by identity. The standard for sex is codified by the ISO/IEC 5218 ...
Wes Toleman's user avatar
24 votes

ERD: "many" vs "zero or many"/"one or many" crowfoot notation?

The 2 first relations, One and Many, have an unspecified lower bound. So when using them you leave an ambiguity of whether they are mandatory or optional. This ambiguity is useful in modeling, in ...
Christophe's user avatar
  • 78.4k
16 votes
Accepted

How should I design an ordered list resource in a restful service?

Representing an ordered list is one of the difficult problems with relational databases. Adding an position property to the list-membership relation is the most common way to do this, since you can ...
amon's user avatar
  • 135k
14 votes

Is there an industry standard for gender model other than male and female?

As you mentioned Healthcare, it's worth looking at the NHS Data Dictionary for an example, used in the UK as one of the national coding systems for health data (alongside SNOMED). Depending on ...
Callie J's user avatar
  • 259
12 votes
Accepted

What is the normal form of JSON?

In short JSON is a data representation according to a schema-less syntax without predefined semantics. On the opposite, normal forms are defined for abstract data model with a relational semantic ...
Christophe's user avatar
  • 78.4k
10 votes
Accepted

How to store sequential timespans in a database?

Not storing the end date and using the start date of a different record/row make each individual row hard to reason about. Querying gets harder. SQL Server 2012 introduced LEAD and LAG to help with ...
Flater's user avatar
  • 52.5k
9 votes

Rebuilding a legacy application : What about the data model?

Think big, start small. The most effective way I know for tackling the described situation is the following approach: Scetch your "vision" of the full data model, but do not implement it ...
Doc Brown's user avatar
  • 209k
9 votes
Accepted

Data Modeling: Are technical concepts within a tool that implement a business entity entities as well?

Your original question gave the impression you were trying to model entities without knowing how they will be used. That's a classic road to hell, paved with good intentions. Data modeling requires ...
Doc Brown's user avatar
  • 209k
8 votes

Modeling first and lastname separately

I agree with a lot of what @JanHudec said, although I'd like to expand on that a bit: You need to know what your real requirements are, but it is easier to combine information than it is to split it ...
Berin Loritsch's user avatar
8 votes
Accepted

Modeling a CSV file: What is the standard? Python or SQL?

It may be unsatisfying for you, but for this kind of task (as well as for the majority of other software engineering tasks), the answer is There is no standard. I have actually seen both kind of ...
Doc Brown's user avatar
  • 209k
7 votes

Is there an industry standard for gender model other than male and female?

If you do not need the gender, do not ask or store it. As you mentioned laws, nowadays laws in various countries increasingly disourage use of personal information unless it's essentional to the ...
max630's user avatar
  • 2,587
6 votes

Is it acceptable to break MVC by storing data in the DOM in order to reduce load on the Database Server, ever?

One can never trust input from a client, especially sensitive input like prices. If you want to cache information to avoid stressing the database server (did you measure that this is actually an ...
D. Jurcau's user avatar
  • 557
5 votes

ERD: "many" vs "zero or many"/"one or many" crowfoot notation?

I think people just use them just when they don't care enough about being specific. Personally I avoid the first two examples on your list entirely. For your example, I would assume -- from the ...
Darien's user avatar
  • 3,473
5 votes
Accepted

How multi-valued and derived attributes are denoted in crow foot's notation of ERD?

It's a common misconception that Crow's foot and Chen's notations are equivalent alternatives. They actually address different stages of modeling. Crow's foot notation is used in table diagrams (...
reaanb's user avatar
  • 252
5 votes

when should data modeling be done?

1-Should data modeling (e.g ERD) be ignored at the beginning of a project and then be done later after the project is complete, especially if the project developers don't have all the details about ...
Narender Parmar's user avatar
5 votes

Modeling first and lastname separately

If you have more than one way to display and/or utilize the name(s), then you'll probably need separate fields. Along with the data entry, you could provide feedback to show the user how it will be ...
JeffO's user avatar
  • 36.8k
5 votes

What is the normal form of JSON?

Zeroth. First Normal Form says that data should be atomic. As in a single boolean, a single number. Even a single string is already questionable. It depends on how it is used, a string could be used ...
Jörg W Mittag's user avatar
4 votes

RESTful API/Data Modeling - How to model an subordinate resource that will only ever have one element

The POST /documents/<documentId>/revisions endpoint has to also modify the DocumentDrafts table to reflect the fact that the document is now in a "clean" state and can be modified by another ...
Eric Stein's user avatar
  • 3,572
4 votes

Graph database keeping historical relationships

Your problem of historical data is in fact quite common: business related data is often related to time. Snaphsot approach One way to handle this is to take snapshots. It's the solution proposed by @...
Christophe's user avatar
  • 78.4k
4 votes
Accepted

Data modeling for NoSQL document database

Modeling data for document database(say MongoDB), are these phases still valid? Yes, they are. And it is much more important to do them right before the first release. The reason is that in a ...
Timothy Truckle's user avatar
4 votes

when should data modeling be done?

Data modelling is the first thing you do, not the last! Every part of 99.9% of all applications is either manipulation of the data or some kind of presentation of it. If your developers don't ...
LoztInSpace's user avatar
  • 1,169
4 votes

Modeling first and lastname separately

Apart from what @JanHudec has pointed out and with which I agree, it's also worth noting that in many countries people have more than one last name, so single last name field might be irrelevant. E.g. ...
KjMag's user avatar
  • 187
4 votes

Modeling first and lastname separately

At add even more to what @JanHudec and @KjMag have pointed out, even in cultures/languages very close to English this becomes a problem. Take German for instance. You have the concept of Vornamen, ...
Hangman4358's user avatar
4 votes

many to many relationships in ER Diagramme

I think this is a judgment call. My opinion is that, if we have strictly cross-reference table (table consisting only of FKs to two tables), then leave it as a many-to-many relationship for the sake ...
Vladimir Stokic's user avatar
4 votes
Accepted

Handling guest users in ecommerce application

Both options will work well, with the following inconvenience: The guest account requires different behavior: the application must ensure that a guest user shall not be able to see or modify ...
Christophe's user avatar
  • 78.4k
4 votes
Accepted

What is an example giving the difference between Domain Model and Data Model?

I've seen many articles describing differences between Domain Model and Data Model. However none of the articles have picture representations showing difference. Brian Lawler's article Domain First ...
VoiceOfUnreason's user avatar
4 votes
Accepted

Is Excel data model as good as or better than Microsoft Access?

I've shied away from Access because my team is not comfortable using SQL and overall dislike the Access Interface. Here's your answer. There is a strong argument to use Excel because it is what your ...
John Wu's user avatar
  • 26.6k

Only top scored, non community-wiki answers of a minimum length are eligible