Skip to main content
Database Administrators

Questions tagged [database-design]

Ask Question

The development of the conceptual schema and/or the logical model and/or the physical settings of a database.

6,366 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
0 votes
1 answer
42 views

I have a multitenant app where I'm having some trouble modeling the Address tables. It's an Enterprise App so the database is quite big. Since tenants, users and persons can have N addresses I've ...
Alan Graton's user avatar
  • 1
0 votes
0 answers
25 views

I'm designing a system to store large volumes of sensor data (10,000+ sensors) and evaluating different schema approaches in DolphinDB. Current Context: Data Volume: 10,000+ sensors, continuous time-...
Dongyun's user avatar
  • 1
0 votes
0 answers
9 views

I’m designing an application using Hibernate (JPA) and I’m facing a modeling challenge related to dynamic relationships between entities. Here’s the scenario: I have a Comment entity that can be ...
Khairul Bashar's user avatar
  • 1
0 votes
0 answers
27 views

I have been working with RocksDB for a while, and in my use case, complex data structures are stored as values in the database — for example, a Map that may itself contain nested maps. 1. Update ...
Sri Krishna's user avatar
  • 1
-1 votes
1 answer
95 views

I am about to start working on a project that aims at modeling all trees in France using the LiDAR coverage of the territory. I won't get into the detail of the modeling but basically after ...
Hugo Rechatin's user avatar
  • 1
2 votes
1 answer
104 views

Is it possible to create a table that is built from an inner join of two other tables with additional columns, but where the rows are kept updated when the inner join is re-run? Currently using ...
brendans-bits's user avatar
  • 23
0 votes
0 answers
39 views

In mine it says Application's system version 8.4-104 does not match IdentityIQ database's system version 8.4-87 I tried to update the database its still not working. If it works I can import xml files ...
Adnan Joad's user avatar
  • 1
1 vote
1 answer
108 views

I am wondering why Postgres allows to insert a non-existing values for a foreign key to a nullable multicolumn unique constraint. (Cannot be an actual primary key.) I made a fiddle. I expected this to ...
Emaborsa's user avatar
  • 121
0 votes
0 answers
30 views

I'm struggling to figure out the best way to model Production Rooms in our manufacturing ERP app. Currently, we have a Locations model which is a hierarchical, materialized-path (Ancestry Gem) ...
karns's user avatar
  • 103
2 votes
2 answers
166 views

Originally, I was working with .NET 9 and a Blazor web app for admin and a Flutter app for external end-user, but for this context, I constrained it to SQL Server 2017, to evaluate it first internally....
DevQt's user avatar
  • 205
-1 votes
1 answer
53 views

I recently came across the NKTg Law on Varying Inertia in physics, which describes an object’s movement tendency based on its position (x), velocity (v), and mass (m), with m allowed to change over ...
TheNKTLaw's user avatar
  • 1
0 votes
1 answer
114 views

I am currently designing a mobile application that sends push notifications to users subscribed to a set of topics. The list of possible topics changes infrequently (not more than once per year), ...
Math Rules's user avatar
  • 178
0 votes
1 answer
116 views

I'm building my first web project: a modular furniture e-commerce platform using Next.js and PostgreSQL. I’ve designed a normalized relational schema to handle: Categories and subcategories Furniture ...
ASINCAP's user avatar
  • 9
1 vote
3 answers
234 views

We're in the process of aligning with SQL Server security best practices and recently initiated a project to change database ownership from individual domain logins to the SA account across our ...
Jk Jerome's user avatar
  • 11
0 votes
1 answer
65 views

I've got my standard MariaDB database with phpMyAdmin. I'm working with OpenSSL and php. And I've got nothing more than a basic rented web-server. $cipher_algo = 'aes-128-cbc'; $key = '...
Desert Wind's user avatar
  • 43
2 votes
1 answer
232 views

I installed my mariaDB and phpMyAdmin. I created a new user with all the Grand and Super priveleges. And I deleted the "root" user for savety. Perfect. As I follow an article: make a ...
Desert Wind's user avatar
  • 43
