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 ...
- 136k
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 ...
- 982
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 ...
- 259
14
votes
Accepted
What is the normal form of JSON? What is theory that you can't automate normalizing?
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 ...
- 82.3k
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 ...
- 59.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 ...
- 221k
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 ...
- 221k
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 ...
- 221k
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 ...
- 2,605
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 ...
- 557
5
votes
What is the normal form of JSON? What is theory that you can't automate normalizing?
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 ...
- 105k
5
votes
Preventing duplicate customers from company entry vs mobile sign-in
There is no proper way to do this automatically. How would you identify the same natural person? And if you could, how would you get the user's consent to merge the account? Maybe they want two ...
- 958
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 ...
- 2,983
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 ...
- 34.7k
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 previous ...
- 82.3k
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 ...
- 27k
3
votes
Accepted
Should I use a physical units library for modelling domain properties if I don't need to perform computations on them?
Usually the reason to support multiple units of measure (aside from measuring things) is to support localization or conversions between systems (e.g. miles to kilometers).
The conversions from one ...
- 46.6k
3
votes
Accepted
Proper modeling and name convention for an intermediate table between intermediates
As I assume naming the relationship has some value, possibly, to communicate the model to business people, it needs to have a better name. It's not easy to guess all the details from your description, ...
- 1,803
3
votes
How multi-valued and derived attributes are denoted in crow foot's notation of ERD?
I was searching for the same answers for a while without much success and found @reaanb's answer quite satisfying and logical. But then I came across this in a book[A] and realised that in fact Crow's ...
- 131
3
votes
Accepted
Tender Type vs Payment Method/Type
This is not an opinion based question, as there are clear objective arguments to guide the choice
Payment method ?
PaymentMethod is simple, accurate, and understood by anybody. I've seen it in many ...
- 82.3k
3
votes
Accepted
Optional relationship on ERD diagram
According to this IDEF1X cheat sheet, the diamond shows a relationship of an optional iam_project with zero, one or many iam_project_rules.
The optional can only be on the iam_project side, since ...
- 82.3k
3
votes
How to represent a data model?
There is no absolutely universal way to describe a specific data model, which is completely platform and system independent.
From a very high point of view, the UML could be used, which is a very ...
- 10.4k
3
votes
Accepted
Data Flow Diagram for patient information system for a hospital
You seem to be mislead by the name of the process Maintain patient info, which suggests that patient records are created there.
If we forget about the assumption and look at the flows involving the ...
- 82.3k
3
votes
Accepted
How to draw an aggregation relationship in the Crow's Foot Notation?
In short
There isn't aggregation and generalization in the crow's foot notation. The strength of crow's foot its simplicity: a notation for the smallest common denominator of how to related entities....
- 82.3k
3
votes
Thinking about data as object vs table row
A data structure is not an object. It has nothing to do with object-orientation and you shouldn't think of it as an object either.
I know what you mean though, you can sort-of write it down with an ...
- 12.4k
3
votes
Accepted
Tradeoff: Fetching less data vs having a simpler data model
I think you have the wrong decision criteria in focus.
You are trying to make this decision based on a few additional queries which may be required to determine the vehicle type. This is first and ...
- 221k
3
votes
Data Modeling: Are technical concepts within a tool that implement a business entity entities as well?
An obvious step is discovering the entities.
[...]
They're clearly conceptual things. But they are also implementation details that can and will change over time (whereas articles and adverts are ...
- 12.7k
3
votes
Accepted
Data Flow in Data Flow Diagram
The strange thing in this diagram is that it is a hospital where patients seemingly maintain all their own records, and where no information ever flows directly between the patient and the doctor. ...
- 12.7k
3
votes
How to make the common "organization > project > content" conceptual model handle more subdivisions?
I am wanting to build something like a hierarchical organization of content
This is your mistake. You jump to a familiar solution (which happens to be wrong most of the time), and then you try to fit ...
- 139k
2
votes
How to model relational data that can be organized in multiple ways?
While I haven't personally had the need, I have heard Domain Driven Design mentioned more than once in meetup talks by programmers for local research organizations with similar issues. Specifically, ...
- 149k
Only top scored, non community-wiki answers of a minimum length are eligible