All Questions
Tagged with database-design data-modeling
33
questions
-1
votes
1
answer
355
views
How to model a ternary relationship in a graph-based paradigm?
Consider a context where we have Users saving Questions and adding personal Tags to them.
In a graph-based paradigm, a first approach could be something like:
(User)-[SAVES {tags}]->(Question)
...
0
votes
1
answer
66
views
Is there a difference between these two data models?
Let us say I want to store on a database a userID, their nationality and if they are from the UK their UK passport number.
I could model this by having one table with userID as primary key, ...
2
votes
1
answer
810
views
How to draw an aggregation relationship in the Crow's Foot Notation?
I was stuck on a relation description and unable to model it in the Crow's Foot Notation:
Each individual vehicle is a particular model of a particular brand offered by the company (e.g., the XF is a ...
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 ...
0
votes
1
answer
452
views
What kind of Relations should I have in my E/R Diagram
I am trying to create an Entity/Relationship Chen Diagram for a new APP. Scope is simple enough.
I will have multiples types of users login through the same Login Form.
What I decided to do... Is ...
1
vote
1
answer
3k
views
SQL Database schema for Catering/Menu management
Background
I'm building a Private Chef booking service where you can book a Chef to cook you a custom Menu. I'm having trouble creating a SQL db schema that accurately represents the domain while ...
2
votes
1
answer
2k
views
Optional relationship on ERD diagram
Upon generating an entity-relationship diagram of my database I observed several occurrence like this:
This diagram (in IDEF1X notation) shows the following:
Our team's DB convention is that each ...
2
votes
3
answers
147
views
Many-to-many assignments in user system
I have a few software architecture/design questions related to a technically quite simple problem. We already have all the functionality implemented properly, however from a design perspective it is ...
0
votes
1
answer
344
views
How to create a flexible datamodel?
I'm trying to create a flexible datamodel and i'm not sure what's the right approach.
My application is used by several clients (big and small). Big clients need all the seperate layers, but small ...
2
votes
2
answers
870
views
Index / Unique on `deleted_at` column?
We have an Accounts table in a Postgres DB that has a unique index on user_id and product. Users can have many accounts, there's no product table. Occasionally users will create an account ...
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 ...
2
votes
3
answers
2k
views
How to store sequential timespans in a database?
How can consecutive periods of time (defined by a start and end date) be stored in a database?
For example:
from 2018-01-01 00:00:00+01:00 until 2018-06-01 00:00:00+02:00
from 2018-06-01 00:00:00+02:...
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, ...
1
vote
2
answers
124
views
Database Modeling Question
I am having a doubt while creating a DB, and I would like to know if there are objective arguments that could help me mak a better decision.
Case
A project that can have several revisions, so I ...
3
votes
2
answers
223
views
How to model relational data that can be organized in multiple ways? [closed]
I’m working in a project that is building a system to manage data (10-20 million records) collected by a research organization. One of the challenges is that even though the data is superficially ...