-- Create the users table
CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    first_name VARCHAR(100) NOT NULL,
    last_name VARCHAR(100) NOT NULL
);

-- Create the english_marks table
CREATE TABLE english_marks (
    id INT AUTO_INCREMENT PRIMARY KEY,
    student_id INT NOT NULL,
    marks INT DEFAULT NULL,
    FOREIGN KEY (student_id) REFERENCES users(id)
);

-- Create the math_marks table
CREATE TABLE math_marks (
    id INT AUTO_INCREMENT PRIMARY KEY,
    student_id INT NOT NULL,
    marks INT DEFAULT NULL,
    FOREIGN KEY (student_id) REFERENCES users(id)
);

-- Insert sample data into users
INSERT INTO users (first_name, last_name) VALUES
('John', 'Doe'),
('Jane', 'Smith'),
('Michael', 'Johnson');

-- Insert sample data into english_marks
INSERT INTO english_marks (student_id, marks) VALUES
(1, 85),
(2, 78),
(3, 90);

-- Insert sample data into math_marks
INSERT INTO math_marks (student_id, marks) VALUES
(1, 88),
(2, 82),
(3, 95);