Category "database-normalization"

MySQL single table with hourly, daily, monthly values, or separate tables?

When working with data values, should I create a single table storing the hourly values, and also the aggregated daily/monthly values, or should I create separa

Determine if relation is in BCNF form?

How do I determine if the following relation is in BCNF form? R(U,V,W,X,Y,Z) UVW ->X VW -> YU VWY ->Z I understand that for a functional dependency A