Database Environment Paper 12 15 2014

Topics: Database management system, SQL, Database Pages: 7 (1221 words) Published: February 3, 2015


Database Environment Paper
Victoria A. Provencal
Database Concepts/DBM-380
Monday, December 15, 2014
Instructor: William McKown

Database Environment Paper
Database environments are very important in today’s industries. In selecting an organization that will need a database, I choose Smith Consulting. Smith Consulting will need a database to track their consulting staff, each staff member’s skill sets, and what projects they will be working on. This document will provide information on the following area’s listed below: I. Analyze the Database Environment

II. Describe the Problems and Constraints
III. Describe the Objectives of the Database Environment
IV. Describe the Scope and Boundaries
V. List the Data Specifications
Smith Consulting is an organization that was structured in 1984 by Blair Smith in Houston Texas. This organization provides IT services to clients located in the Western United States from their headquarters located in Houston, Texas. Smith consulting originally started with a group of five, however over the years, have grown, and currently have 350 employees, generating about $45 million in revenue. Smith Consulting currently supports four clients: Kudler Fine Foods, Riordan Manufacturing, and McBride Financial Services. ("eCampus: Login", n.d.) With the level of clientele that Smith Consulting provides services too, they also have consulting staff that also works for them. Smith Consulting will definitely need a functional database in order keep track of their consultant’s information. As you continue to read this document, the following area’s listed above will be answered to provide you with the information needed to help create a functional database for Smith Consulting.

I. Analyzing the Database Environment
Before you can start to create and build a database, you will need to analyze the database environment that you will be creating your database in. The purpose of analyzing the environment is to establish the nature and use of the data. Also, additional information will be provided to show where the organization currently stands and the type of situation the company is currently in based on this analysis. It is extremely important to find out if the current system is not doing well and the reasons for why it is not performing to the standards. will Currently for Smith Consulting, it appears that the current database will not allow new information and need to be updated in order to keep track of their consulting staff, their skill set, and the projects they are working on. In order for this analysis to be successful, the database designer and the users will need to speak frequently in order for this project to be successful. The database designed will need to collect as much information as possible in order to decide the types of entities and attributes will be needed for Smith Consulting. ("Database Analysis", n.d.) The Nature and Use of data as mentioned above, involves the identification of the elements that will be needed in order to support the data processing system of Smith Consulting and using these elements as logical groups and defining the relationships between the groups. Basically, database analysis is a structure based methodology. ("Database Analysis", n.d.) II. Describe the Problems and Constraints

The problems and constraints for this project for Smith Consulting will be determined by the database designer, during the conversations with the hierarchy and the users. When the conversations are taking place, it is very important for the designed to obtain and identify the problems by collecting as much information as possible from the hierarchy and the end users. Without this information, it will be very difficult for the designer to complete this project. It is only natural for the designer and hierarchy to have different views on what they may feel are the problems, however they must come to some agreement and ultimately it is the...

References: eCampus: Login. (n.d.). Retrieved November 14, 2014, from https://ecampus.phoenix.edu/secure/aapd/cist/vop/Business/Smith/internet/index.asp
Database Analysis. (n.d.). Retrieved November 14, 2014, from http://db.grussell.org/section004.html
Database Constraints at Database Tutorial. (n.d.). Retrieved November 14, 2014, from http://michaelmclaughlin.info/db1/lesson-2-creating-tables/database-constraints/
Database Administration: Creating the Database Environment | Defining the Organization 's DBMS Strategy | InformIT. (n.d.). Retrieved November 14, 2014, from http://www.informit.com/articles/article.aspx?p=1963781
Define System Scope and Boundaries. (n.d.). Retrieved November 14, 2014, from http://www.testablerequirements.com/testablerequirements/def_sys_scope_bound.htm
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • Database Environment Paper
  • Database Environment Paper
  • Database Environment Paper
  • Database Environment Essay
  • Database Environment Essay
  • DATABASE PAPER
  • Database Design Paper
  • Essay on Database Environment

Become a StudyMode Member

Sign Up - It's Free