Assignment 2 Design a database for the law firm, Dewey, Cheetim and How. The law firm needs to track clients and cases. A case is filed by at least plaintiff against at least one defendent. Each case has a unique case number, a case filed date, a date closed and one of a select list of judgement descriptions. Cases are assigned to a court (District, County, Municipal, etc.) and may be assigned / reassigned to multiple judges over time. A case is brought by one or more plaintiffs. A case is against one or more defendents. A plaintiff or defendant may be a person or an organization. Parties (defendents and plaintiffs) may be involved in many cases. An individual party may be the plaintiff in one case, but a defendent in another. (As such, it would be best to store these in a single table.) For each case, the net worth of each party needs to be stored