Purchase Solution

SQL Statements to Move the Foreign Key to T1

Not what you're looking for?

Ask Custom Question

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.

Purchase this Solution
Solution Summary

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

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 ...

Purchase this Solution
Free BrainMass Quizzes
Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.

Javscript Basics

Quiz on basics of javascript programming language.

C++ Operators

This quiz tests a student's knowledge about C++ operators.

C# variables and classes

This quiz contains questions about C# classes and variables.

Word 2010: Tables

Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.

View More Free Quizzes
Related BrainMass Solutions

  • Write SQL Statements

    FOREIGN KEY(to_account_no) REFERENCES ACCOUNTS(account_no), ) (a) Write three SQL statements: the first statement should add the pending amounts to the appropriate accounts, the second statement should subtract the pending amounts from the appropriate

  • SQL DDL and DML Queries

    Submit the SQL statements in the right sequence. Worker: pk=workerid. Foreign key=skillid, referencing Skill Skill: pk=skillid. Foreign key=ApprovedBy, referencing worker Drop worker and skill tables that you have just created.

  • Creating a databse using Microsoft SQL Server

    The primary key from the Job_title table will appear as a foreign key in the Employee table.

  • SQL Server Database for Kudler Fine Foods/Service

    The primary key from the Job Title table will appear as the foreign key in the Employee table.

  • Kudler Fine Foods- Complete Database SQL Queries

    The primary key from the Job Title table will appear as the foreign key in the Employee table.

  • SQL Server Database

    The primary key from the Job Title table will appear as the foreign key in the Employee table.

  • Designing a sample relational database

    It explains why the tables are created the way they are. It also includes SQL statements to create the database.

  • Working with tables in MS SQL server 2005

    The Solution is attached below It will tell us how to create a table with specified columns in SQL Server 2005. How can we add Foreign Key constraints ? How can we add Check constraints on particular columns ?

  • Creating Tables Using SQL Server

    Alter the Territories table to establish a foreign key between Territories and Regions. o Territories.RegionID references Regions.RegionID 8.

View More Related Solutions