All Questions
Tagged with data-modeling relational-database
14
questions
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 ...
3
votes
2
answers
768
views
Is Excel data model as good as or better than Microsoft Access?
I'm working with several Excel worksheets and workbooks that need to consolidated or linked to each other. These workbooks will track client interactions for different team members.
I did the initial ...
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 ...
2
votes
1
answer
2k
views
Proper modeling and name convention for an intermediate table between intermediates
I have 4 entities: Event, Message, Flow and Document.
Event table stores a limited (seeded) number of records. Message has many events and each event can be related to many messages. The name ...
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 ...
2
votes
1
answer
380
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 ...
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 ...
1
vote
1
answer
138
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, ...
2
votes
3
answers
614
views
Database design for changing user roles
What database design would you suggest for the following example?
Example: Imagine a bus with some people inside. Every person has some attributes like name, etc. Also there are driver- and passenger-...
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 ...
1
vote
3
answers
217
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 ...
0
votes
1
answer
344
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 ...