aCREATE DATABASE ProjectDatabase;

USE ProjectDatabase;

-- Create tables
CREATE TABLE Project (
    p_no INT PRIMARY KEY,
    p_name VARCHAR(50),
    budget DECIMAL(10, 2),
    location VARCHAR(50)
);

CREATE TABLE Customer (
    id INT PRIMARY KEY,
    name VARCHAR(100),
    phn_number VARCHAR(15)
);

CREATE TABLE Assign (
    id INT,
    p_no INT,
    date DATE,
    FOREIGN KEY (id) REFERENCES Customer(id),
    FOREIGN KEY (p_no) REFERENCES Project(p_no)
);