Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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, ABC 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.

ABC 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. ABC 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!!

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advanced Database Systems

Authors: Carlo Zaniolo, Stefano Ceri, Christos Faloutsos, Richard T. Snodgrass, V.S. Subrahmanian, Roberto Zicari

1st Edition

155860443X, 978-1558604438

More Books

Students also viewed these Databases questions

Question

using signal flow graph

Answered: 1 week ago