Preview

Database Normalization and Service Request Sr-ta-001

Satisfactory Essays
Open Document
Open Document
329 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Database Normalization and Service Request Sr-ta-001
Service Request Memo Normalization
Cynthia Erney
Database Concepts DBM/381
August 21, 2012
Nongxin Rao, PhD

To: the Technical Services/Logistics Manager at Taylor Ambulance
RE: Service Request SR-ta-001 Scheduling System Database
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.
Sincerely,
Cynthia K Erney

employees who will use the new database some extensive seminars, or other form of training to ensure that users have the knowledge on how the system will work. This will decrease redundancy and decrease data entry errors. I look forward to hearing from you regarding your thoughts, and concerns, with the database.
Sincerely,
Cynthia
Continue Reading
View Writing Issues

You May Also Find These Documents Helpful

  • Satisfactory Essays

    PT2520 Week 3 Forum
    • 190 Words
    • 1 Page

    PT2520 Week 3 Forum

    Normalization process you and will need to examine a business application. In this case you need to explore the simplified database activities of a company that manages several building projects each project has its own project number, names of employees assigned to it and so on. Each employee has an employee number, name and job classification such as engineer or computer technician.…

    • 190 Words
    • 1 Page
    Satisfactory 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
  • Good Essays

    Nt1320 Unit 7
    • 2041 Words
    • 9 Pages

    Nt1320 Unit 7

    The database design team transforms entities into tables and expresses relationships by defining foreign keys. The tables in the model are to be normalized before converting them into designs. Normalization is the process of converting poorly structured tables into two or more well-structured tables. Database practitioners classify tables into various normal forms according to the kinds of problems they have. Transforming a table into a normal form to remove duplicated data and other problems is called normalizing the table. After normalizing, the designer should represent the relationship among those tables to complete the design.…

    • 2041 Words
    • 9 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    Memo Week 3 Dbm 381
    • 329 Words
    • 2 Pages

    Memo Week 3 Dbm 381

    This memorandum is created to explain normalization, its level and why it is sufficient for the system. We are all aware that Microsoft Access database is the best fit for the Taylor Ambulance Company. This database will be efficient in storing, tracking and billing incidents. To reduce redundancy in the system, it is important to apply normalization. Normalization is the processes where data are organize in a database. This process includes creating tables and establishing keys and relationships of data between the tables. Normalization will also make the database more flexible, in which redundancy will be reduced and possibly completely eliminate. This will also reduce inconsistence dependency. It will also be faster to create queries between tables after the data is normalize. A non-normalize database is full of redundant data and it is unorganized.…

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

    Team A Service Request WK4 V2
    • 752 Words
    • 3 Pages

    Team A Service Request WK4 V2

    The database normalization is a technique that is used to organize the contents in the tables for transactional databases and also data warehouses. The normalization is a portion of designing the database with success, without this the database systems may be inaccurate, inefficient, slow, and they may not create the data that is expected. Following a SQL Server installation that is successful a database will need to be created that will hold the data. After the database framework has been created, the files must be organized in a way that can be easily managed. The primary tool that will help organize the data will be the table that will look like a two-dimensional structure that encompasses rows and columns. When the database is normalized there will be four goals to maintain. These goals will be to organize data in logical groupings that each group will describe a small part of the whole; lessening the amount of duplicated data that is saved in the database; organize the data that so that when it is modified the change can be made in only one place; also building a database where the data can be accessed and manipulated quickly, efficiently, and without compromising the integrity of the data that is stored.…

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

    Logical Design Pt. 2
    • 641 Words
    • 3 Pages

    Logical Design Pt. 2

    Hello sirs, my name is , it has come to my attention that there are some misconceptions about the value in normalizing your database. I wanted to write this correspondence to address any concerns that you may have about flexibility while entering your data into the system. This letter is to assure you and the other members of your executive board that you will have some flexibility within your E-R Model.…

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

    Potential constraints on my logical data model
    • 373 Words
    • 2 Pages

    Potential constraints on my logical data model

    The database needs to be adjusted so that the client can adapt to it and use it correctly, for this to happen the database needs to be designed around the client’s knowledge and skill…

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

    Tour Operator Agency Database.
    • 706 Words
    • 3 Pages

    Tour Operator Agency Database.

    Imagine that you have been hired to fulfill their need of enhancing the data repository for their current reservation processing system. Upon reviewing the system, you find that the data structure holds redundant data and that this structure lacks normalization. The database has the following characteristics:…

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

    Notes on Oracle Dba
    • 72273 Words
    • 290 Pages

    Notes on Oracle Dba

    Oracle Database 2 Day DBA, 10g Release 2 (10.2) B14196-03 Copyright © 2004, 2012, Oracle and/or its affiliates. All rights reserved. Primary Author: Colin McGregor Contributing Author: Sushil Kumar, Antonio Romero, David Austin, Steve Fogel, Lance Ashdown, and Douglas Williams Contributor: Michele Cyran, Daniela Hansell, Vasudha Krishnaswamy, Peter Laquerre, Venkat Maddali, Mughees Minhas, JP Polk, Mark Townsend, and Wanli Yang This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited. The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing. If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, the following notice is applicable: U.S. GOVERNMENT RIGHTS Programs, software, databases, and related documentation and technical data delivered to U.S. Government customers are "commercial computer software" or "commercial technical data" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, duplication, disclosure, modification, and adaptation shall be subject to the restrictions and license terms set forth in the applicable Government contract, and, to the extent applicable by the terms of the Government contract, the additional rights set forth in…

    • 72273 Words
    • 290 Pages
    Better Essays
    Read More
  • Good Essays

    Computer Forurm
    • 10092 Words
    • 41 Pages

    Computer Forurm

    Why are some table structures considered to be bad and others good and how do you recognize the difference between good and bad structures?…

    • 10092 Words
    • 41 Pages
    Good Essays
    Read More
  • Good Essays

    Normalization Process
    • 1486 Words
    • 6 Pages

    Normalization Process

    Normalization is a process of reducing redundancies of data in a database. Normalization is a technique that is used when designing and redesigning a database. Normalization is a process or set of guidelines used to optimally design a database to reduce redundant data. The actual guidelines of normalization, called normal forms, will be discussed later in this hour. It was a difficult decision to decide whether to cover normalization in this book because of the complexity involved in understanding the rules of the normal forms this early on in your SQL journey. However, normalization is an important process that, if understood, will increase your understanding of SQL. We have attempted to simplify the process of normalization as much as possible in this hour. At this point, don't be overly concerned with all the specifics of normalization; it is most important to understand the basic concepts.…

    • 1486 Words
    • 6 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    Normalization of Database Management Systems
    • 989 Words
    • 4 Pages

    Normalization of Database Management Systems

    * The company charges its clients by billing the hours spent on each project. The hourly billing rate is dependent on the employee’s position.…

    • 989 Words
    • 4 Pages
    Satisfactory Essays
    Read More
  • Powerful Essays

    Online National Polling Software Requirements Specification
    • 4503 Words
    • 19 Pages

    Online National Polling Software Requirements Specification

    Survey:.......................................................9 2.9) Architecture diagram..........................................................11 2.10) Database design: ..............................................................11 2.11) Assumptions and Dependencies: ..................................... 14 3) Specific Requirements:........................................................................ 14 3.1)Use CaseReports:................................................................... 14…

    • 4503 Words
    • 19 Pages
    Powerful Essays
    Read More
  • Powerful Essays

    Ddi Assignment
    • 1279 Words
    • 6 Pages

    Ddi Assignment

    RentalOrder (OrderID, OrderDate, ExpReturnDate, ActReturnDate, CustID, EID, TotalDay, FirstCharge, AfterFirstCharge, SubTotalCharge, VATCharge, FinalCharge, ServiceID) /*CustID referencing Customer.CustID*/ /*EID referencing Equipment.EID*/ /*ServiceID referencing ServiceOrder.ServiceID*/…

    • 1279 Words
    • 6 Pages
    Powerful Essays
    Read More
  • Satisfactory Essays

    Normalizaiton in Database
    • 1773 Words
    • 8 Pages

    Normalizaiton in Database

    EMPLOYEE (EMP_NUM, EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_HIREDATE, JOB_CODE) JOB (JOB_CODE, JOB_DESCRIPTION, JOB_CHG_HOUR) ASSIGN (ASSIGN_NUM, ASSIGN_DATE, PROJ_NUM, EMP_NUM, ASSIGN_HOURS) Figure 5.10 The Relational Schema for the Contracting Company Summary A Journey of Normalization Introduction to Normalization of Database Tables First Normal Form (1NF)…

    • 1773 Words
    • 8 Pages
    Satisfactory Essays
    Read More