• Source
    1. CREATE TABLE Departments
    2. (
    3. Id INT PRIMARY KEY,
    4. Name NVARCHAR(50)
    5. )
    6.  
    7. CREATE TABLE Employees
    8. (
    9. Id INT PRIMARY KEY,
    10. FirsName NVARCHAR(50),
    11. LastName NVARCHAR(50),
    12. Birthday DATETIME,
    13. DepId INT FOREIGN KEY REFERENCES Departments(Id) ON UPDATE CASCADE
    14. )