Developers are often tasked with creating interfaces that make it easy for non-developers to view and interact with information stored in databases. These interfaces are known as Content Management Systems (CMS). This application will provide a non-devloper the necessary tool to strucure its tracking by department, role and employee.
As a business owner, I want to be able to view and manage the departments, roles, and employees in my company so that I can organize and plan my business.
Using the comand line, I execute the application that accepts user input.
When I start the application, then I am presented with the following options: view all departments, view all roles, view all employees, add a department, add a role, add an employee, update an employee role, and exit
When I choose to view all departments, then I am presented with a formatted table showing department names and department ids.
When I choose to view all roles, then I am presented with the job title, role id, the department that role belongs to, and the salary for that role.
When I choose to view all employees, then I am presented with a formatted table showing employee data, including employee ids, first names, last names, job titles, departments, salaries, and managers that the employees report to.
When I choose to add a department, then I am prompted to enter the name of the department and that department is added to the database.
When I choose to add a role, then I am prompted to enter the name, salary, and department for the role and that role is added to the database.
When I choose to add an employee, then I am prompted to enter the employee’s first name, last name, role, and manager and that employee is added to the database.
When I choose to update an employee role, then I am prompted to select an employee to update and their new role and this information is updated in the database.
department:
id - INT PRIMARY KEY
name - VARCHAR(30) to hold department name
role:
id - INT PRIMARY KEY
title - VARCHAR(30) to hold role title
salary - DECIMAL to hold role salary
department_id - INT to hold reference to department role belongs to
employee:
id - INT PRIMARY KEY
first_name - VARCHAR(30) to hold employee first name
last_name - VARCHAR(30) to hold employee last name
role_id - INT to hold reference to employee role
manager_id - INT to hold reference to another employee that is manager of the current employee. This field may be null if the employee has no manager
https://github.com/rawc72/Challenge_No_12/issues/1#issuecomment-991935402