Employee Tracker database that allows me to add employees, roles, and departments to keep track of employees
https://choosealicense.com/licenses/mit/
install Dependancies then run mysql -u root -p enter password, select use database then enter data into the table fields. Then Seed the database. After that you can run the server to view the database
Use employee_db, then seed the database with db/seeds.sql. You can use SELECT * from table name: employee, roles, departments to view the data bases. mysql -u root -p.
- mysql -u root -p
- Use employee_db;
- source db/schema.sql;
- Source db/seeds.sq;
- Show tables;
- select * from department;
- select * from employee;
- select * from roles;
- INSERT INTO employee (id,role_id,employee_name) Values(6,6,’Jackson’);
- INSERT INTO roles (role_id, jobTitle) Values(7,”Security”);
- INSERT INTO employee (role_id, employee_name) Values(7,’Phoenix’);
- Node server
BinaryBitBytes
Tested by added departments, roles, and employees.
Github Profile | To reach me via Email 117mwc117@gmail.com