Movatterモバイル変換

Question 1

-2votes

2answers

152views

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 ...

user93865

13

askedAug 13 at 8:08

Question 2

3votes

2answers

424views

What is a good approach to sync remote API data to a database?

Problem statementWe have a remote API that can be queried to fetch some arbitrary objects (we're expecting around 500 thousand records). Our application needs fast access to this data (faster than ...

Jans Rautenbach

141

askedApr 7 at 12:18

Question 3

2votes

3answers

420views

Should I break a large user table into smaller tables for specific roles and information?

I am designing a database for a system that has a users table. Currently, the table has around 50 columns, which include:Personal information (e.g. name, email, phone_number, address, etc.)Work-...

JayDev95

131

askedDec 9, 2024 at 21:51

Question 4

2votes

1answer

1kviews

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 (...

Brendon

29

askedOct 31, 2024 at 20:26

Question 5

17votes

8answers

4kviews

How do we distinguish between "not filled in" and "unknown" in our data store?

In our domain model "not filled in" and "unknown" are two different concepts. For example, time of death may be missing or, on the other hand, may be filled in as "unknown&...

Sergey Zolotarev

2,030

askedOct 16, 2024 at 8:36

Question 6

11votes

13answers

7kviews

Does it ever make sense to have a one-to-one obligatory relationship in a relational database?

To illustrate what I mean, imagine a group of students and a group of professors in some kind of a traineeship. Every professor is to mentor one student and every student has to be mentored by one and ...

user24881603

121

askedSep 18, 2024 at 15:21

Question 7

-1votes

2answers

195views

Should uniqueness validation be on the database level or backend codebase level in data import

There is a kinda ETL task of importing data from csv to the database in project with legacy codebase and legacy database**. Data should be validated before persisting to database.Validation includes ...

Rui

1,935

askedAug 11, 2024 at 4:56

Question 8

0votes

1answer

101views

if an entity depends on two other entities(that have a relationship between them) should I make the enitity depend on the relationship instead?

If I have three entities (end-user, country, tier) in my system that has relationships as follows:Where each country has its own tiers with specified points per year, and each end-user has a country ...

siba36

109

askedJul 25, 2024 at 20:34

Question 9

0votes

0answers

83views

How to restructure a schema in order to support conditional (one of two tables) relations

I've been stuck on this for a while now so I decided to ask for some help.My SetTemplate needs to EITHER be connected directly to exerciseTemplate OR connected to exerciseTemplate through a ...

Jocko

11

askedJul 9, 2024 at 15:10

Question 10

2votes

1answer

436views

Does it make sense to use a graph database (Neo4j) for a diagramming app?

I am developing a diagramming application and want to optimize operations with the Nodes and Relations of the diagram. Currently, I am using a relational database with tables for diagrams and nodes. ...

Maksim Murza

29

askedJun 5, 2024 at 9:09

Question 11

3votes

1answer

616views

Object-oriented programming design with relational database tables

I want to understand what is considered best-practice to better align with OOP when handling relational databases. I cannot find any online examples where classes and a more maintainable/re-usable ...

Yannis

147

askedMay 31, 2024 at 18:49

Question 12

-1votes

3answers

238views

Mixing up UML and non-UML diagrams

When designing a data-intensive software, or any kind of software, regardless of the platform, is it appropriate to mix UML and non-UML diagrams together in the design document of the software?For ...

Acemad

115

askedMay 31, 2024 at 17:41

Question 13

0votes

1answer

79views

Database Modeling for Application with Many Integrations

I’m working on an application that requires many 3rd-party integrations. I’m using Postgres to store these API responses but am having trouble for a number of reasons.These objects are frequently ...

Jack

109

askedMar 31, 2024 at 0:55

Question 14

-2votes

2answers

271views

Designing a database schema for a website related to my town's history

I am working on digitizing old photographs, articles, ephemera, etc. related to my town's history, and I've been tasked to put these scans I've made onto a website for the public to see. There are ...

EdmundF

13

askedDec 12, 2023 at 3:21

Question 15

3votes

2answers

228views

how to deal with schema/constraint changes in insert-only Relational DBs?

as per request, I'll reduce this whole set of questions to 1-2 core points (thanks for the feedback ;)).I'm considering using insert-only tables for keeping the history of my data. while the ...

SirCodeALot

41

askedNov 16, 2023 at 9:36

Movatterモバイル変換

Stack Exchange Network

Questions tagged [relational-database]

Preventing duplicate customers from company entry vs mobile sign-in [closed]

What is a good approach to sync remote API data to a database?

Should I break a large user table into smaller tables for specific roles and information?

One and only one vs One in crow's foot notation

How do we distinguish between "not filled in" and "unknown" in our data store?

Does it ever make sense to have a one-to-one obligatory relationship in a relational database?

Should uniqueness validation be on the database level or backend codebase level in data import

if an entity depends on two other entities(that have a relationship between them) should I make the enitity depend on the relationship instead?

How to restructure a schema in order to support conditional (one of two tables) relations

Does it make sense to use a graph database (Neo4j) for a diagramming app?

Object-oriented programming design with relational database tables

Mixing up UML and non-UML diagrams

Database Modeling for Application with Many Integrations

Designing a database schema for a website related to my town's history

how to deal with schema/constraint changes in insert-only Relational DBs?

Hot Network Questions

Subscribe to RSS