Preview

Dbm 380 Week 1

Powerful Essays
Open Document
Open Document
1191 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Dbm 380 Week 1
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 …show more content…
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 database designer job to get the responses he/she will need to determine why the database system is not functioning properly. Listed below are some of the problems and constraints that could be possible while trying to plan and complete this
Continue Reading
View Writing Issues

You May Also Find These Documents Helpful

  • Better Essays

    Proposal for Kudler Fine Foods
    • 2384 Words
    • 10 Pages

    Proposal for Kudler Fine Foods

    Our team was charged with the task of selecting a small business for which to implement database forms and reports requirements. We selected an upscale specialty food store located in the San Diego metropolitan area, named Kudler Fine Foods, as our business model. As do many organizations, Kudler utilizes a database system to improve their operational environment. However, they were still manually creating their forms and reports. Each store location uses standardized paper forms, which are then mailed or faxed to the main office to be entered into the database. The inventory system and forecasting for future purchases are done via extrapolations and working knowledge of the company, rather than queried data from their database system. Once we researched the company and gathered all of the necessary data, we were able to determine what type of forms and reports were needed.…

    • 2384 Words
    • 10 Pages
    Better Essays
    Read More
  • Good Essays

    DBM380 Week 2
    • 837 Words
    • 3 Pages

    DBM380 Week 2

    The database environment refers to the type of configuration used to populate and create the application. A database includes items such as text, images and graphics associated with a record. The main purpose of a database is to collect and organize that data. The environment to be designed is one to store and retrieve data in a way it can be easily organized. For the purpose of this assignment the database environment will be a series of tables which store customer, sales order, purchase order and various status point information. This data will then be used for a series of reports to demonstrate status of the purchase order as it flows through the system. The overall goal is to be able to provide the customer an accurate status of their purchase order that is submitted electronically.…

    • 837 Words
    • 3 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    DBM 380 Week 4 Individual Paper Normalization of the ERD
    • 644 Words
    • 4 Pages

    DBM 380 Week 4 Individual Paper Normalization of the ERD

    Summarize your paper by describing the database systems in your workplace, identifying which database systems and architecture they fall under.…

    • 644 Words
    • 4 Pages
    Satisfactory Essays
    Read More
  • Good Essays

    CMGT 400 Week 1 DQs
    • 676 Words
    • 3 Pages

    CMGT 400 Week 1 DQs

    The project for CIS336 is designed to touch all aspects of the fundamental concepts of database design and logical data modeling covered during the class. The project is team centered and each team will be responsible for designing, developing, and demonstrating the functionality of a database created based on a defined set of business specifications. At the end of the session, each project team will submit the database designed by the team and demonstrate the database's ability to deliver the required information as outlined in the project specifications. All aspects of the project will be ...…

    • 676 Words
    • 3 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    MIS581 Course Project Milestone 1 and 2
    • 782 Words
    • 5 Pages

    MIS581 Course Project Milestone 1 and 2

    New database must be designed to store work records. Integrate and redesign current client data to the new database. After the new system is implemented, clients will be able to submit service requests, consultants can have access to all client information and remotely access client information.…

    • 782 Words
    • 5 Pages
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    Learning Team Project Charter
    • 667 Words
    • 3 Pages

    Learning Team Project Charter

    This project will upgrade the company’s database system within Human Resources. All database information will now be stored on the new database server that will be installed at the main headquarters. The database servers that are already installed at each local site will be reconfigured to send and receive updates to the main server so that all database servers are mirrored. Hard disk drive space will be upgraded to account for database growth at each location. Employees that require access to this database will need approval from the Human Resources department to protect employee information. This project will not update the actual database software but will reconfigure the software to be accessible across the company network as well as combine all database information into one large database. A new task of nightly backups will be initiated at the main headquarters once the new database setup is completed.…

    • 667 Words
    • 3 Pages
    Satisfactory Essays
    Read More
  • Good Essays

    Cis 515week 3
    • 1024 Words
    • 4 Pages

    Cis 515week 3

    Bibliography: (2012). Database systems: Design, implementation, and management. (10 ed.). United States of America: Joe Sabatino.…

    • 1024 Words
    • 4 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    DBM 380 Week 1 DQ 1
    • 411 Words
    • 2 Pages

    DBM 380 Week 1 DQ 1

    This paperwork of DBM 380 Week 1 Discussion Question 1 comprises: Using the Ghanem (2010) article as a guide, what are the benefits of using Views in a database?…

    • 411 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    Database Normalization and Service Request Sr-ta-001
    • 329 Words
    • 2 Pages

    Database Normalization and Service Request Sr-ta-001

    This memo is to inform you that your service request SR-ta-001 has reached my desk and currently is in the process of being completed. The purpose of this memo is to report the progress on the service requests. Currently I am in the stage of normalizing the database to the third normal form. By normalizing the database to the third level of normalization I will ensure that the data is efficiently organized within the database by removing duplicate and redundant data from the database relations. Normalizing the data to the normal third will help free up space and make it easier for the users to retrieve the data by elimination of the same data stored in more than one relation. In addition, normalizing to this level will also ensure data integrity, scalability, and storage efficiency. I have made sure that that there are no repeating columns or rows within the same tables and each column has only one value and one data type therefore the level of 1 normalization has been completed. I then continued to normalize the database to the second level of normalization by ensuring that each nonkey attribute is fully dependent on the key columns of the table. Once level one and two normal form had been completed I continued by establishing primary and foreign keys along with relationships. I will keep in contact with you as the project nears completion.…

    • 329 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Good Essays

    Acme Global Consulting
    • 678 Words
    • 3 Pages

    Acme Global Consulting

    Hello sirs, my name is , I am forwarding this correspondence to give you options pertaining to your database management system or DBMS. One of these options is to install an Entity Relationship Model or E-R model DBMS, the reason I am suggesting an E-R model is there are a number of advantages to installing and managing this type of DBMS in your company. I will provide you with information on the advantages of them in this proposal.…

    • 678 Words
    • 3 Pages
    Good Essays
    Read More
  • Better Essays

    Dbm 381 Week 1 Individual
    • 971 Words
    • 4 Pages

    Dbm 381 Week 1 Individual

    Examination of the types of database systems that are available and how health care facilities utilize these different types of databases is the topic of this report. Giving more detail on the different types of architecture of databases and data structure will follow.…

    • 971 Words
    • 4 Pages
    Better Essays
    Read More
  • Better Essays

    Week 2 Individual
    • 852 Words
    • 3 Pages

    Week 2 Individual

    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…

    • 852 Words
    • 3 Pages
    Better Essays
    Read More
  • Good Essays

    Dbm 381 Week 1paper
    • 885 Words
    • 4 Pages

    Dbm 381 Week 1paper

    A database is a structure that can store information about multiple types of entities, the attributes of those entities, and the relationships between the entities (Pratt & Adamski, 2012, Chapter 1). How data is received, stored, processed, and made available to others has an effect on the success or failure of an organization. The use of different architecture is a most to fit the needs of the organization, however the value of the data still remains in been able to access and extract information from the database system, and the only way this can be reached is by organizing, storing, and analyzing it effectively. For many organizations these systems have become an essential part of their structural and operational success.…

    • 885 Words
    • 4 Pages
    Good Essays
    Read More
  • Good Essays

    Assignment 1 Business Rules and Data Models
    • 906 Words
    • 3 Pages

    Assignment 1 Business Rules and Data Models

    References: Coronel, C., Morris, S., & Rob, P. (2013). Database systems: Design, implementation, and management (10th ed.). Independence, KY: Cengage.…

    • 906 Words
    • 3 Pages
    Good Essays
    Read More
  • Good Essays

    Information Use
    • 777 Words
    • 4 Pages

    Information Use

    The database we worked on was a system called Salesforce; this system enabled us to keep track of the calls we had to make and document all details of that call. It contained all of the information we needed to accomplish this task, it held clients pertinent data, the banks that we dealt with and a method to track the goals we had to accomplish each week. This system was also an ERM (electronic records management database) we had the ability to scan and upload pertinent client information such as three months of bank statements, paystubs, and hardship letters, foreclosure notices and current mortgage statements. It was very user friendly and had the ability to be modified towards the needs of…

    • 777 Words
    • 4 Pages
    Good Essays
    Read More

Related Topics