All Questions
10 questions
0
votes
1
answer
509
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 ...
- 117
1
vote
1
answer
4k
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 ...
- 111
0
votes
1
answer
359
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 ...
- 49
2
votes
2
answers
1k
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 ...
- 129
1
vote
2
answers
125
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 ...
- 119
2
votes
1
answer
394
views
many to many relationships in ER Diagramme
Relational database management systems can’t have M:M relationships, so before converting a data model to a database in Access, SQL Server, mysql, or other relational DBMS, the data modeler must solve ...
- 406
1
vote
1
answer
143
views
How to model shared and unique options for a family of products for a relational database?
I have a family of products that currently houses 3 product lines. All 3 product lines share the same 4 options, but on top of those, each product line has 1, 2, or 3 different options respectively, ...
- 8,257
1
vote
4
answers
1k
views
Best way to model "Composite Skus"?
I have a SKU record which keeps track of raw materials used, pricing, cost, etc. An example SKU would be a Hamburger (1 bun, 1 patty, 1 oz ketchup, costs $11 make, priced at $4, etc).
I need to add ...
- 119
1
vote
3
answers
219
views
How can I model IS-A relationship on a ledger, when having different classes of products?
This is a question on how to model database entities and relationships when it comes to storing persistent data and dealing with differently-handled types of products.
Use Case
Company sells various ...
- 8,257
0
votes
1
answer
351
views
Relationships in a Chen ERD
I am working on a Chen ERD to model our organizations merchandise. Our central entity is a Style. We have supplemental entities of Color and Season.
I am defining our assortment as the ...
