All Questions
Tagged with database database-design
9,382
questions
0
votes
0
answers
7
views
Database Design and naming columns
So I was planning on developing a website which uses a back end database. On my way to pre-modelling the database, I found out there are certain standards, which some people follow and some don't, ...
-1
votes
0
answers
21
views
store multiple weekday values in a column as a string or create a separate table
We are creating an Employee Employment table and it should contain Employee ID, Activity Type and Activity Days. The activity type will be in a separate table and only the ID will be recorded in the ...
-2
votes
0
answers
39
views
is there a way to store unschematised datas in sql database [closed]
mysql : 5.6 java : 11
Am in need of an mechanism to store unschematised data in my db. the case is as follows.
Objective :
To get all user from a 3rd party app and store it in db.
Problem facing :
...
-2
votes
0
answers
25
views
Database design for audio content streaming application [closed]
I have this task to design a database schema for a simple audio content streaming application, and I have questions about what would be the best way to store relations between tracks and playlists.
I ...
-2
votes
0
answers
27
views
Designing a MongoDB Schema for Efficiently Managing and Querying Ordered Sequential Values [closed]
I have a mongoDB collection findings which contains the following documents
{
name: "finding1",
group: "group1"
},
{
name: "finding2",
group: "group1"
},...
0
votes
0
answers
31
views
Need to determine whether different question types for a questionnaire are many-to-many or one-to-many
We need to survey our contacts by asking them various questions and recording their responses. Some questions are standard and must be included in every survey (default questions), while others are ...
-1
votes
0
answers
11
views
In a social media relational database schema, should I use separate tables for posts likes and comments likes?
I have a social media app with users, posts, and comments, in which users can like posts and comments.
Is it best practice to use the same table to store the likes of both, such as:
user_id
post_id
...
1
vote
1
answer
44
views
Why is read repair not sufficient in making dynamo-style database linearizable?
I am reading DDIA. It says "possible to make Dynamo-style quorums linearizable at the cost of reduced performance: a reader must perform read repair (see “Read repair and antientropy” on page 178)...
-3
votes
2
answers
55
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 ...
1
vote
2
answers
66
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 ...
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 ...
0
votes
0
answers
38
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
48
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....
-1
votes
1
answer
57
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 ...