Week 2 Individual
Week 2 Individual
Database Environment Paper
DBM/380
May 26, 2014
Sandra Graca
DATABASE ENVIRONMENT FOR SMITH CONSULTING
ANALYSIS OF THE DATABASE ENVIRONMENT: To create a database environment for Smith Consulting so they can track their consulting staff, each staff’s member skill sets, and what projects they are working on, they require the installation of a databases setup such as, Microsoft SQL Server, DB2, or Sybase in their machines as well as a separate server room for the database to maintain the connections and servers. To handle this database environment, the Smith Consulting also requires database administrators for each database who can maintain the database at every situation and make it easily accessible to the users who are working on it. (Verdiem Corporation, 2014) This is a kind of decision making process is one in which the management needs to decide which server they need to install so that they achieve the above mentioned goals within the organization. Let’s assume the management installed the Oracle database environment in their machines as well as in the separate database room. Now it is responsibility of the database administrator to properly handle the database environment so it is mostly recommended by all of the DBA’s to install the database server at a remote location which makes it less likely to be hacked and adds stability while using it. Another important role of the DBA is to have proper access to the database and based on the requirements and specifications to assign the permissions for the database to the management such as read, write and execute permissions. This will create the scenario of giving write permissions to the HR department which normally handles the new and old employees staffing. Now the HR department will update about the staff’s projects which means, which employees are allocated to which project and which employees are yet allocated to any projects. Write permissions are also given to the managers of every
Database Environment Paper
DBM/380
May 26, 2014
Sandra Graca
DATABASE ENVIRONMENT FOR SMITH CONSULTING
ANALYSIS OF THE DATABASE ENVIRONMENT: To create a database environment for Smith Consulting so they can track their consulting staff, each staff’s member skill sets, and what projects they are working on, they require the installation of a databases setup such as, Microsoft SQL Server, DB2, or Sybase in their machines as well as a separate server room for the database to maintain the connections and servers. To handle this database environment, the Smith Consulting also requires database administrators for each database who can maintain the database at every situation and make it easily accessible to the users who are working on it. (Verdiem Corporation, 2014) This is a kind of decision making process is one in which the management needs to decide which server they need to install so that they achieve the above mentioned goals within the organization. Let’s assume the management installed the Oracle database environment in their machines as well as in the separate database room. Now it is responsibility of the database administrator to properly handle the database environment so it is mostly recommended by all of the DBA’s to install the database server at a remote location which makes it less likely to be hacked and adds stability while using it. Another important role of the DBA is to have proper access to the database and based on the requirements and specifications to assign the permissions for the database to the management such as read, write and execute permissions. This will create the scenario of giving write permissions to the HR department which normally handles the new and old employees staffing. Now the HR department will update about the staff’s projects which means, which employees are allocated to which project and which employees are yet allocated to any projects. Write permissions are also given to the managers of every
References: Verdiem Corporation. (2014). Setting Up The Database Environment. Retrieved from http://www.verdiem.com/kb/setting-database-environment Larsen, G. A. (2010). MS SQL. Retrieved from http://www.databasejournal.com/features/mssql/article.php/3906986/Top-10-Mistakes-When-Building-and-Maintaining-a-Database.htm Mullins, C. S. (2012). Database Administration: Creating the Database Environment. Retrieved from http://www.informit.com/articles/article.aspx?p=1963781 IST, UC Berkeley. (2007-2011). Database Environments, Permissions & Change Management. Retrieved from http://ist.berkeley.edu/is/database/services/environments