database_pw

CREATE DATABASE pwskills;
USE pwskills;

CREATE TABLE teachers (
    t_id INT,
    t_name CHAR(50),
    PRIMARY KEY (t_id)
);

CREATE TABLE pwstudents (
    student_id INT NOT NULL,
    student_name CHAR(50),
    student_email VARCHAR(100) UNIQUE,
    joining_date DATE DEFAULT '2023-11-11', -- Corrected default date format
    short_desc TEXT,
    marks DECIMAL(5, 2), -- Adjusted decimal precision and scale
    teacher_id INT,
    PRIMARY KEY (student_id),
    FOREIGN KEY (teacher_id) REFERENCES teachers(t_id) -- Corrected FOREIGN KEY syntax
);