CREATE TABLE Students (
    student_id INT PRIMARY KEY,
    student_name VARCHAR(100) NOT NULL,
    email VARCHAR(100) UNIQUE
);
INSERT INTO Students (student_id, student_name, email)
VALUES
(101, 'calorie', 'calorie@gmail.com'),
(102, 'animal', 'animal@gmail.com');

SELECT * FROM Students;
INSERT INTO Students (student_id, student_name, email)
VALUES (103, 'maron', 'maron@gmail.com');
SELECT *FROM Students;

CREATE TABLE payments2(
    payment_id INT PRIMARY KEY,
    student_id INT NOT NULL,
    amount DECIMAL (10,2) NOT NULL CHECK (amount>0),

    FOREIGN KEY (student_id)
    REFERENCES Students(student_id)
    );
INSERT INTO payments2 (payment_id, student_id, amount)
VALUES (1, 101, 5000.00);
 Select * from payments2;

CREATE TABLE departments_restrict (
    department_id INT PRIMARY KEY,
    department_name VARCHAR(100) NOT NULL
);

CREATE TABLE students_restrict (
    student_id INT PRIMARY KEY,
    student_name VARCHAR(100) NOT NULL,
    department_id INT,

    FOREIGN KEY (department_id)
        REFERENCES departments_restrict(department_id)
        ON DELETE RESTRICT
);-- Insert departments
INSERT INTO departments_restrict VALUES
(1, 'Computing'),
(2, 'Business'),
(3, 'Engineering');

-- Insert students
INSERT INTO students_restrict VALUES
(101, 'calorie', 1),
(102, 'animal', 1),
(103, 'maron', 2),
(104, 'Amal', 3);
select * from departments_restrict;
select* from students_restrict;