3 votes
2 answers
163 views

I am trying to figure out the best way to structure and handle highly interconnected data of various types used for analytics and inference (of new data from old data). There would be one-to-one, many-...
pizzashi's user avatar
  • 33
1 vote
1 answer
78 views

Im having some trouble to check if my ER diagram using crow's foot is right. I have a exercise asking for this: TAB_Pessoa = { cpf (PK), nome, data_nascimento, sexo } TAB_Aluno = { matricula (PK), ...
vhksm's user avatar
  • 11
-1 votes
1 answer
95 views

I don't have any particular problem in mind, I am just looking for the best practices. I am creating a bank database. Nothing too important or involving real money, nevertheless, I think it would be ...
phy0072's user avatar
  • 1
1 vote
1 answer
54 views

I have a database consisting of a main scopes table (containing standard scopes), a projects table, and a configuration table linking scopes to projects. I now need to allow for custom scopes that are ...
Nivethan's user avatar
  • 11
-1 votes
1 answer
67 views

I'm developing a system to store and query genomic data using a relational database (PostgreSQL being my primary candidate). The dataset is quite large around 9 billion records with over 300 columns, ...
mad's user avatar
  • 1
1 vote
0 answers
56 views

I am currently creating an application to manage customers, employees, invoices and appointments. But I am not sure if my design is an overkill and it could be simpler. Functional requirements: -) A ...
Patrick's user avatar
  • 11
0 votes
3 answers
546 views

I am working with a large dataset of 150,000 rows that needs to be inserted into a SQL Server table. However, I am encountering the following error when trying to insert all values at once using a ...
Jamal Ashraf's user avatar
  • 101
0 votes
2 answers
105 views

Is there is any procedure to do MSSQL Mirroring with single master and multiple slave. two slave X one master Or this one. One Master X One Slave for Viewing only I need a MS SQL server for viewing ...
Aaron Adonis Jaralve Velasco's user avatar
  • 3
2 votes
3 answers
118 views

I am making a dress up game using Postgres as the database. A player can optionally wear a hat, pants, glasses, shirt, and shoes. I currently have a player table and it has columns like name, ...
Ryan Peschel's user avatar
  • 141
0 votes
0 answers
51 views

I am drawing the conceptual data model between vehicle, car and motorbike. As far as I know. Hierarchy. The simple "is a" feature. Disjunction means that each ocurrence of superentity ...
user69507's user avatar
  • 1
0 votes
0 answers
50 views

I have table: blocks: id integer not null primary key, ref_date date not null, seq_no integer not null, lk_document integer not null there can be multiple records for each lk_document and all those ...
TomR's user avatar
  • 101
0 votes
0 answers
37 views

I’m developing a medical app (learning purpose) where users can store and manage blood test results, medications, doctor appointments, and medical documents. I’ve designed a PostgreSQL database schema,...
developer's user avatar
  • 1
0 votes
0 answers
42 views

We have a database where: Master tables store reference data that rarely changes. Append-Only tables store transactional data, always inserting new records without updates. These tables reference ...
Sanjay Prajapati's user avatar
  • 101
1 vote
0 answers
59 views

One definition of "entity" in the Wikipedia page for entity-relationship model as follows: An entity is a thing that exists either physically or logically. An entity may be a physical ...
Kt Student's user avatar
  • 115
0 votes
0 answers
79 views

