Howdy.
I have an IT class in which we're studying SQL.
We have a midterm coming up and we've been given a sample exam for studying. I've got everything locked down, just one thing left - Database normalization.
The question is:
1. When is the process of normalization used?
2. Describe BCNF
3. For the given relation, find all functional dependencies and possible anomalies implied from the functional dependencies. Put the relation into the appropriate BCNF.
EmployeeID | Name | Dept. | Title
100 Jones HR Executive director
200 Chau HR PR
205 Parker Marketing Clerk
300 Garret Accounting Accountant
400 Miller Marketing Clerk
I've been googling and reading for a while and still can't seem to really understand BCNF and normalization with all that XY dependency stuff. Can someone perheps help me with this question from the exam? I'm sure an actual answer for an example would explain it much better than any theoretical one would.
Thanks!
I have an IT class in which we're studying SQL.
We have a midterm coming up and we've been given a sample exam for studying. I've got everything locked down, just one thing left - Database normalization.
The question is:
1. When is the process of normalization used?
2. Describe BCNF
3. For the given relation, find all functional dependencies and possible anomalies implied from the functional dependencies. Put the relation into the appropriate BCNF.
EmployeeID | Name | Dept. | Title
100 Jones HR Executive director
200 Chau HR PR
205 Parker Marketing Clerk
300 Garret Accounting Accountant
400 Miller Marketing Clerk
I've been googling and reading for a while and still can't seem to really understand BCNF and normalization with all that XY dependency stuff. Can someone perheps help me with this question from the exam? I'm sure an actual answer for an example would explain it much better than any theoretical one would.
Thanks!