Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started