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.
112 questions
2
votes
1
answer
101
views
How to make the common "organization > project > content" conceptual model handle more subdivisions?
I am working on a system of websites and am back to an age-old problem of how to group the content.
In simplest terms, I am wanting to build something like a hierarchical organization of content, ...
- 2,787
-2
votes
2
answers
153
views
Preventing duplicate customers from company entry vs mobile sign-in [closed]
We have a system where customers can be created in two ways:
By a company — the customer belongs to that company and the company can edit their information.
By a mobile user — the customer has a ...
- 13
1
vote
1
answer
144
views
Fixed vs dynamic properties for a system with customization and changing requirements
Edit: writing a more specific question, as per comment, I guess my question boils down to: are dynamic properties designs appropriate for applications with rich UI and complex business logic (as ...
- 113
1
vote
5
answers
345
views
Data Modeling: Are technical concepts within a tool that implement a business entity entities as well?
I believe this forum is the correct one for my question, based on the community guidelines but let me know if not. It seemed like the best fit.
I am performing a data modeling exercise to formulate a ...
- 229
0
votes
1
answer
629
views
Data Flow in Data Flow Diagram
Consider the following level - 0 dataflow diagram for a patient management system :
Consider the doctor entity, the system provides an appointment report to the doctor. If the system only generates ...
- 43
39
votes
7
answers
15k
views
Modeling first and lastname separately
Which arguments should someone consider when designing a new system and has to either store the name of a person as one field or separately as first/last name?
Pros for single field:
Simpler UI
No ...
- 515
4
votes
5
answers
3k
views
What is the normal form of JSON? What is theory that you can't automate normalizing?
What is the normal form of a typical JSON object?
We often need to convert JSON objects to some set of tables. Once they are tables, the tables have measurable normal forms based on all the usual ...
- 213
-1
votes
1
answer
229
views
Modeling a CSV file: What is the standard? Python or SQL?
I have a wide CSV file of about 350mb, and want to load it into a SQL database and properly model the data to make it easier to use for analysis.
I could split the data into tables with python and ...
- 111
29
votes
4
answers
9k
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 ...
- 549
0
votes
1
answer
103
views
using same table for multiple features a bad coupling?
We are migrating a template that was a mere questions array questions
[
{
type:text,
name:first,
value:What is our name
},{
type:radio,
name:favourite fruits,
value:[
...
- 131
0
votes
4
answers
3k
views
Introducing "status" column to an SQL table changes its definition
I saw this pattern in multiple projects I wrote: I create an SQL model for a certain type of entities and at some point, we realize that there's a need to store multiples types of the same entities. ...
- 143
1
vote
2
answers
1k
views
Should I duplicate or inherit a python dataclass which changes attributes based on the version of an API endpoint?
I'm working on a python library for a REST API.I'm using python data classes to represent the structure of the returned JSON
The v2 of this API returns a slightly different object when compared to v1.
...
- 127
1
vote
0
answers
1k
views
Python - Where do I store data classes which are common across different files?
I'm working on a python wrapper for a REST API. I'm using python data classes to store the shape of the JSON response of each endpoint so developers have features like autocomplete and objects they ...
- 127
5
votes
3
answers
551
views
Rebuilding a legacy application : What about the data model?
I am currently rebuilding from scratch a product catalogue (to feed a shopping website).
The existing legacy system is heterogenous, Long story short : The some products are stored in a FileMaker ...
- 75
24
votes
4
answers
93k
views
ERD: "many" vs "zero or many"/"one or many" crowfoot notation?
Background
I saw this figure describing the different crowfoot notations used in ERD:
I'm not able to find the difference between the "many" notation and the "zero or many. However I was able to find ...
- 565