IT Concepts Major Assignment
A tax accounting firm has been using Microsoft Access as a database to track their customers and their details for over 20 years. Realising that it is time for an upgrade, they've asked you to make a series of recommendations relating to security, operating systems and choice of database. Importantly, they are not asking you to develop any software or create the database - only to make some recommendations so that they know how to proceed.
They will need you to:
1. Recommend a database. Your two main choices are MySQL or PostgreSQL, but you can make a different recommendation if you prefer. As they are currently using Access, the client has already determined that it no longer meets their needs, so it is not an option. You will need to explain why you have made this choice and compare that choice to one other database. Important: we have not covered databases in this course, so we don't expect you to have a lot of detail on your decision, but you will need to do some research into which is a better option for a small business.
2. Recommend and justify an operating system for their new server. This will be dependent on OS features and its compatibility to the database you have recommended. Generally the choice here will be between Windows and Linux, but other operating systems - such as the Mac OSX - are an option if you want to take that path.
3. Make some recommendations as to how best to handle and security and manage their backups.
4. Recommend a process by which they can manage the transfer of data from their existing system to the new system once installed.
In addition, for testing purposes they will need to get this to run on a virtual machine, so you will need to provide some (basic) instructions as to how to set up and configure the VM to handle the new software.
Format your assignment according to the following formatting requirements:
1. The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
2. The response also includes a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
3. Also include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.