Preview

Normalization of the Erd

Good Essays
Open Document
Open Document
857 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Normalization of the Erd
Normalization of the ERD
By: Vanessa Kennedy

Normalization of the ERD The normalization of the ERD along with the driver’s log is taking all of the data within the database and putting the information into tables (World Book, 2011). In addition, after the data is normalized it then is put into an Entity Relationship Diagram or ERD (World Book, 2011). In this paper we will look at the ERD of the driver’s log. The normalization that I would perform on the driver’s log would be on the Driver’s Table. In this table I would have set it up to have an additional table for the Name, Employee ID Number, and Date of the Last Physical Examination, Date of Last Annual Drug Test, and the Date of the Last Random Drug Test. The information that is listed here is only needed if a problem should occur with the driver. The normalization that I would perform on the Driver’s Log Table is listed as follows; the first step is to create a table that contains the Content’s Name, Employee ID Number, Date (month, day, and year), Tractors ID Number, Trailer 1 ID Number, Trailer 2 ID Number, and Trailer 3 ID Number. This would be the first table of the ERD. The reason why I would make this table is because I believe this is more for record keeping. With that being said by using this table it helps keep track of which driver has which tractor and trailer. Next there would be a second table created. In this table it would contain the following information; the table would have information such as Name, Employee ID Number, Date, Co-Driver name and Co-Driver Employee ID Number. The information on this table is a quick reference. The quick reference table will allow an individual to see who is working with each employee. Next there would be a third table created. The third table would contain the following information; Name, Employee ID Number, Off Duty Start and Stop Time, and the total of the Off Duty Hours. This table would be used to keep track of the off duty hours. This table



References: World Book Encyclopedia. U. A. (2011). Retrieved on March 13, 2011, from www.worldbookecnyclopedia.com

