2,979 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
Advice
0
votes
3
replies
44
views
Review FMCG business inventory system DB design normalization and ERD
My case study project inventory system tracks stock and updates stock after every sale of a FMCG (Fast-moving consumer goods) business. Since it is FMCG, they get stock by consignment and the database ...
1
vote
1
answer
99
views
How to configure model with two principals related to the same child? [closed]
I've got a class model with two principal classes (PrincipalEntity1, PrincipalEntity2) which are both related to the same child entity (TwiceDependentEntity). PrincipalEntity2 is related directly to ...
0
votes
0
answers
46
views
How to store a list of references per attribute in a relational database
I'm designing a relational database and I have entities with a fixed set of attributes that may need multiple "quotes" or references from documents that justify their values.
For example, a ...
1
vote
1
answer
52
views
Unidirectional ER relation
I have 2 tables: A and B.
A sees B and for each item in A we have N items in B (one-to-many).
B doesn't see A (no reference at all).
How do I represent this with (any) ER notation?
I have the nasty ...
1
vote
2
answers
39
views
Where to store the "best-before-date" in my ER-Model
I have a model about a butcher shop. The entities refer to
"Bestellung" => "Order" (Like order to get more inventory)
"Lieferant" => "Supplier"
"...
1
vote
1
answer
65
views
How to Determine Minimum Number of Tables for an SQL Schema
I am just learning how to translate ER models into SQL schemas. Now, I have come upon an exercise that has prompted me to determine the minimum number of SQL tables that would be needed to accurately ...
0
votes
1
answer
93
views
Is there a way show that two entities can be linked via a common third entity?
I have just started learning ERD diagrams and need some help. In this exercise, I am trying to design an ERD diagram for a car rental company. The exercise is to purely use ERD design and ...
0
votes
0
answers
24
views
Power BI Call Elements not working properly
Note: Stakeholder and Title have been highlighted out due to data privacy.
I have the following table visual in one of my Power BI reports.
The relationships are as follows:
[GAL]Email = [Stakeholder]...
-1
votes
1
answer
135
views
How to draw an ER diagram where there are 2 entities with exactly same attributes
Each appliance is classified as either: Kitchen appliances, Entertainment appliances, and it’s important to keep track of their type.
Kitchen appliances and Entertainment appliances have details about ...
0
votes
1
answer
28
views
Database modelling for 2 many-to-many relations that have their own one to many relation
With reference to the attachment, data has a many to many relationship with both entities. What would be the right thing to do?
To add more context, each data entry can have 0, 1, 2, ..., N categories,...
0
votes
0
answers
20
views
Clarifying Access Control and Specialization in Conceptual Modeling for Client and Registered Client Entities"
enter image description here
My question is: when we have a specialization like in my case "registered_client", will only this person have access to the order, plan, and payment ...
-1
votes
1
answer
72
views
In ER diagram, is order and cart relationship are weak entity relationship?
In an entity relationship (ER) diagram, is the relationship between Order and Cart considered a weak entity relationship? Because order depends on the cart.
I analyzed the relationship between Order ...
0
votes
0
answers
73
views
EF many to many relationship in Web Api using swagger
I have a problem when I'm trying to set the many-to-many relationship in EF Core, and catch the result in Swagger.
public class Book
{
[Key]
public int BookId { get; set; }
public string? ...
0
votes
0
answers
70
views
How to Represent Role-Specific Relationships in an ER Diagram?
I’m new to drawing ER diagrams.
In my case, the Staff entity has an attribute called role with values like Head of Department, Dean, and Admin.
The Department entity should only have a relationship ...
0
votes
1
answer
53
views
Unidirectional Lazy @OneToOne @MapsId on JPA
I have 2 entities User and Doctor, as you may guess, my idea is having a OneToOne relationship between them, my step to step is creating first a User, and after the User is activated, create a Doctor ...