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.

Suppose that we try to run the following SQL statement on th…

Suppose that we try to run the following SQL statement on this database. INSERT INTO WorksFor(employee_SSN, employer_tax_ID) VALUES(‘123456789’, ‘111122223333’) Assuming that this statement runs successfully, what will the value of salary be for the resulting row of the WorksFor table?