Question

Organize and draw 3NF relations (in other words, draw one schema in 3NF) for the below law firm problem. DEF NET WORTH DEFENDANT Def No Def Name Def Type Brought Against CASE Case No Case Opened Case Closed Case Judgment PLAINTIFF Plaintiff No Plaintiff Name Plaintiff Type Brought By Requested Judgment Plaintiff Net Worth

Answer 1

Solution DEFENDANT Def No Def_Type Def Name DEFNETWORTH Def No Networth Case No CASE Case_Opened Case_Closed Case_Judgment Case No PLAINIFFNETWORTH Plaintiff No Networth Case No PLAINTIFF Plaintiff No Plaintiff Name Plaintiff Type

Explanation The above schema diagram is to Hemonstrate the 3NF relations. Primary key is mentioned with underlined. Dependency is mentioned in arrow symbol