You were hired as an analyst to develop a new information

Assignment Help Database Management System
Reference no: EM13359245

You were hired as an analyst to develop a new information system to automate the payroll transactions in a mid-size organization. The proposed system will contain employees’ data and interface with the organization’s General Ledger system (GL). The new system will include information such as Employee ID, Employee Name (broken down into last name, first name), Employee SSN, Employee DOB, Employee Number of Dependents, Employee Title, Employee Grade, Employee Gross Salary, Tax Deducted, Employee Net Pay, Pay Interval, Cost Center, Payroll Account Number, etc. 

The proposed system total financial benefits exceed the total costs by $65,000 a year over the next five years. Create the following documents for the proposed system and deliver each SDLC documents by the end of each designated module, as shown below 

1- The Planning Phase: (Due at the end of Module 6) 

A- Create a system request 

B- Create a feasibility study 

C- Create a project plan 

2- The Analysis Phase: (Due at the end of Module 7) 

A- Requirement definitions 

B- Create the applicable Use cases 

C- Create the applicable process model 

D- Create the applicable data models 

3- The Design Phase: (Due at the end of Module 8) 

A- Alternative matrix 

B- Architecture report 

C- Hardware and software specifications 

D- Interface design 

E- Physical process model 

F- Program design 

G- Database and file specifications including physical data model 

4- The Implementation Phase: (Due at the end of Module 9) 

A- Test Plan 

B- Change Management Plan 

C- Business contingency plan 

D- Training plan  

Be sure to read the instructions in the Module Activity for each group assignment. Designate one person from your group to submit the assignment due that week. Be sure to include all of the names of the group members in the document(s). 

Reference no: EM13359245

Questions Cloud

Human resource-what are the criteria by which initial : human resource-what are the criteria by which initial assessment methods are evaluated?what are the criteria by which
With finite resources how does an organization assess how : with finite resources how does an organization assess how much of those resources to use for promotion? what is the key
Risks associated in employee engagementrefer to the modern : risks associated in employee engagementrefer to the modern appliances case study to identify and analyze the risks
Project management scoperesourceswho approves and rejects : project management scoperesourceswho approves and rejects changes to the scope of the project?who approves and rejects
You were hired as an analyst to develop a new information : you were hired as an analyst to develop a new information system to automate the payroll transactions in a mid-size
Pay satisfaction job satisfaction the organization : pay satisfaction job satisfaction the organization etc.analyze and explain the relationships among pay satisfaction job
Is there any risk to the employee in a defined benefit : is there any risk to the employee in a defined benefit plan?one of the advantages of the defined benefit plan to
Technology use in the workplacethe actual case study : technology use in the workplacethe actual case study analysiswhen considering the impact of the information age on
What do you think hr can do to provide management with a : what do you think hr can do to provide management with a better understanding of why exit interviews can be

Reviews

Write a Review

Database Management System Questions & Answers

  Identify a relational algebra tree

Identify a relational algebra tree (or a relational algebra expression if you prefer) that reflects the order of operations a decent query optimizer would choose.

  Design update trigger on part table which raises error

Design the Update trigger on Part table which raises an error string if Count field of updated row has a higher value than value prior to Update.

  Design updateable database for storing customer and sales

Design an updateable database for storing customer and sales data. Explain how to deal with the problems of missing data.

  Explain how data is physically stored and accessed

Write clearly and concisely about relational database management systems using proper writing mechanics and technical style conventions.

  Draw an entity relationship diagram for the system

Draw an Entity Relationship diagram for the system and Identify the table design for the database displaying all the fields/attributes. Ensure that all tables are in 3NF. You also need to identify the primary keys and foreign keys, where applicable..

  Questionethical and legal considerations in marketing

questionethical and legal considerations in marketing intellectual property and product safetyprepare a paper in which

  Problem 1- customers with certain list patternsnbspproblem

problem 1- customers with certain list patternsnbspproblem descriptionnbsp you are provided with four tables in

  Write three items contained in fat database

What does CHS stand for? List three items contained in the FAT database. List two features NTFS provides that FAT does not.

  Create a crow''s foot erd using a specialization hierarchy

Given the following business scenario, create a Crow's Foot ERD using a specialization hierarchy if appropriate. Tiny Hospital keeps information on patients and hospital rooms

  Draw an er diagram for database scenario

Draw an ER diagram for database scenario. Design a set of 3NF tables for your database scenario.

  When would creating an index reduce overall database perform

Indexing can affect the performance of a general-purpose database that has roughly equal numbers of fetches and changes. The decision to add an index can improve the performance of a system but can also degrade it.

  Problem on relational algebra

The database used for this question is a very simple one with the following schema: (Primary keys are bold, foreign keys are underlined)

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd