TaskProject/InsertQuery.txt

Table Name: users

INSERT INTO users (id, username, email, password_hash, created_at) VALUES (1, 'Aaron', 'aaronclinder@yahoo.com', '345678', CURRENT_TIMESTAMP);
INSERT INTO users (id, username, email, password_hash, created_at) VALUES (2, 'Suresh', 'sureshtimsina@gmail.com', '123456', CURRENT_TIMESTAMP);		
INSERT INTO users (id, username, email, password_hash, created_at) VALUES (3, 'Landen', 'landenjohnson@gmail.com', '234567', CURRENT_TIMESTAMP);
INSERT INTO users (id, username, email, password_hash, created_at) VALUES (4, 'Aaron', 'aaronclinder@gmail.com', '345678', CURRENT_TIMESTAMP);
INSERT INTO users (id, username, email, password_hash, created_at) VALUES (5, 'Krish', 'krish@gmail.com', '456789', CURRENT_TIMESTAMP);

Table Name: Student

INSERT INTO student (sid, sname, major, level, byear) VALUES (1, 'Aaron', 'Computer Science', 'senior', 2000);
INSERT INTO student (sid, sname, major, level, byear) VALUES (2, 'Suresh', 'Computer Science', 'junior', 2001);
INSERT INTO student (sid, sname, major, level, byear) VALUES (3, 'Landen', 'Computer Science', 'senior', 2002);
INSERT INTO student (sid, sname, major, level, byear) VALUES (4, 'Bob', 'Public Health', 'sophomore', 2003);
INSERT INTO student (sid, sname, major, level, byear) VALUES (5, 'Alice', 'Physic', 'freshman', 2004);

Table name : Project

INSERT INTO project (pid, pname, sdate, edate, pi, copi) VALUES (1, 'Website Redesign', '2024-01-01', '2024-03-31', 1, 2);
INSERT INTO project (pid, pname, sdate, edate, pi, copi) VALUES (2, 'Mobile App Development', '2024-02-15', '2024-05-15', 2, 3);
INSERT INTO project (pid, pname, sdate, edate, pi, copi) VALUES (3, 'Database Migration', '2024-03-10', '2024-06-10', 3, 1);
INSERT INTO project (pid, pname, sdate, edate, pi, copi) VALUES (4, 'AI Research', '2024-04-05', '2024-07-05', 1, 2);
INSERT INTO project (pid, pname, sdate, edate, pi, copi) VALUES (5, 'Marketing Campaign', '2024-05-20', '2024-08-20', 2, 3);

Table name : faculty

INSERT INTO faculty (fid, fname, department) VALUES (1, 'Aaron', 'Computer Science');
INSERT INTO faculty (fid, fname, department) VALUES (2, 'Jane', 'Electrical Engineering');
INSERT INTO faculty (fid, fname, department) VALUES (3, 'Alice', 'Physic');
INSERT INTO faculty (fid, fname, department) VALUES (4, 'Bob', 'Public Health');
INSERT INTO faculty (fid, fname, department) VALUES (5, 'Landen', 'Computer Science');

Table name : assigned

INSERT INTO assigned (sid, pid, sdate, edate) VALUES (1, 1, '2024-01-01', '2024-03-31');
INSERT INTO assigned (sid, pid, sdate, edate) VALUES (2, 2, '2024-02-15', '2024-05-15');
INSERT INTO assigned (sid, pid, sdate, edate) VALUES (3, 3, '2024-03-10', '2024-06-10');
INSERT INTO assigned (sid, pid, sdate, edate) VALUES (4, 4, '2024-04-05', '2024-07-05');
INSERT INTO assigned (sid, pid, sdate, edate) VALUES (5, 5, '2024-05-20', '2024-08-20');