Searching for a specific child becomes very clumsy. To answer the question “Does anyone have a child named Lee?” the DBMS must construct a query that includes a search of all three child name columns because there is no way to know in which column the name might be found. The right w...
The question...S. Ginsburg and R. Hull. Characterizations for functional dependency and Boyce-Codd normal form families. Theoretical Computer Science, 27:243-286, 1983.Ginsburg, S., Hull, R.: Characterizations for functional dependency and Boyce-Codd normal form families. J. Theoret. Comput. ...