Can I get entity relationship diagram for time tracking system



Time Tracking ( Entity Relationship Diagram)visit this page
http://createlydiagram/example/hig4v0hu1/Time%20Tracking

time tracking system entity relationship diagram


Instantly Turn PCs into Secure Time Tracking Systems—No Hardware Required
Employees with access to a computer can take advantage of our online time and attendance tracking system, and clock in and out from any computer with Internet access. WebPunch collects live time and attendance data, which is stored in our human capital management system and accessible in real time.
EPAY’s online time tracking option is easy to set up and deploy, like every other aspect of our robust HCM system!

Employee Time and Task Tracking System
1. Employee Task Tracking System (ETS)
2. Introduction• ETS will help IT Manager to manage tasks assigned to employee and time spent on each task• ETS will allow IT Manager to define o Projects o Tasks Categories o Tasks o Task Schedules
3. Introduction …• Manager can assign tasks to employees• Monitor tasks status & time spent on tasks• Close a task• Manager can take reports showing o Employee Activity History o Project Tasks History
4. Actors Catalog• IT Manager• IT Employee
5. Functional Requirements• Define Project• Define Task Categories• Define Tasks and its schedule• Assign Tasks to Employees• Record actual time spent on tasks• Change Task status• Create logins for employee• Generate Reports
6. Use Case Diagram
7. Architectural Design
8. Project Scope Software scope covers following functions Define Project Define Tasks Categories Define Tasks Define Tasks Schedule Assign Tasks to employees Record actual time spent on tasks Change task status Provide report on Employee task history Provide project task history report Provide Employee efficiency report Create logins for new employees
9. Project Scope (continue)
10. Project Schedule
11. Sequence Diagram – User Login
12. Sequence Diagram – User Login
13. Sequence Diagram – User Login
14. Sequence Diagram – User Login
15. Sequence Diagram – Manage Projects
16. Sequence Diagram – Add Tasks
17. Sequence Diagram – Assign Tasks
18. Sequence Diagram – Update Tasks
19. Sequence Diagram – Create Logins
20. Entity-Relationship Diagram EmployeeTasks Employees Projects Tasks TaskTime EmployeeTasks Task_ID (FK) Employee_ID (FK) Task_Assign_Date Tasks EmployeesProjects Task_ID Employee_ID TaskTime Project_ID Employee_Name Task_Name Task_ID (FK) Project_Name Task_Desc Employee_Phone Employee_ID (FK) Project_Desc Task_Start_Date Employee_Address Proj_Start_Date Task_End_Date Task_Work_Start_Date Employee_Manager Proj_End_Date Task_Status Task_Work_End_Date Project_ID (FK)
21. Logical Model/Class Diagram
22. Logical Model/Class Diagram
23. Database Design EmployeeTasks Task_ID: INTEGER NOT NULL Employee_ID: INTEGER NOT NULL Task_Assign_Date: DATE NULL Tasks TaskTime EmployeesProjects Task_ID: INTEGER NOT NULL Task_ID: INTEGER NOT NULL Employee_ID: INTEGER NOT NULL Project_ID: INTEGER NOT NULL Task_Name: VARCHAR2(20) NOT NULL Employee_ID: INTEGER NOT NULL Task_Desc: VARCHAR2(20) NULL Employee_Name: VARCHAR2(20) NOT NULL Project_Name: VARCHAR2(20) NOT NULL Task_Start_Date: DATE NULL Task_Work_Start_Date: DATE NULL Employee_Phone: INTEGER NULL Project_Desc: VARCHAR2(20) NULL Task_End_Date: DATE NULL Task_Work_End_Date: DATE NULL Employee_Address: VARCHAR2(20) NULL Proj_Start_Date: DATE NULL Task_Status: VARCHAR2(20) NULL Employee_Manager: INTEGER NULL Proj_End_Date: DATE NULL Project_ID: INTEGER NULL
24. User Interfaces – Create Logins
25. User Interfaces – Assign Task
26. User Interfaces – View Task
27. ToolsTasks Development ToolsDBMS Oracle 10gSoftware Development Oracle JDeveloper 10gmOperating System Microsoft Windows Server 2008Tasks Diagram ToolsUse Case Diagram Smart Draw 2008Data Flow Diagram Smart Draw 2008Entity Relationship Diagram ErwinSequence Diagram Microsoft Visio 2007Architectural Design Diagram Microsoft Visio 2007Class Diagram AltovaDatabase Design ErwinInterface Design Oracle JDevelper
28. Test Cases User Login SuccessfulTest Case: Login to application using correct username passwordDescription: This test will ensure the working of logon procedureData Requirements: Valid username and password & Connectivity to database isessential for this processStep # Step Description Expected Results Transaction Name1 Launch application Main application Launch application by calling its url or log on window address should open2 Enter valid Password letters Enter logon username and should be encrypted information password and not shown on screen3 Press logon button User should log on Log on to or press “ENTER” and user main application button on keyboard welcome window should open
29. Test Cases User Login FailureTest Case: Login to application using in-correct username passwordDescription: This test will ensure the working of logon procedureData Requirements: Imaginary username and password & Connectivity to database isessential for this processStep # Step Description Expected Results Transaction Name1 Launch application Main application Launch application by calling its url or log on window address should open2 Enter imaginary Password letters Enter logon username and should be encrypted information password and not shown on screen3 Press logon button User should get Log on to or press “ENTER” warning screen application button on keyboard displaying username/password not correct
30. Test Cases Add Projects Valid DataTest Case: Add Projects to databaseDescription: This test will ensure the addition of project.Data Requirements: Valid login and permissions to create projectsStep # Step Description Expected Results Transaction Name1 Click on menu bar Menu will be Adding Project opened Information2 From menu bar New form will be Adding Project Select Add Projects displayed Information3 Fill out the form and Project will be Adding Project press Save button added to the Information database
31. Test Cases Add Projects Wrong DataTest Case: Add Projects to databaseDescription: This test will ensure the validation of data during addition of project.Data Requirements: Valid login and permissions to create projectsStep # Step Description Expected Results Transaction Name1 Click on menu bar Menu will be Adding Project opened Information2 From menu bar New form will be Adding Project Select Add Projects displayed Information3 Fill out the form and Warning screen Adding Project leave project name should display, Information blank press Save showing project not button saved and data error message
32. Test Cases Add Projects Valid DataTest Case: Add Projects to databaseDescription: This test will ensure the addition of project.Data Requirements: Valid login and permissions to create projectsStep # Step Description Expected Results Transaction Name1 Click on menu bar Menu will be Adding Project opened Information2 From menu bar New form will be Adding Project Select Add Projects displayed Information3 Fill out the form and Project will be Adding Project press Save button added to the Information database
33. Test Cases Add Tasks Valid DataTest Case: Add Tasks to the databaseDescription: This test will ensure the addition of task.Data Requirements: Valid login and permissions to create tasksStep # Step Description Expected Results Transaction Name1 Click on menu bar Menu will be Adding Tasks opened Information2 From menu bar New form will be Adding Tasks Select Add Tasks displayed Information3 Fill out the form and Tasks will be added Adding Tasks press Save button to the database Information
34. Test Cases Add Tasks Wrong DataTest Case: Add Tasks to the databaseDescription: This test will ensure the validation of data during addition of taskData Requirements: Valid login and permissions to create tasksStep # Step Description Expected Results Transaction Name1 Click on menu bar Menu will be Adding Tasks opened Information2 From menu bar New form will be Adding Tasks Select Add Tasks displayed Information3 Fill out the form and Tasks will not be Adding Tasks leave project added to the Information column blank and database and press Save button warning message will show data error
35. Test Cases Define Tasks ScheduleTest Case: Define tasks schedule in the databaseDescription: This test will ensure the addition of tasks scheduleData Requirements: Connectivity to database and task already created in DBStep # Step Description Expected Results Transaction Name1 Click on menu bar Menu will be Define tasks opened schedule2 From menu bar New form will be Define tasks Select define task displayed schedule schedule3 Define task Schedule will be Define tasks schedule and press assigned to task schedule Save button
36. Test Cases Define Tasks Schedule Wrong EntryTest Case: Define tasks schedule in the databaseDescription: This test will ensure the validation of data during addition of tasks scheduleData Requirements: Connectivity to database and task already created in DBStep # Step Description Expected Results Transaction Name1 Click on menu bar Menu will be Define tasks opened schedule2 From menu bar New form will be Define tasks Select define task displayed schedule schedule3 Define task Schedule will not be Define tasks schedule with finish added to the schedule date less than start database and date and press Save warning message button will show data error
37. Test Cases Assign Tasks to EmployeesTest Case: Assign created tasks to employeesDescription: This test will ensure the tasks can be assigned to employees.Data Requirements: Connectivity to database and tasks and employees created in DBStep # Step Description Expected Results Transaction Name1 Click on menu bar Menu will be Assign Tasks opened2 From menu bar New form will be Assign Tasks Select assign task displayed3 Chose task and Task will be Assign Tasks assign employee to assigned to tasks and press Save employee button
38. Test Cases Assign Tasks to Employee Wrong EntryTest Case: Assign created tasks to employeesDescription: This test will ensure the data validation while assigning tasks to employees.Data Requirements: Connectivity to database and tasks and employees created in DBStep # Step Description Expected Results Transaction Name1 Click on menu bar Menu will be Assign Tasks opened2 From menu bar New form will be Assign Tasks Select assign task displayed3 Chose task and do Task will not be Assign Tasks not assign any assigned to any employee to tasks employee and and press Save warning message button will show data error
39. Test Cases Update Task StatusTest Case: Update Task Status to finish, close or delayDescription: This test will ensure the tasks status can be modified.Data Requirements: Connectivity to database and tasks already created in DatabaseStep # Step Description Expected Results Transaction Name1 Click on menu bar Menu will be Update Tasks opened2 From menu bar New form will be Update Tasks Select update task displayed3 Chose task and Task will be Update Tasks change task status to updated in DB finish and press Save button
40. Test Cases Update Task Status Wrong EntryTest Case: Update Task Status to finish, close or delayDescription: This test will ensure the validation of data while changing tasks status.Data Requirements: Connectivity to database and tasks already created in DatabaseStep # Step Description Expected Results Transaction Name1 Click on menu bar Menu will be Update Tasks opened2 From menu bar New form will be Update Tasks Select update task displayed3 Chose task and Task will not be Update Tasks change task status to updated in DB and finish without warning message entering finish date will show the data and press Save error. button