You were hired as an analyst to develop a new information

Assignment Help Database Management System
Reference no: EM13360362

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 

Reference no: EM13360362

Questions Cloud

Time value of money problemsnbspnbspquestion 1 joe a : time value of money problemsnbspnbspquestion 1. joe a carlson school graduate you recently hired needs 55000 in 4 years
Valuation principle problemsnbspnbspquestion 1 suppose that : valuation principle problemsnbspnbspquestion 1 suppose that bondi inc. is a holding company that owns both pizza hut
Short answer questionsnbspnbsp1 explain the economic : short answer questionsnbspnbsp1. explain the economic interpretation of the discount factor 1interest rate factor
Case 1 - demand estimation and elasticity soft drinks in : case 1 - demand estimation and elasticity soft drinks in the u.s.nbspnbspdemand can be estimated with experimental data
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
A statewide survey of 1706 california adultsrsquo residents : a statewide survey of 1706 california adultsrsquo residents include the following question would you favor or oppose
Civil engineering thesis calculations part missing : civil engineering thesis. calculations part missing progressive collapse calculations 20 pages explain the formula you
2600-3000 word term paper on the following topichow does : 2600-3000 word term paper on the following topichow does canadas approach to multiculturalism compare to that of other
Part 1write a short essay of approximately 750 words on one : part 1write a short essay of approximately 750 words on one of the following topics. be sure that you are presenting

Reviews

Write a Review

Database Management System Questions & Answers

  Create a relational database schema

Draw the ER diagram for the database described above and create a relational database schema for this model assuming

  Describe binary lock function

Describe relationships with example. Also illustrate degree of relationship for that example. What do you mean by locks. Write dow a binary lock function.

  Do a requirements analysis for the case study

To apply and consolidate skills acquired in the requirement and analysis disciplines through analysis of a simple case study, and to express the results through the relevant UML diagrams. ITC203

  Assignment 5 logical design part ii problem your e-r model

assignment 5 logical design part ii problem your e-r model from a prior week was a success assignment 2 - logical

  Ways of implementing one-to-one relationships

Describe the difference ways of implementing one-to-one relationships. Assume you are maintaining information on offices (office numbers, building, and phone numbers)

  Designing and documenting your system

Create a document named: surnameStudentIDAssign1.doc .  In your document, you must include the following section headings:  System Overview, Class Diagram, Class Descriptions, Testing.

  Briefly how to make use of indexes such as b+ tree

Summarize briefly how to make use of indexes such as B+ tree or a hash indexes in selection, projection, and join operations?

  Identification of data requirements from different user

Structured Methodologies, Data Flow Diagrams, Entity Relationship diagrams, Structured English, Decision Tables and Cohesion/coupling.

  Build entity relationship model military information system

Build an entity relationship model for the above scenario. Show all attributes and indicate all of your key attributes in red.

  Explain multidimensional analysis

Give at least three reasons why ETL functions are most challenging in a data warehouse environment.

  Design an relational model model

Design an Relational Model (RM) model of a database (DB) that will be useful for each of the chosen enterprises and Implement the 2 enterprise relational DBs using either MySQL or SQLite

  Timetabling system - write an sql function

With the new UNSW timetabling system, the LIC of each course is required to specify what facilities they require in their classrooms as one of the inputs to the timetabling process. Write an SQL function to provide a list of rooms that contain a g..

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