Answered step by step
Verified Expert Solution
Question
1 Approved Answer
It actually a part of a project to run a payroll of 150 employee in the university with random salaries with taxes and return of
It actually a part of a project to run a payroll of 150 employee in the university with random salaries with taxes and return of investments?
Database Design (Phase 3 - Implementation): Now that all design phases of the Park University Payroll Database are complete and discussed, the team should now be well into the physical creation of the designed database using Microsoft Access and objects including tables, queries, forms, reports and macros to support form operations as needed. When introducing and preparing this section of the database design document, include a literature review based on research covering the purpose and uses of all database objects to be used in creating this database along with any important processes and steps used when creating the objects listed below: Tables: All tables as prepared and designed through the physical phase and with the support of data dictionaries created. In addition, use of the relationship tool should be used to establish any and all table relationships with the application using referential integrity where needed. This tool is located under "Database Tools." Furthermore, some test/fictional data should be entered in all tables and enough data should be entered to cover at least two fictional employees. Forms: Based on tables created requiring input, a form should be created for each. For extended use of forms, teams should consider that forms can also be used for various operations including navigation via a switchboard. In other words, be creative and see what the team can do in also using forms in creating the user interface of the database. o Queries: Based on tables created and data entered, create queries as needed to support minimum output of commonly seen information on payroll stubs including the employee's calculated gross pay, calculated deductions, and calculated net pay. Although not required, every team should consider additional queries with calculations to support output of payroll data which could further support management needs. Some of these queries could potentially output information to support compensation analysis, salary analysis, tax reports, and even trend analysis to name a few. Furthermore, in this extended effort and consideration, think about the concept behind needs for payroll analytics. Database Design (Phase 3 - Implementation): Now that all design phases of the Park University Payroll Database are complete and discussed, the team should now be well into the physical creation of the designed database using Microsoft Access and objects including tables, queries, forms, reports and macros to support form operations as needed. When introducing and preparing this section of the database design document, include a literature review based on research covering the purpose and uses of all database objects to be used in creating this database along with any important processes and steps used when creating the objects listed below: Tables: All tables as prepared and designed through the physical phase and with the support of data dictionaries created. In addition, use of the relationship tool should be used to establish any and all table relationships with the application using referential integrity where needed. This tool is located under "Database Tools." Furthermore, some test/fictional data should be entered in all tables and enough data should be entered to cover at least two fictional employees. Forms: Based on tables created requiring input, a form should be created for each. For extended use of forms, teams should consider that forms can also be used for various operations including navigation via a switchboard. In other words, be creative and see what the team can do in also using forms in creating the user interface of the database. o Queries: Based on tables created and data entered, create queries as needed to support minimum output of commonly seen information on payroll stubs including the employee's calculated gross pay, calculated deductions, and calculated net pay. Although not required, every team should consider additional queries with calculations to support output of payroll data which could further support management needs. Some of these queries could potentially output information to support compensation analysis, salary analysis, tax reports, and even trend analysis to name a few. Furthermore, in this extended effort and consideration, think about the concept behind needs for payroll analyticsStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started