SQL - Table Constraints
Given these tables:
CREATE TABLE Departments (DeptID INT PRIMARY KEY, DeptName VARCHAR(50));
CREATE TABLE Employees (EmpID INT PRIMARY KEY, EmpName VARCHAR(50), DeptID INT, FOREIGN KEY (DeptID) REFERENCES Departments(DeptID));
What happens if you run:
INSERT INTO Employees (EmpID, EmpName, DeptID) VALUES (1, 'Alice', 10);
Assuming no DeptID = 10 exists in Departments?
CREATE TABLE Departments (DeptID INT PRIMARY KEY, DeptName VARCHAR(50));
CREATE TABLE Employees (EmpID INT PRIMARY KEY, EmpName VARCHAR(50), DeptID INT, FOREIGN KEY (DeptID) REFERENCES Departments(DeptID));
What happens if you run:
INSERT INTO Employees (EmpID, EmpName, DeptID) VALUES (1, 'Alice', 10);
Assuming no DeptID = 10 exists in Departments?