I keep determining all schemas’ highest normal forms are 1NF, so I expect that I am doing something wrong, because all the schemas cannot have the same answer.
Given the relational schema Q(A,B,C,D,E,G,H) and the set of functional dependencies
F = { E → C; H → E; A→ D; A,E → H; D,G → B; D,G → C }
a. Determine all the keys of Q
b. Determine the highest normal form of Q
a. My answer: [AEG]+; [AGH]+
b. My answer: 1NF
What are my errors finding keys and the highest normal form of this relational schema?
New contributor
Lilac is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
3