This is the supporting document. The Access Database will be available for you after the case has been approved. In today’s world, databases are necessary to have in reference to business or running a company. There is so much information being stored, processed, and transferred that it would be impossible not to have a form of database these days. A database allows an organization to have true command of their data. This accommodates easy retrieval, sorting, analyzing, summarizing and queried results in minutes.
A database can combine data from multiple locations. Having a database provide the comfort of knowing the data is easily accessible and accurate The definition of a database is defined as Systematically organized or structured repository of indexed information (usually as a group of linked data) that allows easy retrieval, updating, analysis, and output of data. Stored usually in a computer, this data could be in the form of graphics, reports, scripts, tables, text, etc., representing almost every kind of information. Most computer applications fall under this group including antivirus software, spreadsheets, and word processors (Business Dictionary 2013). A database that is used in my work environment is Microsoft SQL Server.
Microsoft SQL server is a database management and analysis system for e-commerce, line of business, and data warehousing solutions (Microsoft 2013). SQL stands for Structured Queried Language. SQL is used to request information from the database. Without adatabase, it would be hard to retrieve information, to guarantee its accuracy. The process of the analysis and out would be difficult without the SQL database to assist in this process. To run an effective business or entity, organization is key. This is what SQL brings to the table. Data is a very important part of society today, especially when dealing in business. In my place of work we utilize MicrosoftSQL databases along with other databases. I could not imagine not having this database to conduct day-to-day activities. There is so much information that is processed on a daily basis and many other application and servers that rely on this database.
Not having the Microsoft SQL server would not detrimental to daily activity. Although there are other databases utilized as stated earlier, this database is equally important to conduct business. Any company, business, or organization that is not utilizing some form of a database is doing their entity a great disservice by utilizing this technology.
In order to install Microsoft SQL database, one must have a server to use. One must first start by purchasing the license from Microsoft to obtain the software. If you are installing Microsoft 2012, you must have a 2012 server. If you are installing an older version of the SQL, an older Microsoft server is ok to use. According to Microsoft, it is much easier to install a new MSQL server rather than having to integrate it with existing applications. When integrating it with existing applications one must prepare the MSQL to accept the existing applications. Some issues that someone installing this application run into are; some of the existing applications my conflict with the MSQL. When this occurs, hours of troubling with ensue in order to synchronize the existing applications with the new MSQL.
The final step in the installation of the MSQL is to install the security patches must be installing to ensure the server is secure. For the MSQL 2012 this will be Service pack 1 (SP1), this will ensure the best and up today security (Microsoft 2012). Once this MSQL is up and running the work environment will run much better. In my place of work, this is the case with the utilization of MSQL. MSQL provides a central location of processed data. This keeps the data in order. The engineers that maintain the database in my office are able to access MSQL to retrieve needed information from multiple applications. They are also able to trouble some issues from this database in certain instances. In other cases, the engineers must access that particular application through other means.
In conclusion, the uses of databases are very important in reference to running a business or entity. With the data that is needed in today’s world, there would be no other way to maintain all the data. The use of databases has changed the way business is conducted. In the case of MSSQL is makes the process of running an office more effectively. This makes the job easier for the employees, managers and company owners. If a company does not use some form of a database they are definitely behind the power curve.
Reference
Database management and creation. Retrieved from: http://http://www.w3schools.com/sql/sql_insert.asp
How to work with msql server. Retrieved from
http://www.wikihow.com/Draw-E-R-Diagram-Using-MySQL-Database-Engine
Creating a table in a database using msql server. Retrieved from:
http://www.cyberciti.biz/faq/howto-linux-unix-creating-database-and-table/