Make a DATABASE design for the following situation. (do NOT make an ERD!!)

f you believe that you need to make non-obvious assumptions, please state them clearly. Each case handled by the law firm of Dewey, Cheetim, and Howe has a unique case number; a date opened, date closed, and judgment description are also kept on each case. A case is brought by one or more plain- tiffs, and the same plaintiff may be involved in many cases. Each plaintiff in each case has a requested judgment characteristic, such as a requested dollar award, possession of some asset, or other outcome. A case is against one or more defendants, and the same defendant may be involved in many cases. A plaintiff or defendant may be a person or an organization. Over time, the same person or organization may be a defendant or a plaintiff in cases. In either situation, such legal entities are identified by an entity number, and other attributes are name and net worth.

-You must provide the tables, relationships, and the fields.

- Clearly state every assumption that you make.

- Make sure you note primary keys and foregin keys in each table.

- When drawing the relationships, make sure the lines are pointing to the correct fields to indicate the foreign keys.