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.