You have been asked to build a database to handle informationabout law firms. Each law firm is identified by a name that isunique within a city, and also have a count of how many non-lawyeremployees each firm employs. Lawyers are identified by their socialsecurity number, and also have a name, address, and salary. Alawyer may be employed by at most one rm. Each lawyer handles aload of cases identified by a case number. Cases may be handled bymore than one lawyer, even if the lawyers work for differentfirms.
- Draw an E-R diagram for the requirements above.
- Translate your E-R diagram into SQL
OR
PayPal Gateway not configured
ORPayPal Gateway not configured