Skip to main content

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.

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 ...
Hyungsup Kim's user avatar
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 ...
NaN's user avatar
  • 549
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   &...
Pablo Olmos de Aguilera C.'s user avatar
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, ...
Rnice4christ's user avatar
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 ...
Henrique Barcelos's user avatar
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 ...
ssn's user avatar
  • 71
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 ...
AAAA's user avatar
  • 145