Question: Two related tables COURSE and COURSE REGISTRATION already exist with their primary keys. Both tables include a column courselD courselD is the primary key column

Two related tables COURSE and COURSE REGISTRATION

Two related tables COURSE and COURSE REGISTRATION already exist with their primary keys. Both tables include a column courselD courselD is the primary key column in COURSE Which of the following SQL will correctly create a foreign key using column courseld in COURSE REGISTRATION table? ALTER TABLE [COURSE REGISTRATION] ADD CONSTRAINT FK1 FOREIGN KEY (courseID) REFERENCES COURSE( [PRIMARY KEY]) i ALTER TABLE [COURSE REGISTRATION] ADD CONSTRAINT FK1 FOREIGN KEY (courseID) REFERENCES (courseID) ; ALTER TABLE [COURSE REGISTRATION] ADD CONSTRAINT FK1 (courseID) FOREIGN KEY COURSE (courseID) i ALTER TABLE [COURSE REGISTRATION] ADD CONSTRAINT FK1 FOREIGN KEY (courseID) REFERENCES COURSE (courseID) ; ALTER TABLE (COURSE REGISTRATION] ADD CONSTRAINT FK1

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

The Garrett-Tompkins Company provides three copy machines in its copying room for the use of its employees. However, due to recent complaints about considerable time being wasted waiting for a copier...

Assignment Title Modelling College This assignment relates to the following Course Learning Requirements: CLR 1 : Follow lab policies and procedures for etiquette, software licensing requirements and...

This data set represents the web server hit logs for a single website for a single day. You're going to do some analysis of the data, but first you need to normalize it properly -- which requires...

Table COURSEREG already exists. it is related to two other tables COURSE and STUDENT. COURSEREG has two foreign keys: 1) CourseNum to relate to COURSE where primary key column with the same name...

Mates Rates Rent-A-Car ( just do the part a) using visual studio code (C#) Criteria sheet - Par A Example supplementary files (readme.pdf) Example supplementary files (class-diagram.pdf) Assignment...

could someone please help me these access assignment Accounting Information Systems Access Assignment S&S Revenue Database Introduction to Microsoft Access: Microsoft Access is representative of...

My name is Salam Abdulhussein and I need this to be done as soon as possible. Please follow the steps one by one and make sure everything is correct Global Bike, Inc. ERP for Sales / Collection USING...

VALLEY FURNITURE DELIVERY DATA MODELING ASSIGNMENT MGMT 4013 TC1, Spring 2018 Your assignment is to create a data model based on the scenario and data below. For your convenience, I have included the...

CSIS 325 Lab 4 (SQL CREATE TABLE) Before beginning this lab, be sure you have successfully downloaded and installed SQL Server Express 2014: (You should have already done this in your first lab, but...

BYGB/ISGB 7973: ASSIGNMENT 2 DATABASE MANAGEMENT SQL Assignment Part I You may want to use the CreateTable_TG.ddl that we used for the TradeGroup an exemplar for this question. This exercise is based...

You are a small database consulting company who designs and develops databases for small to medium sized businesses. You have now been hired to design and implement a database system for the dream...

Presented below is information related to the pension plan of Zimmer Inc. for the year 2017. 1 The service cost related to pension expense is $240,000 using the projected benefits approach. 2 The...

Apple products have usually been priced above their competition and sold for their value, intrigue, and market leadership. Some would say Samsung is catching up on many of these fronts and even...

A useful tool that reproduces the budget at various levels of unit sales is a ( n ) Multiple Choice flexible budget. application budget. allocation budget. normal budget.

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...