Questions tagged [database-design]
Database design is the process of specifying the structure and thus the logical aspects of a database. The goal of database design is to make a representation of some "universe of discourse" - the types of facts, business rules and other requirements that the database is intended to model.
database-design
24,118
questions
-3
votes
0
answers
21
views
naming attributes: verbs and adjectives, or nouns, or what? [closed]
I am developing a website which uses a back end relational database. There are certain standards, which some people follow and some don't; some make their own standards.
Should I make the column names ...
-1
votes
0
answers
22
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
13
views
One common document table vs separate tables for multiple entities: scalability, optimization, and maintainability [closed]
I have three tables: inspections, accidents, and claims. Each of these tables has a one-to-many relationship with a documents table, where users can upload documents specific to each record.
The ...
-2
votes
1
answer
26
views
How to model a multi category item for effective searching?
an item has a list of categories, what is an good way to model such that search can done in an efficient and effective manner?
For example, Cake could be in categories [Baking, Dessert], Ice cream ...
-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 ...
0
votes
1
answer
20
views
How to model Student/Teacher/Class with DynamoDb?
I'm modeling a DynamoDb schema, which currently supports three main entities: Teacher, Student and Class. Class entity has these relationships:
A teacher has a class
A student enrolls to a class
My ...
-2
votes
0
answers
33
views
problem in delete function in java and mysql [closed]
error message when i press delete حذف
I have a table connected with mysql when I choose a row to delete it doesn't work
here is the code of delete
private void l2MouseClicked(java.awt.event....
-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"
},...
-1
votes
1
answer
54
views
The best data-model to store nested tags? [duplicate]
I'm trying to make a breadcrumb for a ecommerce website. Something like this:
Home > Kitchen > Serving and reception > Spoon
Each of those item are a tag. So, the tags table is parent-based/...
2
votes
2
answers
49
views
How to reference a User Entity from another microservice in ASP.NET Core?
In my microservices architecture using ASP.NET Core, I have two distinct microservices: Identity.API for user management and PersonalAccount.API for handling personal account-related functionalities. ...
0
votes
1
answer
50
views
What is the recommended collation for a PostgreSQL unique e-mail column?
Most places recommend for unique e-mail indexes using either a lower(email) index, or a datatype citext.
But the manual for citext suggests using a collation for all cases instead of citext now:
...
0
votes
0
answers
51
views
Postgresql SELECT optimisation into Django ORM [closed]
Please see below a PostgreSQL SELECT statement. This presently returns around 300k rows, which is the grouped result of several million underlying rows. The dataset is only going to get larger. Using ...
-1
votes
0
answers
47
views
Error: The server does not support SSL connections when running drizzle-kit studio
import { migrate } from "drizzle-orm/postgres-js/migrator";
import { drizzle } from "drizzle-orm/postgres-js";
import postgres from "postgres";
import { env } from "....
-2
votes
2
answers
73
views
Count on LEFT JOIN in SQL
I would like to know how can I get Count on LEFT JOIN in SQL.
Currently I have 3 tables :
rooms_messages
id
room_id
discussion_message_id
created_at
1
10
101
2024-07-16 12:30:45
2
20
102
2024-07-16 ...