What are the options for storing hierarchical data in a relational database?

What are the options for storing hierarchical data in a relational database?

sql database tree relational-database hierarchical-data

database

When and why are database joins expensive?

database performance join relational-database denormalization

database

Storing time-series data, relational or non?

database nosql relational-database time-series non-relational-database

database

Relational table naming convention [closed]

database database-design coding-style naming-conventions relational-database

database

Difference between 3NF and BCNF in simple terms (must be able to explain to an 8-year old)

database relational-database database-normalization 3nf

database

NoSql vs Relational database

database database-design nosql relational-database rdbms

database

What are the uses for Cross Join?

sql database join relational-database

database

Difference between a theta join, equijoin and natural join

sql database relational-database relational-algebra

database

When I should use one to one relationship?

database database-design relational-database

database

Still Confused About Identifying vs. Non-Identifying Relationships

database database-design relational-database identifying-relationship

database

Pros/cons of document-based databases vs. relational databases

database nosql couchdb relational-database document-database

database

Modeling Product Variants

mysql database database-design relational-database entity-attribute-value

database

When shouldn't you use a relational database? [closed]

sql database nosql relational-database

database

Practical example for each type of database (real cases) [closed]

database nosql relational-database

database

Composite Primary Keys : is it good or bad

sql database database-design relational-database

database