Submit the relational data model schema, and any constraints, including primary and foreign key constraints for each of the following. 1. (35 pts) Consider the ER diagram for the AIRLINE database shown in the figure below. Build this design using a data modeling tool. 2. (65 pts) Design a database to automate the intake process for an estate planning attorney. The current process is based on capturing information in the attached form which every client completes. Specifically, the forms capture the family members who may be the beneficiaries of the estate, as well as a list of the various types of assets and the estimated values. You are hired to develop a database back-end that will serve as the backend to a web-based front-end that another team is developing. Design a logical schema for implementing this database on a relational database management system. List constraints, including primary-key and foreign-key constraints. Also, list any constraints and business rules uncaptured by the ERD. Joint Asset Questionnaire for Estate Planning JOINT ASSET QUESTIONNAIRE [Date] Husband’s name [husband’s name] U.S. Citizen [Y / N] Husband’s birth date: [husband’s birth date] Social Security number: [Social Security number] Wife’s name [wife’s name] U.S. Citizen [Y / N] Wife’s birth date: [wife’s birth date] Social Security number: [Social Security number] Names (and dates of birth) of children, their spouses, and grandchildren Children Dates of Birth Spouse Grandchildren Dates of Birth ___________ ___________ ___________ ___________ ___________ ___________ ________________ ________________ ________________ ___________ ___________ ___________ ___________ ___________ ___________ ________________ ________________ ________________ ___________ ___________ ___________ ___________ ___________ ___________ ________________ ________________ ________________ ___________ ___________ ___________ ___________ ___________ ___________ ________________ ________________ ________________ ___________ ___________ ___________ ___________ ___________ ___________ ________________ ________________ ________________ ITEMIZATION OF ASSETS Please list as many items as applicable in each category of assets in the appropriate column, depending on who owns the asset. Also include approximate value of asset in category. Registered in Husband’s Name Registered in Wife’s Name Registered in Joint Name Residence 1. Address Value: $___ 2. Address Value: $___ 3. … 1. Address Value: $___ 2. Address Value: $___ … 1. Address Value: $___ 2. Address Value: $___ … Cottage or condominium 1. Address Value: $___ 2. Address Value: $___ … 1. Address Value: $___ 2. Address Value: $___ … 1. Address Value: $___ 2. Address Value: $___ … Other real estate 1. Address Value: $___ 2. Address Value: $___ … 1. Address Value: $___ 2. Address Value: $___ … 1. Address Value: $___ 2. Address Value: $___ … Bank accounts and other cash deposits 1. Bank and Account Info Value: $___ Beneficiary Added: ☐ 2. Bank and Account Info Value: $___ Beneficiary Added: ☐ … 1. Bank and Account Info Value: $___ Beneficiary Added: ☐ 2. Bank and Account Info Value: $___ Beneficiary Added: ☐ … 1. Bank and Account Info Value: $___ Beneficiary Added: ☐ 2. Bank and Account Info Value: $___ Beneficiary Added: ☐ … Marketable securities 1. Investment Account Info Value: $___ Beneficiary Added: ☐ 2. Investment Account Info Value: $___ Beneficiary Added: ☐ … 1. Investment Account Info Value: $___ Beneficiary Added: ☐ 2. Investment Account Info Value: $___ Beneficiary Added: ☐ … 1. Investment Account Info Value: $___ Beneficiary Added: ☐ 2. Investment Account Info Value: $___ Beneficiary Added: ☐ … Registered in Husband’s Name Registered in Wife’s Name Registered in Joint Name Closely-held business interest 1. Business and Ownership Info Value: $___ 2. Business and Ownership Value: $___ … 1. Business and Ownership Value: $___ 2. Business and Ownership Value: $___ … 1. Business and Ownership Value: $___ 2. Business and Ownership Value: $___ … Life insurance (face amount less policy loans) 1. Life Insurance and Beneficiary Info Value: $___ 2. Life Insurance and Beneficiary Info Value: $___ … 1. Life Insurance and Beneficiary Info Value: $___ 2. Life Insurance and Beneficiary Info Value: $___ … 1. Life Insurance and Beneficiary Info Value: $___ 2. Life Insurance and Beneficiary Info Value: $___ … Pension or profitsharing plans, IRAs, 401(k)s, 403(b)s, etc. 1. Employer Name and Account Info Value: $___ Beneficiary Added: ☐ 2. Employer Name and Account Info Value: $___ Beneficiary Added: ☐ … 1. Employer Name and Account Info Value: $___ Beneficiary Added: ☐ 2. Employer Name and Account Info Value: $___ Beneficiary Added: ☐ … 1. Employer Name and Account Info Value: $___ Beneficiary Added: ☐ 2. Employer and Account Info Value: $___ Beneficiary Added: ☐ … Other assets 1. Asset Details Value: $___ 2. Asset Details Value: $___ … 1. Asset Details Value: $___ 2. Asset Details Value: $___ … 1. Asset Details Value: $___ 2. Asset Details Value: $___ … TOTAL $________ $________ $________