Skip to main content
Share Your Experience: Take the 2024 Developer Survey
Renzo's user avatar
Renzo's user avatar
Renzo's user avatar
Renzo
  • Member for 8 years, 11 months
  • Last seen more than a month ago
  • Italy
17 votes
Accepted

Is a table without a primary key normalized?

9 votes

Estimating the size (of the records) and the overhead in Postgres

7 votes

Lossless join in 3NF

6 votes

Proof for this answer

6 votes
Accepted

Why are multivalued dependencies named that way?

6 votes

One and only one relationship - ER diagram to relational schema

5 votes
Accepted

What are the prime and non-prime attributes in this relation?

5 votes

What are the consequences of not specifying NOT NULL in PostgreSQL for fields which can't be null?

5 votes

A tuple relational calculus equivalent for the given SQL query

5 votes
Accepted

Estimate result size of Natural Join

5 votes
Accepted

How to deal with unavoidable circular references

5 votes
Accepted

Difference between functional dependency and join dependency

5 votes
Accepted

Is this table in 1NF?

4 votes
Accepted

Decomposition In Boyce-Codd Normal Form may lose relations?

4 votes

What normal forms are these two relations in?

4 votes

Dependency preserving decomposition

4 votes
Accepted

How to decompose this relation into 3NF relations?

4 votes
Accepted

Mapping a 1:1:N ternary relationship to a relational schema

4 votes
Accepted

Are there relations that cannot be normalized to second normal form (2NF)?

4 votes
Accepted

For BCNF decomposition, is it okay to have a relation with none of the original functional dependencies?

3 votes
Accepted

Enforcing existence of records while avoiding circular references

3 votes

Decompose a relation to 2NF and preserve all the functional dependencies

3 votes
Accepted

Third Normal Form. Multiple attributes determine another?

3 votes

normalisation in DBMS

3 votes

Foreign key location

3 votes
Accepted

Database design - normalisation query

3 votes

Normalizing a table with a field that generally uniquely identifies a row, but is sometimes null

3 votes
Accepted

How to count specific products?

3 votes
Accepted

Minimal 3NF normalization issues

3 votes

Query of multi-valued field