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 Z

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

1 Expert Approved Answer
Step: 1 Unlock

For this situation in Figure 439 we assume that Client information is stored even if ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Word file Icon

613-CS-DB (1699).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!