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
153 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
1 vote
2 answers
386 views
Should you ever have one-to-one relationships between entities?
One-to-one relationships occasionally evolve into one-to-many relationships. Once that happens, your team has a tricky job of refactoring the datastore, the backend to allow that change. For example, ...
- 2,030
3 votes
3 answers
346 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
2 votes
1 answer
1k views
One and only one vs One in crow's foot notation
Am I using one and only one correctly? I have read so many articles online on differences between one and only one vs one and I'm still confused. I.e. a customer can exist with zero, 1 or many (...
- 29
0 votes
1 answer
333 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
0 votes
1 answer
591 views
Architecture for storing generic data
(I am facing this issue with code written in Swift, but would appreciate any high-level pseudocode solution, just so that I may wrap my head around the architecture) I need to find an architecture ...
- 117
15 votes
10 answers
11k 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-...
- 406
1 vote
1 answer
196 views
Implementing shared content in a system with several users
I am working on a system that allows users to track their musical practice. The system allows users to create 'exercises' that store a few pieces of information like name, description and external ...
- 119
0 votes
1 answer
112 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
-1 votes
2 answers
242 views
Is it normal and good practice to enlarge the amount of columns when adding new features
There is a table named is A with 40+ columns, among which around 10 are columns of hierarchical levels, in a data analysis platform maintenance and development ( legacy ) project. Due to development ...
- 1,935
0 votes
0 answers
42 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 ...
-2 votes
2 answers
293 views
OOP: How to Manipulate Objects Using ORM Techniques?
about those objects and arraylists inside the classes, derived from one-to-many relationships, using the ORM techniques, what's the best way to deal with them at the time of setters and validation ...
- 31
0 votes
1 answer
668 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
1 vote
4 answers
645 views
Thinking about data as object vs table row [closed]
It often happens that we have a set of structured data. Let's say our data is about charitable organizations. I could turn it into a list/set of objects/structs: struct Charity { let name: String ...
2 votes
1 answer
144 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