1
vote
1answer
29 views

Is this table in third normal form?

I have a table L(A, B, C). Functional dependencies are: A->B, A->C, B->A, B->C. Is this table in 3nf? My thoughts: A and B are keys of this table. Table is in 3nf if there are no transitive ...
0
votes
0answers
39 views

Decomposition into BCNF where an attribute appears in multiple functional dependencies

I am trying to decompose my relation: R = (A, B, C, D, E) with Functional Dependencies F = {D -> BC, E -> B, A -> B, B -> D} The problem is that D appears in two dependencies and in ...
0
votes
3answers
97 views

Column partially determining accepted values of another column, should be somehow normalized?

I have a table that describes a set of properties (yes it's metadata, in this case there's a valid reason to have it in the database); among other things I tell the type of the data that can be ...
1
vote
1answer
149 views

Approach to Analyzing Database Requirements

When presented with requirements for a database driven system, I always find it useful to imagine a world with no computers, where data records were kept in filing cabinets and data was collected by ...