Consider the following ERD. Convert it to a relational model and normalize it. ATTORNEY Attorney ID...

Transcribed Image Text:

Consider the following ERD. Convert it to a relational model and normalize it. ATTORNEY Attorney ID Attorney Name Attorney Street Address Attorney City Attorney State Attorney Zip Code (Attorney Bar) (Attorney Specialty} CASE Case ID Case Type Case Description # H ASSIGNMENT Placed In CLIENT Client ID Client Name Client Street Address Client City Client State Client Zip Code Client Phone Client DOB COURT Court ID Court Name Court City Court State Court Zip Code Presides Over JUDGE Judge ID Judge Name Judge years In parctice CLIENT DEPENDENT Dependent Name Consider the following ERD. Convert it to a relational model and normalize it. ATTORNEY Attorney ID Attorney Name Attorney Street Address Attorney City Attorney State Attorney Zip Code (Attorney Bar) (Attorney Specialty} CASE Case ID Case Type Case Description # H ASSIGNMENT Placed In CLIENT Client ID Client Name Client Street Address Client City Client State Client Zip Code Client Phone Client DOB COURT Court ID Court Name Court City Court State Court Zip Code Presides Over JUDGE Judge ID Judge Name Judge years In parctice CLIENT DEPENDENT Dependent Name