Show normalized relations without loss of information for the following:
Databases
account_circle
Unassigned
schedule
1 Day
account_balance_wallet
$1.00-$30.00
student
Rules: 1. Remove bad transitive functional dependencies. 2. If X ! Y and X, Z ! Y, then X ! Y is a stronger FD. Remove the weaker dependency X, Z ! Y. 3. If X ! Y and X, Y ! Z, then reduce X, Y ! Z to the stronger X ! Z. (Also, keep X ! Y ). show the relations. For each resulting relation, show the key and FDs.
Sample Solution