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
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
-2
votes
2
answers
135
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 ...
1
vote
2
answers
306
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, ...
3
votes
3
answers
242
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 ...
2
votes
1
answer
962
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 (...
0
votes
1
answer
308
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 ...
0
votes
1
answer
543
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 ...
13
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-...
1
vote
1
answer
164
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 ...
0
votes
1
answer
109
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 ...
-1
votes
2
answers
209
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 ...
0
votes
0
answers
27
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
264
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 ...
0
votes
1
answer
626
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 ...
1
vote
4
answers
606
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
123
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 ...