Can anyone Please solve this problem as soon as possible. this is the 3rd time i,m posting the same question but i hadn’t get the answer yet.
Question 7 Normalization (15 Marks) The set of relations in Figure 3 represents a court example. Examine the set and state what is the Normal Form of each? Why? (7 marks) Transform those relations which to 3NF relations. (8 marks) a- b- Attorney Zipcode AttorneyID Address City Name State Specialty Speciality Attorney ID Bar Attorney ID Bar Client Telephone DOB ClientID Address City Zipcode Name State Case Description CaseType CaselD Count Retains AttorneyID CaselD ClientlD Date Court Courtname City Zipcode CourtID State Judge JudgelD Name Years CourtID Figure 3: Court Case Example Relations