-- Create Department Table
CREATE TABLE Department (
    Department_ID NUMBER PRIMARY KEY,
    Department_Name VARCHAR2(100) NOT NULL
);

-- Create Instructor Table
CREATE TABLE Instructor (
    Instructor_ID NUMBER PRIMARY KEY,
    Instructor_Name VARCHAR2(100) NOT NULL,
    Department_ID NUMBER,
    CONSTRAINT fk_department
        FOREIGN KEY (Department_ID)
        REFERENCES Department(Department_ID)
);

-- Create Module Table
CREATE TABLE Module (
    Module_Code VARCHAR2(10) PRIMARY KEY,
    Module_Name VARCHAR2(100) NOT NULL,
    Instructor_ID NUMBER,
    CONSTRAINT fk_instructor
        FOREIGN KEY (Instructor_ID)
        REFERENCES Instructor(Instructor_ID)
);

-- Create Student Table
CREATE TABLE Student (
    Student_Number NUMBER PRIMARY KEY,
    First_Name VARCHAR2(50) NOT NULL,
    Last_Name VARCHAR2(50) NOT NULL,
    Date_Of_Birth DATE,
    Gender VARCHAR2(10),
    Email VARCHAR2(100),
    Phone_Number VARCHAR2(20)
);