Skip to main content
Database Administrators

Questions tagged [rdbms]

Ask Question

Relational Database Management System, a widely used type of database management system characterised by its extensive use of joining as a core operational principle.

225 questions
Newest Active Bountied Unanswered
0 votes
0 answers
6 views

I’m designing an application using Hibernate (JPA) and I’m facing a modeling challenge related to dynamic relationships between entities. Here’s the scenario: I have a Comment entity that can be ...
Khairul Bashar's user avatar
  • 1
4 votes
0 answers
134 views

I am trying to figure out how postgres calculates cost for a simple select query with a single where clause. afaik the strategy postgres will use to select depends on the selectivity of the query and ...
dripto's user avatar
  • 91
0 votes
0 answers
46 views

I'm building an ERP system where we can import our suppliers' product data before purchasing their products. Under the current design, supplier products are stored in a separate table and when we ...
Thomas's user avatar
  • 1
0 votes
1 answer
74 views

I know about the users in postgres but don't have correct idea about them. The difference I know is Authenticated user - The user who enters his credentials to login into postgres database. Session ...
Ayush Vatsa's user avatar
  • 55
0 votes
1 answer
244 views

I have a table with 4 columns, in which one of them is primary key, one is time_created, ID of the upstream service (say ID) and the type of upstream service (say service_name). This table is append ...
pdmnhn's user avatar
  • 1
-3 votes
1 answer
425 views

CREATE TABLE machine.machine ( m_id INT PRIMARY KEY, mname VARCHAR(20) NOT NULL, mprice FLOAT CHECK (mprice > 0), mcost FLOAT CHECK (mcost < mprice) );
user285924's user avatar
  • 1
1 vote
1 answer
81 views

Consider the relation R(A, B, C, D, E), with the functional dependencies being {BE->A, D->E}. What is R's decomposition in 2NF? The answer is R1(D, E); R2(B, E, A); R3(B, C, D) I've derived that ...
user avatar
1 vote
1 answer
615 views

A lot of the difference between SQL and NoSQL that is talked about focuses on the fact that SQL support ACID properties while in many NoSQL dbs ACID is compromised. I'm unsure of the reason but ...
asn's user avatar
  • 127

15 30 50 per page
1
2 3 4 5
…
15