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

  Show the 3- schema architecture for the requirement

Suitable data that suits your requirement and design and explain the 3- schema architecture for the requirement.

  Define the importance of various system analysis

By now you should have a "toolbox" full of useful design and analysis tools. List the tools in your toolbox and then write one short paragraph on how you can/will apply them in your careers, lives, etc.

  Find all non-trivial dependencies

Compute the closure sets of R, find all non-trivial dependencies and what are the candidate keys of R?

  Create database of measured meteorological data

You are creating a database of measured meteorological data for use in weather and climate research. Explain a structure type measured_data_t with components site_id_num.

  What was the total value of the disputed order

Write SQL SELECT statements to retrieve the following information from the ClassicModels database - select the product name, scale, vendor and product code for all models of classic cars built between 1948 and 1966. Display the results in order of..

  Create a table for patients with information

Create a table (by your own imagination) which comprises the least 25 patients with next information (columns): Calculate average of Value1 for each Gender.

  Prepare table which is in first normal form

Prepare the example of table which is in first normal form but not in second normal form and example of a table which is in second normal form but not in third normal form.

  Oracle having multiple group functions in same select list

Can Oracle have multiple group functions in the same SELECT list of query (i.e can we do a COUNT and AVG)? Let us assume we wanted to find lowest, highest, average.

  Apply and consolidate skills acquired in the requirement

Develop a domain model for the car park system. Express your model with a class diagram, showing any inheritance and compositional relationships.

  Create a database design specification

Create a database design specification (Enhanced Entity Relationship Diagram (EERD) and Relational Data Model (RDM)) from the given business description. The RDM must be in 3rd Normal Form.

  What is the total i/o cost for sorting this file

How many sorted subfiles will there be after the initial pass of the sort, and how long will each subfile be?

  Explain the security mechanisms available for a database

Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.

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