Question: 1. [10 pts.] Consider the following database which keeps track of State and City information: STATE table: In which normal form it is given to
![1. [10 pts.] Consider the following database which keeps track of](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2024/09/66e331173328e_27066e33116bef9c.jpg)
1. [10 pts.] Consider the following database which keeps track of State and City information: STATE table: In which normal form it is given to you? Normalize it to its 3rd normal form and do this by drawing bubble diagrams in every step, clearly specifying the nature of the dependencies (Assume that the union order is not unique). 1 2. [5 pts.] Consider the following database which keeps track of client, veterinary, and pet information: In which normal form it is given to you? Normalize it to its 3rd normal form and do this by drawing bubble diagrams in every step, clearly specifying the nature of the dependencies
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
