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.
18
questions
0
votes
1
answer
262
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
334
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
11
votes
10
answers
7k
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-...
- 366
1
vote
1
answer
147
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
105
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
193
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,865
0
votes
0
answers
25
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
250
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
487
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
447
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
117
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
0
votes
1
answer
72
views
eCommerce data modeling - is it common to duplicate product properties in line items?
Suppose I have the following entities in a commerce data model:
BaseProduct (PK id, price, name)
LineItem (PK id, FK product_id, price, name)
Order (PK id, line_items)
An Order includes one or many ...
- 101
1
vote
2
answers
138
views
Class-diagram dependencies between classes
Can requirements be expressed in class-diagrams?
For example:
A student can enroll in a class.
There are different classes.
Some classes have dependencies, e.g. you can't go to Spanish III before ...
- 137
0
votes
2
answers
104
views
How to use strict schema with seemingly fluid data type
Our company is trying to find a good generic way to have Many-to-One data for an entity. For example, a user might have 1 primary email, but many other emails also attached to their account.
So we ...
- 277
0
votes
1
answer
825
views
Double way parent child relationship in Django
I am building an app to register and update children information, this information is to be provided by their tutors. Every child can have multiple tutors, and a tutor can be a tutor for multiple ...