My situation is very similar to this question, with a twist. I use Postgres 15.3 and I have two tables: parents with an id children with an id, a parent_id, and some other columns (my real use-case ...
bfontaine's user avatar
  • 103
0 votes
0 answers
41 views

I'm designing a database for a platform where users can post different types of content. Database Engine: SQL Server The system includes: Proposals Experiences Events ##Current Schema Design## ...
lukiplay's user avatar
  • 1
0 votes
0 answers
39 views

I am looking for advice about designing VIEWs when a variable number of columns is needed. Context The tables are consolidated into views. For instance office_rents and office_electricity_bills are ...
OuzoPower's user avatar
  • 141
0 votes
2 answers
119 views

I am designing an OLTP system with a relational database in PostgreSQL/SQL Server to store dyeing recipe data. I need to implement versioning for recipes while keeping queries efficient for ...
Cbas G's user avatar
  • 1
0 votes
1 answer
52 views

I'm taking the course on graph data modeling in Neo4j Academy (the link is here for reference). And often in the course, I see the use cases phrased like a question such as: What people acted in a ...
Kt Student's user avatar
  • 115
0 votes
0 answers
72 views

The problem I have a system that I'm building where I need to allow users to track time to any number of various other systems. For example, I have a concept called a Project, a project can contain 0 ...
Kayden Miller's user avatar
  • 1
0 votes
0 answers
65 views

In Db2 (v11.5, 12, LUW) - what is the best way to grant/enable specific administrative functions with required permissions for applications? E.g. a client/server application wants to make dynamic ...
matz3's user avatar
  • 33
0 votes
0 answers
71 views

I’m trying to get some practice with database creation and maintenance and a project I’ve come up with is a database for road accidents. I quickly found an example which has a part of the ...
pateksan's user avatar
  • 101
0 votes
1 answer
97 views

This is the schema I'm working with: Here's the DBML to recreate in https://dbdiagram.io/d: Table University { ID integer [primary key] } Table Professor { ID integer [primary key] ...
Carl Schmidt's user avatar
  • 3
0 votes
1 answer
136 views

In the book I am currently reading this table is mentioned as an example for what we can do if a table fulfills BCNF but has still redundancies. It then mentions that a solution are arrays. But is ...
Marlon Brando's user avatar
  • 141
0 votes
0 answers
58 views

I'm building a server application where any number of "modules" are created over time, that can reference each other in the form of foreign keys or reads. They can't write to each other, and ...
blaineh's user avatar
  • 101
0 votes
1 answer
70 views

I’m working on a database design where I have three tables (Tables A, B and C) with hierarchical relationships, and I need to model references from a fourth table (Table D) to one of three other ...
user avatar
0 votes
0 answers
30 views

A social security organization wishes to develop an application to manage patients, their attending a generalist, and specialist doctors. A person is either a beneficiary or a doctor; a doctor can ...
NGANGO YVES's user avatar
  • 1
0 votes
3 answers
145 views

Let's start by explaining the entity that I'm thinking of breaking it into three tables and how the UI form is organized, and data entry is happening. There is a Person who has many properties, and ...
Out Of Bounds's user avatar
  • 101
-1 votes
2 answers
141 views

In a grocery shop, customers buy items, and the products have categories. The TotalQuantity represents the stock of products. 1NF: OrderProduct (OrderID, OrderDate, OrderTime, CustomerID, CustomerName,...
User190230UK's user avatar
  • 1
0 votes
1 answer
38 views

I’m building a blog application in React where each blog displays a list of comments. Each comment includes: Like count (total number of likes for the comment) Like status (whether the currently ...
Solruhama's user avatar
  • 1
0 votes
0 answers
27 views

Using the basis of a type 2 slowly changing dimension table I've put together this simplistic example of sports match with stats: Match_Key Match_Id Stat_1 Stat_2 Stat_3 Effective_Date Current_Flag 1 ...
Jossy's user avatar
  • 83
0 votes
1 answer
44 views

I'm looking to design an application (Python with sqlite) which deals with some contributors moving across several groups through time. My design looks currently like (PK in bold weight, FK in italic, ...
Amessihel's user avatar
  • 103
-2 votes
2 answers
95 views

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's user avatar
  • 97
1 vote
2 answers
87 views

Exposition Let's say our system has users and some games. Let's call these games A, B and C. For simplicity's sake, our initial tables look like this: CREATE TABLE IF NOT EXISTS users ( id SERIAL ...
ncmprbl's user avatar
  • 13

1
2 3 4 5
…
128