User Account

All Pages

Database design and management

Assignment Help Business Management
Reference no: EM131536142

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 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 planning a new employee payroll database and has asked you for assistance. The database will be standalone but will need to have 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 cost 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!!

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.

Reference no: EM131536142

Questions Cloud

Develop project charter : Create a 1- to 2 page input to the "Develop Project Charter" process (see PMBOK® Guide, Section 4.1.1). Remember to focus on the input and not the output.
Develop a procurement communications plan : Develop a procurement communications plan for the case study that you selected for the final project.
Do gaap control and dictate managerial accounting : Which type of cost behavior increases total costs when volume of activity increases?
Why do people implement database indexes : Why do people implement database indexes? Why not just allow a super fast computer to do a linear search on whatever information they want?
Database design and management : You are a data analyst with strong backgrounds in database design and management. In fact, you have learned from education, mentors, and experience.
Compute and interpret manufacturing cycle time : What are the three types of inventory on a manufacturing company's balance sheet?
Distinguish between managerial and financial accounting : How are both beginning and ending goods in process inventories reported on a manufacturing statement?
Briefly describe the two specific systemic crises : Briefly describe the two specific systemic crises you have selected. Describe similarities and differences between these two sets of intervention strategies
Charge of public relations : Imagine that you have been put in charge of public relations (including social media) for your company, Happy Times Bounce Houses.

Reviews

Write a Review

Business Management Questions & Answers

  Prepare a mission or vision statement for your organization

Create a mission or vision statement for your organization. Describe the kind of entity you plan to establish by stating the service or services you propose to deliver and the kinds of clients or customers you would be serving.

  Explain how would a corporation attract you enough to cause

explain how would a corporation attract you enough to cause you to leave your current (or past) employer and join them? As an employer, given which compensation.

  Inflation affect the nominal exchange rate

1. Suppose that reduced barriers to international financial transactions cause an increase in the economy's supply of capital. Explain, step-by-step, how the economy adjusts to arrive at a new long-run equilibrium.

  Vice president of operations

You are the Vice President of Operations for a retail clothing store chain with stores located in five Southeastern States and three providences in Canada. Profits have been declining for the past five years.

  Why different planning important to strategy of organization

Explain why the 3 types of goals are important to the strategy of an organization. Explain why the different types of planning are important to the strategy of an organization.

  Discount machine price at annual rate

A local store has washing machine on sale for $1285 with payment due 3 years from today. Store is willing to discount machine price at annual rate of 7% compounded annually if you buy today. What would you pay today?

  Discuss how an organisational culture can formed

Essay - Organisational culture is an important driver of the success of a business. Discuss how an organisational culture can formed

  What are sources of strength for an analytics competitor

How can a company become and prosper as an analytics competitor and what are the sources of strength for an analytics competitor?

  What is the companys net working capital

Winston Electronics reported the following information at its annual meetings. The company had cash and marketable securities worth $1,235,570, accounts payables worth $4,160,630, inventory of $7,122,150, accounts receivables of $3,488,860, notes pay..

  Define the corporate culture of the organization

Define the corporate culture of the organization and their position on Corporate Social Responsibility

  Relavant costswhich of the following costs would be

relavant costswhich of the following costs would be relevant in short-term decision making?a. incremental fixed costsb.

  What is your leadership style

How Implicit Personality Affects Leadership? Personality and How It Relates to Leadership. What Is Your Leadership Style? How Personality Plays into Leadership? Emotional Intelligence and Leadership. What is emotional intelligence?

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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