A database is planned to consist of the following relations. New relations will not be added to the database. New information may be added to relations. TEACHING ASSISTANT TA ID NAME TA1 SMITII TA2 ZHANG TA3 LIU DEPT NO DI D2 DI UCSB DEPARTMENT DEPT_NO D1 D2 NAME SOCIOLOGY GEOGRAPHY OFFICE TA ID 1 TA2 OFFICE SH 01 SII 02 SH 01 PHONE EXT 345 454 345 Database Description TEACHING ASSISTANT TA ID: a unique identifier is assigned to each teaching assistant (TA) NAME: TA's name DEPT_NO: a unique identifier is assigned to each UCSB academic department UCSB DEPARTMENT DEPT_NO: a unique identifier is assigned to cach UCSB academic deparlment. NAME: Name of academic department OFFICE TA_ID: a unique identifier is assigned to each teaching assistant (TA) OFFICE: office identification number. Each TA can only be assigned one office but may have to share. PHONE EXT: landline phone extension. Each office has only one phone ext. A) For the above database identify the following: a domains b) candidate and primary keys c) foreign keys B) A new TA, named GARCIA, joins the GEOGRAPHY department. He is assigned the office SH 03 with phone extension 613. You are asked to update the database to show this new information. Write out the relations updated with tuples indicating the new information