Please answer all of the parts to A, B, and C, and questions 4.39 to 4.43.

James Morgan Database Tables
A. STORE(StoreName, City, Country, OwnerName, Speciality)
1. StoreName -> City
This condition can be true only when each value of the StoreName is unique for every tuple which states that every value of the StoreName should determine the value of City.
2. City -> StoreName
It can be true if every value of city is unique for tuples or we can say that every value of city should determine the value of StoreName.
3. City -> Country
If every value of the City should determine the value of Country or the value of City is unique for every tuple then this condition is true.
4. (StoreName, Country) -> (City, OwnerName)
This condition can be stated as true if and only if the values of StoreName and Country when put together can determine the value of City and OwnerName. There is a functional dependency between them.
5. (City, Specialty) -> StoreName
This condition will be true when the value of City and Specialty together can determine the value of StoreName.
6. OwnerName -> StoreName
For this statement to be true, OwnerName should multidetermined the StoreName. There exists a multivalued dependency between OwnerName and StoreName.
7. StoreName -> Specialty
There exists a multivalued dependency between StoreName and Specialty. It will be true when the StoreName multidetermined Specialty.
B. With regard to the relation: STORE(StoreName, City, Country, OwnerName, Speciality)
1. The following functional dependency can be used for a small import and export business.
StoreName -> City
City -> Country
StoreName is unique for each tuple hence its every value will determine the value of City. Similarly, every value of City will determine the value of Country. If StoreName, City and Country are known then import-export business can be carried out.
2. Transform the relation into 4NF and BCNF.
To convert the relation into 4NF it should already be in 3NF but it is not.
Convert the relation into 3NF.
STORE (StoreName, City)
STORE_CITY(City, Country)
The above relation contains an anomaly due to the functional dependency.
BCNF form of the relation is as follows:
STORE...