Attach a relationahip schema (what tables have what data and the table relationships) for the data design as specified in the attached document.

Design a small database to store the following data (and eliminate redundancies): T-number City State Zip First Name MI | Last Name Address Street Address 1 Type Street Address Degree Degree Name Code Q Doe PR Apt C TO0000001 John TO0000001 | John TO0000002 Bruce Doe CA 101 Hunter Drive 129 Mechanic Street 101 Batcave Anderson SC Pendleton SC Huntingtonwy 29625 CPT 29670 CPT 25755 IST Wayne PR Computer Technology Computer Technology Information Systems Technology Information Systems Technology TO0000002 Bruce Wayne CA 142 Mechanic Street Pendleton SC 29670 IST Notes: TNumber: Unique identifier for each person; format is T plus 8 numeric digits Degree code: Unique identifier for each degree name PR = Permanent Address, CA = Campus Address (these are the two address types)