Question: Examine the set of relations in Figure 4-39. What normal form are these in? How do you know this? If they are in 3NF, convert
Examine the set of relations in Figure 4-39. What normal form are these in? How do you know this? If they are in 3NF, convert the relations into an EER diagram. What assumptions did you have to make to answer these questions?

Attorney AttorneylD Name Address City State ZipCode Speciality AttorneylD Speciality Bar AttorneylD Bar Client Address ZipCode ClientID Name City State Telephone DOB Case CaselD Description CaseType CourtID Retains AttorneylD CaselD ClientID Date Court CourtName CourtID City State ZipCode Judge CourtID JudgelD Name Years
Step by Step Solution
3.52 Rating (159 Votes )
There are 3 Steps involved in it
For this situation in Figure 439 we assume that Client information is stored even if ... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
613-CS-DB (1699).docx
120 KBs Word File
