Questions tagged [data-modeling]
Elaborating passive data structures based on the analysis of data requirements for the purpose of designing and implementing standardised data formats, databases and data processing systems.
7
questions
3
votes
5
answers
4k
views
Designing pricing table (RDBMS agnostic)
I'm designing a price list table for my database.
It will include Customer, Model, Start_date, End_date, Price, Currency, RRP
When I update a new price list, which is sent every now and then (maybe ...
29
votes
4
answers
8k
views
Is there an industry standard for gender model other than male and female?
I am modeling a database that should be used as generic non-functional requisite for all services of the startup company, like persons, users, services and commercial data like coupons, signature ...
12
votes
6
answers
3k
views
How to model more than one 'last name'?
In Spanish-speaking countries we use more than one last name, like:
First name ↘ ↙ Last name
&...
4
votes
1
answer
3k
views
Handling guest users in ecommerce application
I'm currently developing an Ecommerce application and am trying to figure out how best to add a 'guest checkout' feature. The 3 main models that I am wrestling with to add this feature are Address, ...
4
votes
3
answers
7k
views
Graph database keeping historical relationships
I'm starting the modeling of the following problem:
I have many clients (millions) that interact in a network forming a graph. At the highest granularity of my business problem, each realationship ...
1
vote
2
answers
1k
views
How to document a NoSQL document-based data model?
How do you document the logical data model of a document-oriented database like MongoDB?
For relational databases, Entity-Relationship diagrams or UML class diagrams are used.
What is the practice for ...
1
vote
1
answer
10k
views
Data Flow Diagram for patient information system for a hospital
I have an example for a DFD for a patient information system implemented in a certain hospital. The below figure, represents the overview diagram (level 0-diagram, if we consider that the first level ...