You May Also Find These Documents Helpful

  • Good Essays

    Service Request SR-ht-03

    • 569 Words
    • 2 Pages

    Next is the explanation of what are in the tables and the entity relationship between them. Table Tire Maintenance, this table has a relationship with Table Vehicle Maintenance. Their relationship is when the maintenance type ID is entered into the database it is automatically connected to the Table Maintenance work order section of the database. Table Maintenance work order has a relationship with Table Vehicle Types for type of vehicle. Part ID relates to Table parts Inventory Issues to link any kind of parts inventory subjects. Table Parts Inventory Issues has a relationship with Table Parts Inventory Purchases for any type of purchase information. Table Parts Catalogue has relationship with Table…

    • 569 Words
    • 2 Pages
    Good Essays
  • Good Essays

    First our team will talk about how Microsoft Access was used to create these tables by Huffman Trucking Database. Then how we used the tables with made up information to be tested on. Then on how we used forms in the maintenance database system. While the creation of relationships and normalization is explained in the process of using queries to search the database (University of Phoenix, 2007).…

    • 820 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    The Kudler Foods need to design an entity relationship diagram to illustrate what needs to be on the table. A few of the tables could be combined to make reading the tables much easier. Kudler foods could combine inventory/order relationship, for example; order/sale relationship table, inventory/sale relationship table, and sale/receive payment relationship table. By combining any one of these tables Kudler Foods could process orders faster, find information faster by having the data in order and labeled and overall making the company’s system more efficient. One table Kudler Foods does not have that the management should consider which would benefit the business is an “employee table”. This way; Kudler could have personal information, sales numbers, last date he/she was reviewed, and just able to keep up…

    • 4521 Words
    • 87 Pages
    Satisfactory Essays
  • Good Essays

    An entity relationship diagram (ERD) is a graphical documentation technique used in the designing of database within organizations to describe the entities and their direct relationships (Bagranoff, Simkin, & Strand, 2008). The ERD diagram consists of entities, attributes, and relationship. The entity represents a rectangular; the diamond is symbolized by describing the relationship of the entities, oval shape describes the attributes, and the lines connect all three to describe their relationship. Attached is an ERD of Kudler Fine Foods showing their existing data tables.…

    • 496 Words
    • 2 Pages
    Good Essays
  • Satisfactory Essays

    Part 1 1. Write a script which will Create the needed tables as follows: a. Table name : DEPT i. Column datatype Mandatory? PK? FK?…

    • 1169 Words
    • 5 Pages
    Satisfactory Essays
  • Satisfactory Essays

    PT2520 Week 3 Forum

    • 190 Words
    • 1 Page

    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
  • Satisfactory Essays

    DBM 380 (Data Base Management) Complete Course Material Click on The Link Below to Purchase A+ Work http://hwminute.com/downloads/dbm-380-data-base-management-complete-course-material/ DBM 380 Week 1 DQ 2.docx DBM 380 Week 1 DQ 1.docx DBM 380 Week 1 Individual Assignment Database Design Paper.docx DBM 380 Week 2 DQ 2.docx DBM 380 Week 2 Individual Assignment; Database Management Systems Paper.docx DBM 380 Week 2 DQ 1.docx DBM 380 Week 3 DQ 1.docx DBM 380 Week 3 DQ 2.docx DBM 380 Week 3 Individual Assignment Driving Log.accdb DBM 380 Week 3 Individual Assignment Driving Log.zip DBM 380 Week 3 Individual Assignment ERD.pdf DBM 380 Week 3 Individual Assignment ERD.zip DBM 380 Week 3 Individual Assignment.zip DBM 380 Week 3 Individual Assignment ERD.pdf DBM 380 Week 3 Individual Assignment ERD.zip DBM 380 Week 4 DQ 1.docx DBM 380 Week 4 DQ 2.docx DBM 380 Week 4 Explaination Of Normalization.docx DBM 380 Week 4 Individual Assignment ERD.zip DBM 380 Week 4 Indiviual Assignment Driving Log Relationships.accdb DBM 380 Week 4 Indiviual Assignment Driving Log Relationships.zip DBM 380 Week 4 Individual Assignment ERD.pdf DBM 380 Week 5 DQ 1.docx DBM 380 Week 5 DQ 2.docx DBM 380 Week 5 LT Database FINAL.accdb DBM 380 Week 5 LT Database FINAL.zip DBM 380 Week 5 LT Huffman PowerPoint REVISED.pptx DBM 380 Week 5 LT Huffman Trucking SR-ht-003.docx DBM 380 Week 5 LT Huffman Trucking SR-ht-003.docx $30.00 – Purchase DBM 380 (Data Base Management) Complete Course Material Click on The Link Below to Purchase A+ Work http://hwminute.com/downloads/dbm-380-data-base-management-complete-course-material/ DBM 380 Week 1 DQ 2.docx DBM 380 Week 1 DQ 1.docx DBM 380 Week 1 Individual Assignment Database Design Paper.docx DBM 380 Week 2 DQ 2.docx DBM 380 Week 2 Individual Assignment; Database Management Systems Paper.docx DBM 380 Week 2 DQ 1.docx DBM 380 Week 3 DQ 1.docx DBM 380 Week 3 DQ 2.docx DBM 380 Week 3 Individual Assignment Driving…

    • 395 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    CTS 2437 Final Exam

    • 630 Words
    • 4 Pages

    4. Create a table called Customers that contains a person’s first name, last name, and social security number. Your table definition should…

    • 630 Words
    • 4 Pages
    Satisfactory Essays
  • Good Essays

    Nt1320 Unit 7

    • 2041 Words
    • 9 Pages

    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
  • Powerful Essays

    Changes to this information are submitted in writing (on special forms) by the employee’s manager and are entered into the system by the payroll clerk. Training and development records are kept in an Excel worksheet by the training and development specialist. Each recruiter maintains applicant information for open positions. Résumés are filed in a central storage area, and an Excel spreadsheet is used to track the status of applicants. Workers’…

    • 1900 Words
    • 55 Pages
    Powerful Essays
  • Good Essays

    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
  • Satisfactory Essays

    week 4 Discussion 1

    • 447 Words
    • 2 Pages

    If we are going to develop Database, we might as well make it look good. By doing this, we can improve the database ability to provide information and to enhance the operational characteristics. It is important to understand that normalization cannot be relied on to make designs by itself but will need to by create separately. The following two methods can be used to improve the design of database system.…

    • 447 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    This manual defines the comprehensive database plan for Riordan Manufacturing material 's ordering database. Team C, consisting of Master degree-seeking students at University of Phoenix Online, has created this database plan. The assignment was completed in 6 weeks.…

    • 2376 Words
    • 10 Pages
    Powerful Essays
  • Good Essays

    Logical Design Pt. 2

    • 641 Words
    • 3 Pages

    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
  • Satisfactory Essays

    Chapter 1 Level 1

    • 689 Words
    • 3 Pages

    Name the Employee and Customer tables according to their contents and the Leszynski/Reddick naming conventions.…

    • 689 Words
    • 3 Pages
    Satisfactory Essays