Question: Following code is generating an error message I can not resolve. Please help. The error message is posted above the code. Error Code: 1215. Cannot

Following code is generating an error message I can not resolve. Please help. The error message is posted above the code.

Error Code: 1215. Cannot add foreign key constraint 0.375 sec

CREATE TABLE QUALIFIED

(FacultyID INT, CourseID VARCHAR(8) ,

DateQualified DATE,

CONSTRAINT QUALIFIED_PK PRIMARY KEY (FacultyID, CourseID),

CONSTRAINT QUALIFIED_FK FOREIGN KEY (FacultyID) REFERENCES FACULTY(FacultyID),

CONSTRAINT QUALIFIED_FK FOREIGN KEY (CourseID) REFERENCES COURSE(CourseID));

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

The error message Error Code 1215 Cannot add foreign key constraint is due to issue with defining fo... View full answer

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 Databases Questions!

Q:

Error code 1215 Cannot add foreign key constraint in MySQL Workbench CREATE TABLE QUALIFIED (FacultyID INT NOT NULL, CourseID CHAR(8) NOT NULL, DateQualified DATE, CONSTRAINT Qualified_PK PRIMARY KEY...

Q:

Why do I have this error at the end? Everything seems to be typed right but it still gives me the foreign key constraint error? mysql> create table vendor ( vname varchar(30) primary key, address...

Q:

List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...

Q:

QUESTION 6 Questions 6-13 Uses the following E-R diagram Employee Employes ID Name EMPLOYEE Is assigned Office Number SALES OFFICE Location Lists Property Address City PROPERTY State Location Zip...

Q:

QUESTION 6 How many tables are created from the E-R diagram in Fig. 3? a. 6 b. 3 c. 4 d. 5 1 points QUESTION 7 Consider the following statement: Alter table employee Add constraint...

Q:

I am doing a project for my c programming class, and was hoping I could get some help. The Project: Dynamic Arrays and File I/O with Matrix Operations In this program we will create a program that...

Q:

import java.util.Random; public class CSCI225Lab7Driver { static Random r = new Random(System.nanoTime()); // The following constants can be changed static final int maxkey = 10000; // size of...

Q:

import java.util.Random; public class CSCI225Lab7Driver { static Random r = new Random(System.nanoTime()); // The following constants can be changed static final int maxkey = 10000; // size of...

Q:

Hash Tables and Open Addressing In this lab you are given an implementation of an open addressing hash table. Download the files MyHashTable.java and CSCI225Lab7Driver.java and add them to a new...

Q:

Hash Tables and Open Addressing In this lab you are given an implementation of an open addressing hash table Download the files MyHashTable.java and CSCI225Lab7Driver.java and add them to a new...

Q:

To examine the trade- off between efficiency and market power from a merger, consider a market with two firms that sell identical products. Firm 1 has a constant marginal cost of 1, and Firm 2 has a...

Q:

1. After working in accounting for fifteen years, you and two friends have decided, you would really like to start your own firm. Some of the initial consultations you have had in your meetings have...

Q:

LarCalcET 8 9 . 5 . 0 2 1 . Consider the following series. n = 1 s i n ( ( 2 n - 1 ) 2 ) Rewriting the sum in the form n = 1 ( - 1 ) n 1 a n gives a n = Find the following limit . ( If the limit is...

Q:

Prove that an n-entry multiway search tree has n+1 external nodes.

Q:

Professor Narcissus claims that if a relation R is symmetric and transitive, then it is also reflexive. He offers the following proof. By symmetry, a R b implies b R a. Transitivity, therefore,...

Q:

Refer to the Baseball 2018 data that report information on the 30 Major League Baseball teams for the 2018 season. a. In the data set, the year opened is the first year of operation for that stadium....

Q:

Find Io in the circuit in Figure 8.14 4 3Q i2 13 2420W Io 2 Figure P8. 14

Q:

Researchers at the Oak Ridge (Tennessee) National Laboratory have developed an algorithm to estimate the numbers of expected and excess cases of thyroid cancer occurring in the lifetime of those...

Q:

One-third of companies bracing for higher employee turnoverHow does employee engagement impact job satisfaction?What does this article state about employee turnover?Why would it be important to...

Q:

John Fuji (age 37) moved from California to Washington in December 2011. He lives at 468 Cameo Street, Yakima, WA 98901. John's Social Security number is 571-78-5974 and he is single. His earnings...

Q:

Cypress Corporation has regular taxable income of $170,000 (assume annual gross receipts are greater than $5 million) and regular tax liability of $49,550 for 2012. The corporation also has tax...

Q:

Indicate, in each of the following situations, the number of exemptions the taxpayers are entitled to claim on their 2012 income tax returns. Number of Exemptions a. Donna, a 20-year-old single...

Q:

Explain how groupthink leads to mismanaged conflict.

Q:

List the three solutions for developing a more playful attitude.

Q:

Distinguish between hyperstress and distress.