All Questions
Tagged with database database-design
9,380
questions
-2
votes
0
answers
23
views
Which one is a better approach to store a course's table of contents? [closed]
Let's say I want to store structured data as follows for a particular course for an ed-tech app:
1. Unit 1
1.1 Chapter 1
1.2 Chapter 2
...
2. Unit 2
2.1 Chapter 1 (Unit 2)
2.2 Chapter 2 ...
- 1,794
-1
votes
2
answers
38
views
one-to-one mandatory attendance relationship
As shown in the diagram, there are 2 tables with a one-to-one relationship and mandatory participation. Can you help me implement this as ddl code? I could do it easily when there was no mandatory ...
- 21
1
vote
2
answers
61
views
How to system-design paying a payment with multiple currencies
I am developing an accounting app where users can have a product with currency A. The value of the product can be escrowed using a cheque payment with currency B and this cheque payment can be paid in ...
-1
votes
0
answers
30
views
Parent-Child relationships where parent and child tables may change based on settings
I am developing a Warehouse Management System. Each Warehouse can specify storage locations by varying degrees of specificity: Zone, Aisle, Row, Rack, Shelf, Bin. While Bin is always required because ...
- 85
-2
votes
0
answers
35
views
Normalized database structure would result in the lowest-level types containing huge amounts of data
I'm using Xano as my database management system.
Here’s how my website content is structured:
- Company (first level type)
-- Division (second level type)
--- Team (third level type)
---- Employee (...
0
votes
0
answers
19
views
Product variant but has other variation
I have product table and produk variant
But I want that product variant has other options again
This is my product,
I have a custom cloth that has types of collars , cuff, pocket, plackets, fabric
But ...
- 47
-1
votes
0
answers
20
views
How to design a database with a large number of data items [migrated]
I collect data every second from a control device. The device has 8,191 points of data from X1 to X1FFF.
I thought of two designs to store the data.
A table that stores data in columns:
This method ...
- 71
-1
votes
0
answers
39
views
Database Design: Choosing Between Table Inheritance and Table-Per-Hierarchy for User Types
I am confused about creating a database and I need your help. I want to create a small-scale hospital management system. Here I want to create my users using Microsoft.Identity, but the point I am ...
- 25
-1
votes
0
answers
45
views
Creation of dynamic tables in the database diagram
I want to build a database diagram. I have a diagram with all the fields I created. It's about IoT devices and their belongings, and I want to add the ability to create dynamic sensor tables. For ...
0
votes
0
answers
23
views
Real estate database design to save listings of different types [duplicate]
I am creating a website similar to this website. My website needs to allow users to save different kinds of listing like home, plots. offices, shops, agricultural land etc. My question is how to ...
0
votes
0
answers
34
views
How do I setup baserow such that I can migrate data from one table to another?
I am new to base row and I would want to set up a system such that a record added to one table is automatically copied to another table.
I can't really go into too much detail but for example, once ...
0
votes
0
answers
45
views
How to count the number of read/write units being used on KV?
The free plan of Deno Deploy gives me 450,000 read units and 300,000 write units per month. One read unit is equivalent to 4 KiB of read. If you read a 2 KiB record this is 1 read unit. If you read 4....
- 2,523
-1
votes
1
answer
53
views
Whats the best way to design an event table where different event items are provided each time the event updated
I have a raw event table that I'm working with. It has two columns date and metadata. Metadata has raw json dump of all the event attributes. But I'd like to make it clear that each time different ...
- 1,505
0
votes
0
answers
8
views
How to design data consistency check rules
Data Reconciliation Rule Generation
Background:
In the process of e-commerce shopping, when a user places an order, data information will be stored in different systems' tables such as order table, ...
2
votes
1
answer
36
views
Can i add new nodes and increment n_val in Riak kv?
I intend to make a desktop app for a company that has multiple gyms at different locations,where a client who registered his membership at one gym should be able to access all other gyms with the same ...
- 23