Questions tagged [relational-modelling]
Data structures that focus on the relationships between entities in the system, as opposed to attributes within an entity, or phases in a process, for example. Relational databases are popular application of relational modelling.
22 questions
-2 votes
2 answers
152 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
3 votes
3 answers
313 views
Aligning domain model to data model. Is my data representation wrong?
Engineering Community, I am currently writing my bachelor's thesis on microservices and DDD (this is not the actual topic, but it is part of it). The language I am writing in is Rust, but that is ...
- 39
0 votes
1 answer
321 views
Decoupling modules of a monolith
As part of an migration from .NET Framework to .NET Core we're looking to decouple elements of our monolith into more manageable modules. Ideally following a clean architecture/DDD/microservice ...
- 103
14 votes
10 answers
10k views
Is there any benefit to a separate table that is one-to-one with the primary data table?
I've inherited a system with an Oracle relational database with a couple of tables modeled like I've sketched below, where there's an entire child table that only stores a single status code in a one-...
- 396
0 votes
1 answer
111 views
Designing a model for a small business which provides multiple services which generate documents [closed]
I am designing a system for a company which provides multiple services to users, all of which generate a document. The documents all have a validity period. Some of the services can be grouped, and ...
- 61
0 votes
0 answers
33 views
Modelling DropDowns in ef core
Im working on an application which essentially fills a giant government/court form. Lets say i have an an Entity Unemployment and Unemployment has a ... thing "Reason why" and there are 6 ...
0 votes
1 answer
656 views
Confused over qualification association in conceptual schema UML
I am getting confused at qualification association. I perform qualification when I need to remove many-to-many relationship or when the PK of a particular table is not able to be uniquely identify a ...
- 11
2 votes
1 answer
128 views
Best notation to store/read/compute complex relationships
I have created an application in which users and tasks can be entered. A task should be be assigned to one or more users. If more users can do a task, the task should be assigned in such a way that it ...
- 131