| CARVIEW |
Select Language
HTTP/2 200
date: Sun, 27 Jul 2025 22:03:23 GMT
content-type: text/html; charset=utf-8
cf-ray: 965f6d2b7eabc188-BLR
cf-cache-status: DYNAMIC
cache-control: private
set-cookie: prov=be1fbeed-dc63-4d71-8847-56ff5faba227; expires=Mon, 27 Jul 2026 22:03:22 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-clacks-overhead: GNU Terry Pratchett
x-frame-options: SAMEORIGIN
x-request-guid: 03430c8b-1a03-4172-b497-3054978e443e
x-worker-origin-response-time: 517000000
x-dns-prefetch-control: off
set-cookie: prov=be1fbeed-dc63-4d71-8847-56ff5faba227; Path=/; HttpOnly; Domain=stackexchange.com
set-cookie: __cf_bm=fa7GsNlCKxeB1yRyLOl9muzc2DJ0F_zDNxcixxOx9SQ-1753653803-1.0.1.1-KIXxMsK7NLB0vxqFSafJUrCx7.k_Et2Ljpz_lC2VGvK7zi5C8jRwqiKjOJ7oJpFVc5EWX8GO7G7UG2uVDBb9Z.RkWCKxB_DHTBP61yTOqq4; path=/; expires=Sun, 27-Jul-25 22:33:23 GMT; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
set-cookie: _cfuvid=4muoI_HDsCis36FHLI9wkQu037Qkx0ATGl.SHw1rDo4-1753653803322-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,365 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
0
answers
29
views
Database design in healthcare - 21 CFR Part 11 [closed]
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
66
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
70
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
110
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
48
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
198
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
140
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
58
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
257
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
63
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 ...
2
votes
3
answers
99
views
Best database design for a dress up game?
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, ...
- The Overflow Blog
-
-
- Featured on Meta
-
-
Related Tags
mysql × 1452
sql-server × 878
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 × 107
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
- If a mathematical theorem is true, what it is true of?
- How to deter wasps from an untreated larch fence
- How to extend an MDF shelf?
- How can I turn the text in a PNG file back into text layer?
- Shared-Memory Queue Implementation in C
- Meaning of 芭蕉 in Tang age
- What were the two colored keys on a MUPID for?
- Math bolder than surrounding text in footnotes
- Can one re-program a Leonardo Eth via its Ethernet port only?
- When was the last time all humans were on the ground not in the air?
- How to change opamp variable resistor to fixed resistor?
- Has the Silver Surfer's clothing (or lack thereof) ever been addressed in the comics?
- What is the weight of holy water?
- When did the OEIS get even better?
- Are you required to protect trade secrets revealed to you even if you didn't sign an NDA?
- Can you identify this aircraft landing at Llanbedr Airfield?
- Automatic drawing of polygon around selected polygons in QGIS
- Will this work as an XOR gate?
- Shimano 105 ST 5500 compatible with a triple front derailleur
- What is the outcome when an officer's statement under oath contradicts video evidence
- Will a reinforced 1" concrete slab be durable?
- Algebraic independence of even polynomials
- Not your ordinary affix riddle
- Were the Fantastic Four the only superheroes on Earth-828 in The Fantastic Four: First Steps?