(Answered): 2. Normalization into 2NF, 3NF and BCNF.- Consider the relation schema LOTS shown below which descr ...

2. Normalization into 2NF, 3NF and BCNF.- Consider the relation schema LOTS shown below which describes parcels of land for sale in various counties of a state. Suppose that there are two candidate keys: Property id# and {County name, Lot#}; that is lot numbers are unique only within each county, but Property id# numbers are unique across counties for the entire state. Candidate Key (a) LOTS Property_id# County_name Lot# Price Tax_rate FD1 Area FD2 FD3 FD4 (1) Decompose the relation into the 2NF?- (2) Decompose the relation into 3NF?- (3) Consider an additional FD defined as FD5: Area -> County name. Decompose the relation into BCNF?- 1. Computing a Minimal Cover- Consider a relation R = {A,B,C,D}. For each set of FDs given below, identity whether or not the set of FDs is a minimal cover. If not, find a minimal cover for the set of FDs. (1){ AB, AC). (2) {A ?B, ACB, BC. (3){A ?B, BA, B ? C}. 3. Convert the following into 1NF,2NF and 3NF form Department No. Hourly Rate Employee Name A Smith Department Name IT L004 22.00 LJones L023 Pensions 18.50 P Lewis LO04 IT 21.00 B Jones L004 IT 21.75 Project Project Project Project Employee Code Title Manager Budget No. PCO10 PensionsM 24500 S10001 System Phillips PCO 10 Pensions 24500 S 10030 System Phillips PCO 10 Pensions M 24500 S21010 System Phillips PC045 Salaries Martin 17400 S 100 10 System PC045 Salaries H Martin 17400 S10001 System PC045 Salaries F Martin 17400 S3 1002 System PC045 Salaries H Martin 17400 513210 System PC064 HR K Lewis 12250 S31002 System PC064 HR R Lewis 12250 S2 10 10 System PC064 HR K Lewis 122130 S10034 System A Smith L004 18.00 TGilbert L028 Database 25.50 L008 Salary 17.00 w Richards T Gilbert L028 Database 23:25 PLEWIS L004 17.50 B James L009 HIR 16.50