Question: You are a data analyst with strong a background in database design and management. In fact, you have learned from education, mentors, and experience the

You are a data analyst with strong a background in database design and management. In fact, you have learned from education, mentors, and experience the art of collecting data and transforming data into business intelligence and your experience in database design and management complements your abilities to analyze data.

Your hypothetical employer, Park University, is in the process of planning a new employee payroll database and has asked you for assistance. The database will be standalone but will need to have the ability to communicate with other ODBC and SQL Server databases. The overall purpose of the database will be to input employee data for 100-150 employees. The database will need to input time and process data needed to document payroll and to create payroll checks.

Park University at this point needs to understand and review options so that costs to develop and maintain this payroll database are kept at a minimum but without compromising security. Park University has requested information and has asked you to address the following questions:

Would a full-scale Database Management System (DBMS) or Relational Database Management Systems (RDBMS) be required in this case? Discuss and defend your answer in scholarly detail!!

Could Microsoft Access be a good option in this case? Discuss and defend your answer in scholarly detail and all teams are welcome to recommend any SQL-driven database!!

Could even Microsoft Excel be used in this case maybe as a secondary database support application for further data analysis and statistical models? Discuss and defend your answer in scholarly detail!!

What Systems Development Life Cycle methodology would you suggest in this case for the overall planning, design, implementation, and maintenance of this database? Discuss and defend your answer in scholarly detail!!

What else might you need to cover to help Park University determine what type of database to consider for the new payroll database?

Include any other important conclusions or content you see fit to support this assignment.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

You are a data analyst with strong backgrounds in database design and management. In fact, you have learned from education, mentors, and experience the art of collecting data and transforming data...

GUGGI'S SALES ASSOCIATES You are Guggi's new recruiters. You are required to evaluate the candidates and make the final hiring decision The information to fulfill this assignment includes: . General...

IMA EDUCATIONAL Case Journal Case Study A Tale of Missing...Parts Nit/201a; J. Fess/er, CMA, CPA T lie University of Texas at ller INTRODUCTION Unlike other examples of unethical behavior you might...

Assessment Task A You are required to coordinate the recruitment, selection and induction for each of the following recruitments: Casual, contract or temporary Full time or part-time permanent...

Educating Managers from an Evidence-Based Perspective Author(s): Denise M. Rousseau and Sharon Mccarthy Source: Academy of Management Learning & Education, Vol. 6, No. 1 (Mar., 2007), pp. 84101...

Information Security Risk Management ITC6315 Assignment 2 Assignment For this exercise, read the provided case study about AcmeHealth, and rate the risk exposure for each finding related to the...

Please help me make an Executive Summary. Explain what you will examine in the case study. Write an overview of the field you are researching. Make a thesis statement and sum up the results of your...

7.0: Organizational Strategy Overview (one paragraph describing the following charts) 7.1:CurrentOrganizationalStructure(chart)...

RUNNING HEAD: MARKETING IS ART OR SCIENCE? 1 MARKETING IS ART OR SCIENCE? STUDENT'S NAME STUDENT'S COLLEGE MARKETING IS ART OR SCIENCE? 2 EXAM QUESTION Answer all parts of the question and submit all...

Rochester Electro Medical Inc. is a manufacturing company based in Tampa, Florida, that produces medical products. Management had the business objective of improving the safety of the workplace and...

Nice-n-Fresh Drycleaning showed the following information for its first and second months just ended, March and April of 2014: *Ed Fresh made a $10,000 investment during March and had withdrawals of...

Second - mortgage lending by banks increased when / as: Group of answer choices the FHA provided incentives. deduction of interest was eliminated. first mortgage lending became too risky. HELOC...

Create a C# application named SalesTransactionDemo that declares several SalesTransaction objects and displays their values and their sum. The SalesTransaction class contains the following fields:...