| CARVIEW |
Select Language
HTTP/2 200
date: Wed, 23 Jul 2025 12:23:34 GMT
content-type: text/html; charset=utf-8
cf-ray: 963b2655e86bc467-BLR
cf-cache-status: DYNAMIC
cache-control: private
set-cookie: prov=7fa60603-95ee-4c79-a94d-feb550ab6b04; expires=Thu, 23 Jul 2026 12:23:34 GMT; domain=.stackexchange.com; path=/; secure; httponly
strict-transport-security: max-age=31536000; includeSubDomains
vary: Accept-Encoding
content-security-policy: upgrade-insecure-requests; frame-ancestors 'self' https://stackexchange.com
x-frame-options: SAMEORIGIN
x-request-guid: c4f50039-5c4e-4ab5-bd63-e7de9039ad8c
x-worker-origin-response-time: 506000000
x-dns-prefetch-control: off
set-cookie: prov=7fa60603-95ee-4c79-a94d-feb550ab6b04; Path=/; HttpOnly; Domain=stackexchange.com
set-cookie: __cf_bm=O5X40f.HoNKzC1CeBiVgjnax1S0fGnIM8km08VSUrXA-1753273414-1.0.1.1-ytfJxzDCVpgSn6ujdqrvNLoHqvWlorAK3BMX5b0rLoPVCdLkU8kbNLw8KAOS3oFqISk_mbqyeMyZKmL3B1sbbGGUPKvViM.LDrejyDoe8T0; path=/; expires=Wed, 23-Jul-25 12:53:34 GMT; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
set-cookie: _cfuvid=h84Mxn8tRrMMRufbFIfQ6IVu2REM68WQsnEwMHfBDS0-1753273414591-0.0.1.1-604800000; path=/; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
server: cloudflare
content-encoding: gzip
Newest 'database-design' Questions - Database Administrators Stack Exchange
Skip to main content
Stack Exchange Network
Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Visit Stack Exchange
Teams
Q&A for work
Connect and share knowledge within a single location that is structured and easy to search.
Learn more about TeamsQuestions tagged [database-design]
The development of the conceptual schema and/or the logical model and/or the physical settings of a database.
6,367 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
0
answers
22
views
Database design in healthcare - 21 CFR Part 11
I have a database which has organically grown in size and scope over the last few years which handles manufacturing data for medical devices in an R&D setting. For a variety of reasons we need to ...
0
votes
1
answer
60
views
What type of database should I use for this application?
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), ...
0
votes
1
answer
43
views
Handling large dynamic data in real time [closed]
I want to design system that create forms based on user design where user decide how forms looks and user adds elements like toggle button, textbox, number, mail, dropdown, checkbox, coord, button, ...
0
votes
1
answer
67
views
Database Design for a Furniture Store E-commerce Site
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 ...
2
votes
3
answers
107
views
Changing SQL Server Database Owner to SA Broke Application Login – Why Did It Happen and How Can We Prevent It?
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 ...
0
votes
1
answer
47
views
how to purposefully mismatch database entries?
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 = '...
2
votes
1
answer
196
views
Have multiple users for your DB per action?
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 ...
3
votes
2
answers
139
views
Database structure and storage for highly interconnected different data
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-...
1
vote
1
answer
51
views
Is this ER diagram using crow's foot correct?
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), ...
-1
votes
1
answer
55
views
What are the best practices of a banking relational database? [closed]
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 ...
1
vote
1
answer
40
views
Database Design for Managing Main and Custom Scope Entities
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 ...
-1
votes
1
answer
57
views
Best Database for Bulk Reads and Fast Key Lookups for Genomic Data [closed]
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, ...
1
vote
0
answers
41
views
Database Design advice
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 ...
0
votes
3
answers
253
views
How to Insert 150,000 Rows in SQL Server Efficiently? (Error: Max 1000 Row Limit)
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 ...
0
votes
2
answers
62
views
MSSQL Server Mirroring One Master Two Slave Architecture
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 ...
- The Overflow Blog
-
-
- Featured on Meta
-
-
Related Tags
mysql × 1453
sql-server × 879
postgresql × 803
schema × 443
normalization × 410
performance × 348
erd × 315
foreign-key × 227
relational-theory × 209
primary-key × 155
database-recommendation × 151
oracle × 148
index × 146
query-performance × 135
table × 127
data-warehouse × 115
nosql × 108
best-practices × 103
mongodb × 103
database-diagrams × 102
constraint × 98
optimization × 94
sql-server-2008 × 90
subtypes × 80
datatypes × 79
more related tags
Hot Network Questions
- How to 'scale' a square list?
- What is that "T" in the pattern string of the date-command?
- Why does contact with the ground make my touch-activated LED brighter?
- Is there a formal threshold for when a variable is considered 'random' in statistics? What is it?
- Distance Between Subspaces
- Partial derivative of a matrix with respect to a vector dimension?
- What's the point of all-wheel drive (AWD) in RoadCraft, if vehicles consume no fuel?
- Story about a room on Mars that contains God
- How can I automatically replace curly braces { and } in LaTeX macro arguments—e.g., in math formulas—for label generation?
- rEAAlly good for you
- When is XLOOKUP() faster than VLOOKUP()?
- Which PowerShell commands are automatically scrubbed from Get-History?
- What *IS* switch bounce REALLY? According to evidence. (Not *how* to debounce.)
- What fiction genres do literary agents recognize?
- SOSL/SOQL isn't returning User records
- Will I lose my seat reservation on Deutsche Bahn EC if I skip the first leg?
- Is a Rakshasa Immune to True Strike?
- Not sure which test statistic to look at with regression with interaction term
- Black color in Decal is not visible
- When you view a historical event with an incorrect modern lens
- Define command valid only for a specific environment in expl3
- How does Rav Kotler assign final letters in 5 cases in Vayikra-Bamidbar?
- bootstrapping for variance estimation takes too long
- Must hospitals care for unidentifiable individuals indefinitely?