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.
111
questions
38
votes
7
answers
14k
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 ...
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 ...
24
votes
4
answers
83k
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 ...
16
votes
2
answers
8k
views
How should I design an ordered list resource in a restful service?
I've run into this same problem over and over again and I haven't found a solution that I really felt was optimal.
Say in an app, you have an ordered list and you let the user change that order by ...
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
&...
9
votes
2
answers
10k
views
Database Design for Inventory
I am starting to design a typical product based MySQL database but I keep running in circles on how to design the tables.
I have many types of products
Jeans
Tshirts
Dresses
Which have many of the ...
6
votes
2
answers
777
views
In an MVC, should models use libraries, or should libraries use models?
When I build a RESTful API, I use an MVC pattern. And in order to make controllers skinny and code reusable outside of the API (e.g. in Cron tasks), I put much of my code into services (commonly known ...
6
votes
1
answer
146
views
Should an entity id contain information about entity?
If an Entity doesn't have an unique ID, we usually use auto increment number to distinguish entities. But sometimes, we have to hand that ID over to people so that they can use it. So using auto ...
5
votes
3
answers
466
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 ...
5
votes
2
answers
16k
views
How multi-valued and derived attributes are denoted in crow foot's notation of ERD?
In Chen notation multi-valued attributes are denoted by double eclipse(oval) and derived attributes are denoted by dotted eclipse(oval), but how they are denoted in crow foot notation?
Also how ...
5
votes
3
answers
265
views
Is an enterprise-wide data model truly feasible?
I've consulted for a number of Fortune 500 and 100 companies all of whom have made some kind of effort at creating a "Master" data model even to the point that they'd attempt to have all applications ...
5
votes
1
answer
4k
views
Data Model for selling groups of products as one product
Say I have an e-commerce with a data model like the following, which allows a Sale to describe how a single Product is sold. This division allows a product to be sold multiple times in different ways (...
4
votes
5
answers
2k
views
What is the normal form of JSON?
This is going to sound like a trivial question, but I like to think it's actually a deep one. The simple quesiton is, "What is the normal form of a typical JSON object?" For reference, I ...
4
votes
3
answers
128
views
Using Multiple 'Sub-types' vs a larger single type?
I have a user model in an application that I'm working on, which currently uses sub-types to encapsulate properties depending on what type of user you are - I just can't help but think that this is ...
4
votes
1
answer
668
views
What happens to database design process when ORM tools are used?
I have learned about database design, including normalization during my undergraduate course. When we have to model a database for a system, we can start with an ER model and then convert it to the ...