Use the short-form logical database schema and additional re…
Use the short-form logical database schema and additional requirements below to answer the following questions. Person(name, SSN) PK_Person(SSN) Company(tax_ID, name) PK_Company(tax_ID) UNIQUE(name) WorksFor(employee_SSN, employer_tax_ID, salary) PK_WorksFor(employee_SSN, employer_tax_ID) FK_WorksFor_Person(employee_SSN) REFERENCES Person(SSN) FK_WorksFor_Company(employer_tax_ID) REFERENCES Company(tax_ID) Additional Requirements: An SSN is always nine digits long, and we need to keep any leading zeros in an SSN; a company’s tax ID is always twelve digits long, and leading zeros are also important. Salary must be a number between 0 and 999999.99 when known. A name (whether of a person or of a company) is never more than 100 characters long, and every person and company must have a name. Write the long-form logical database schema for this short-form schema with the given requirements.