Explore BrainMass
Share

Explore BrainMass

    SQL Statements to Move the Foreign Key to T1

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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.

    © BrainMass Inc. brainmass.com October 9, 2019, 9:35 pm ad1c9bdddf
    https://brainmass.com/computer-science/data/sql-statements-move-foreign-key-191096

    Solution Preview

    Please see the attachment for the answer.

    Question
    Assume that tables T1 and T2 have a 1:1 relationship. Assunme that T2 has the foreign key. Show the SQL statements ...

    Solution Summary

    This response provides a tutorial on creating SQL statements to move a foreign key from one table to another.

    $2.19