Skip to main content

All Questions

Tagged with
1 vote
5 answers
296 views

Data Modeling: Are technical concepts within a tool that implement a business entity entities as well?

I believe this forum is the correct one for my question, based on the community guidelines but let me know if not. It seemed like the best fit. I am performing a data modeling exercise to formulate a ...
Steven's user avatar
  • 229
0 votes
0 answers
23 views

An IoT client and MVC-based server. Data model with different fields per type?

The problem Let's assume such scenario: List of IoT devices (one model?) Each list item has (among other fields) a type field Depending on the value in the type field, device may report different ...
trejder's user avatar
  • 2,406
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 ...
Tygreton's user avatar
  • 117
1 vote
1 answer
204 views

How to avoid code duplication from handling "structually similar types" in Scala?

Often, when programming, you'll have different degrees of information to you in different contexts. For example, a web server may have two routes, which recieve information about a Person, one of ...
Joe's user avatar
  • 174
2 votes
1 answer
2k views

Optional relationship on ERD diagram

Upon generating an entity-relationship diagram of my database I observed several occurrence like this: This diagram (in IDEF1X notation) shows the following: Our team's DB convention is that each ...
Michael Sorens's user avatar
0 votes
2 answers
282 views

Creating a "pass-through" dynamic model

We have a layer that exists in our architecture that, for lack of a better term, bears the responsibility of defining the common models. In other words, when systems need to communicate, rather than ...
McArthey's user avatar
  • 117
0 votes
0 answers
170 views

What kind of diagram best represents the field-level mapping from one system component to another?

In my environment, we have multiple systems developed independently by different teams. Those teams frequently recreate the wheel because they're building applications, not building blocks. As a ...
Jason's user avatar
  • 1
3 votes
3 answers
280 views

Modeling content management domain

The domain is more or less straightforward — I have an article (or rather several types of articles) that I want to edit and publish. Published article is exposed through an API to public. The thing I ...
Alexey Golev's user avatar
0 votes
1 answer
128 views

Software architecture entity connections [closed]

For learning purpose I want to create an app. So I thought I will do something real easy to learn a lot about object oriented programming and modelling. After some thinking I had the idea to do a ...
caramba's user avatar
  • 141
2 votes
5 answers
8k views

Is it Considered Good SQL practice to use GUID to link multiple tables to same Id field?

I want to link several tables to a many-to-many(m2m) table. One table would be called location and this table would always be on one side of the m2m table. But I will have a list of several tables ...
Mallow's user avatar
  • 579