Sql statements to move the foreign key


Discuss the below:

Q: Assume that tables T1 and T2 have a 1:1 relationship. Assume that T2 has the foreign key. Show the SQL statements necessary to move the foreign key to T1. Make up your own names for primary and foreign keys.

Solution Preview :

Prepared by a verified Expert
Database Management System: Sql statements to move the foreign key
Reference No:- TGS01932890

Now Priced at $20 (50% Discount)

Recommended (98%)

Rated (4.3/5)