All Questions
Tagged with database database-design
9,374
questions
0
votes
0
answers
60
views
SQLite Strict Mode or any other alternatives
I am currently developing a QT C++ Application for my friend's shop. Simple application for inventory management and billing system. So, the DB will be in his computer itself which also hosts the ...
0
votes
0
answers
18
views
How to organize DB's structure
I have hardcoded (a lot of) phrases with some errors. After program did its work, it returns the result that I need to compare with one of the hardcoded phrase and choose the exact same.
I need to ...
1
vote
1
answer
90
views
What is the method to remember a "1 to many" relationship database change history?
I have basically two tables in the database, one is named "Valve", and the other is named "Channel". This is a basic "1 to many" relationship, which means one Valve can ...
1
vote
1
answer
69
views
Merge many large tables in PostgreSQL
I have 150 tables with the same columns representing areas in a country. The size of each table is millions of rows and tens of GB in size.
I want to combine all the tables into one with the aim of ...
1
vote
2
answers
74
views
Cardinalities for ternary relations in ERD diagram
Re that ERD:
I can represent a many-to-many relationship with m to m.
What is m to n in the ternary relationship?
Can I use it in a binary or unary relationship?
What does it mean?
What is m to k?
Can ...
0
votes
1
answer
42
views
MongoDB best practices for many sensors (+50k) but slow updates (every 12hrs)
I am trying to get some advice on how to appropriately structure my MongoDB Database. I am on Mongo Atlas M10 and my data structure looks like this:
{
sensorId: "12345",
epoch: Date,
...
1
vote
1
answer
34
views
How can I delete a document from firestore while maintaining my database model?
I read this article, and if you find any of my explanations obscure, please refer to it. Basically, the idea is that you assign a last_modified field to each document that gets updated with the date ...
0
votes
0
answers
45
views
How to create an ER diagram: database design challenge
Is this correct or not?
I'm trying to create an ER diagram for an online food delivery app. Now, I'm unsure if the diagram accurately represents the system.
0
votes
1
answer
24
views
How to get the diamond on Siebel erd?
I'm trying to recreate this image, however I can't find the diamond option between the relationships of the entities. How can I do this?
I've tried going through the relationship properties and ...
1
vote
1
answer
23
views
Depicting different shapes of the same real world entity in an ER Diagram
Given an entity A represented by tableA, that I am going to perform certain transformations on (e.g. pivot, standardise) and store/materialise in a second table tableB should I depict an entity B for ...
0
votes
1
answer
35
views
Dependency Cycle in Database with Update Approvals
I'm struggling with a dependency cycle in my SQL database schema for a system with update approvals. Here's the situation:
I have tables for documents , transactions, payment_methods, and ...
0
votes
0
answers
20
views
Compare price and bying price of variant product
I am going to build a database e-commerce, everything is ok except for the variant price. According to many forum, I have seen them desigining database just with price of variants like:
id
product_id
...
0
votes
1
answer
36
views
Designing SQL Postgres Relations Table for Editing Entered Documents and Undo Functionality
I'm currently working on a system where users can edit entered documents in a PostgreSQL database. The functionality entails allowing users to click on a document to edit it, effectively creating a ...
0
votes
1
answer
116
views
Best practice for draft/published states
I'm building a CMS and trying to figure out the best data architecture to handle a "save as draft" functionality.
Let's say I have a post table. I need to be able to save a post as a draft, ...
0
votes
0
answers
30
views
Adding versioning in star schema design
I am in a situation where i have to add version in existing dimension tables . For eg.
I have 7 dimensions tables and a fact table (with total existing data of 500GB)
Now the requirement is dimensions ...