Preview

My Team Portion

Satisfactory Essays
Open Document
Open Document
436 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
My Team Portion
Huffman Trucking Planning and Creation of Fleet Truck Maintenance Database

JaDonna Berger, Kelly Rottler, Stefanie Childree,
Gene Holmes, Greg Miller, Guillermo Blanco
DBM/380
Professor Shalini Devi
May 5, 2015

The most important step when creating a database are detecting the table elements. While analyzing the form entitled “Entities and Attributes for Fleet Truck Maintenance,” the database table elements can be clearly determined. The structure of a database can be defined based on the Entities and Attributes within a table or a relation. Entities may be used to allow the same rule to be applied multiple times to make a determination ("Define an Entity", n.d.). An attribute basically describes what the entity is. The entity-relationship model (or ER model) is a way of graphically representing the logical relationships of entities (or objects) in order to create a database. The ER model was first proposed by Peter Pin-Shan Chen of Massachusetts Institute of Technology (MIT) in the 1970s (TechTarget, 2005-2015).
Entities and Attributes Selection
The clearly defined Entities and Attributes are located within the document entitled “Entities and Attributes for Fleet Truck Maintenance.” Underneath each capitalized entity are its particular attributes. A good example of this would be the entity entitled “Parts-Inventory-Issues,” and below this are the attributes which include: Issue Date, Transaction ID, Quantity, and Purchase Price.
It is important to make sure that all attributes are examined in order to make sure there aren’t any signs of redundancy and to also confirm that the table is logically organized when creating the table. As a result of this, all attributes and entities located within the actually database will have to be revised based on the documents attributes. Any attributes that show signs of repetitiveness will be reorganized or deleted in order to guarantee a consistent database. Each table will include a primary key which will



References: Define an entity. (n.d.). Retrieved from https://docs.oracle.com/html/E38269_01/Content/Data%20model/Define_an_entity.htm TechTarget. (2005-2015). entity-relationship model (ERM or ER model) definition. Retrieved from http://searchsqlserver.techtarget.com/definition/entity-relationship-model

You May Also Find These Documents Helpful

  • Good Essays

    According to Service Request SR-ht-003, We were to develop a design for a fleet truck maintenance database, located on the Huffman Trucking IT Service Requests site. This paper will talk about how our team completed the Change Request that was on the Huffman Trucking Service Request.…

    • 820 Words
    • 4 Pages
    Good Essays
  • Good Essays

    Huffman Trucking is a large company and has been around since the early 1900’s. When the company started there was one tractor trailer and now the corporation has seen quite an extensive progression throughout the years. With several types of trailers and large employee base the company has spread out and has facilities located all across the country from New Jersey to California. Huffman Trucking Company consulted with another company known as Smith Systems Consulting to develop entities and attributes for a database for the fleet truck maintenance, but was unable to complete the job successfully.…

    • 699 Words
    • 3 Pages
    Good 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
  • Good Essays

    It2640 Week 5 Appendix B

    • 632 Words
    • 3 Pages

    Entities for this database application will include a Customer, Products, Orders, Sales Rep and Shipping table. The attributes for the following tables are as follows:…

    • 632 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    To provide Huffman trucking with a comprehensive database the design team will first develop the requirements. During the requirements stage the team will conduct interviews with all the stakeholders as well as gather sample forms, reports, queries, and descriptions of all activities involved with the fleet maintenance process. The second portion of the requirements stage is for the team to create prototypes and working demonstrations of the proposed solution. These prototypes will be used to obtain additional feedback from the stakeholders and create the fine tune the database requirements (Kroenke & Auer, , 2010).…

    • 553 Words
    • 3 Pages
    Satisfactory Essays
  • Better Essays

    University of Phoenix. (2006). Huffman Trucking: Entities and Attributes for Fleet Truck Maintenance. Retrieved February 19, 2006, from University of Phoenix VOP: https://ecampus.phoenix.edu/secure/aapd/CIST/VOP/Business/Huffman/IT/Databases/HuffmanDatabasesEntities%20and%20Attributes%20for%20Fleet%20Truck%20Maintenance.doc…

    • 3219 Words
    • 13 Pages
    Better Essays
  • Good Essays

    The following diagram (1-1) is entity relationship (E-R) diagram and it illustrates the existing data tables.…

    • 851 Words
    • 4 Pages
    Good Essays
  • Good Essays

    Acme Global Consulting

    • 678 Words
    • 3 Pages

    Another advantage of having an E-R model DBMS is the components of this model. This will allow your different employee groups to distinguish the differences between these different components in the model. Some of the components are entities that represent a person, place event or an object in the real world that is modeled in the DBMS. Another component is attributes; this represents the defining qualities or properties of the entity type. One more entity is called a…

    • 678 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Unit 3 research

    • 383 Words
    • 2 Pages

    An entity-relationship diagram is a specialized graphic that illustrates the relationships between entities in a database. ER diagrams often use symbols to represent three different types of information. Boxes are commonly used to represent entities. Diamonds are normally used to represent relationships and ovals are used to represent attributes…

    • 383 Words
    • 2 Pages
    Good Essays
  • Powerful Essays

    IST223 Crib sheet

    • 3425 Words
    • 7 Pages

    rectangles, and relationships are shown by lines between the rectangles. Attributes are generally listed within the rectangle. The many side of many relationships is represented by a crows footentity-relationship (E-R) modelA set of constructs and conventions used to create data models. The things in the users world are represented by entities, and the associations among those things are represented by relationships. The results are usually documented in an entity-relationship (E-R) diagramID-dependent entityan entity whose identifier includes the identifier of another entityidentifierwhich are attributes that name, or identify, entity instancesidentifying relationshipIn such relationships, the parent is always required, but the child (the ID-dependent entity) may or may not be required, depending on application requirements. Identifying relationships are shown with solid lines in E-R diagrams.is-aRelationships among supertype/subtype entitiesmandatoryat least one entity instance must participate in the relationshipmaximum cardinalityThe maximum cardinality is the maximum number of entity instances that can participate in a relationship instance.minimum cardinalityThe minimum cardinality is the minimum number of entity instances that must participate in a relationship instance.nonidentifying relationshiprelationship drawn with a dashed line (refer to Figure 5-7) is used between strong entities and is called a nonidentifying relationship because there are no ID-dependent entities in the relationship.null valueare a problem because they are ambiguous. They can mean that a value is inappropriate, unknown, or known, but not yet been entered into the databaseparentAn entity or row on the one side of a one-to-many relationshiprecursive relationshipoccurs when an entity type has a relationship to itself.relationship classAssociations among entity classesrelationship instanceassociations among entity instances.strong entityan entity that represents something that can exist…

    • 3425 Words
    • 7 Pages
    Powerful Essays
  • Good Essays

    Cis 515week 3

    • 1024 Words
    • 4 Pages

    In order to properly indentify the university’s requirements and create an accurate proposal, the first step should be to create and Entity Relationship Model (ERM). The ERM will provide a visual representation of the data structure of the data stores and show the relationships between the data. The following diagram displays the ERM:…

    • 1024 Words
    • 4 Pages
    Good Essays
  • Good Essays

    Entities are defined as a person, place, thing, or event in which data is collected and stored. Each entity is a unique and distinct object that may be a physical or abstract object within the real world (Coronel, Morris, & Rob, pg. 34). Entities of a database for a college that needs to keep track of students and courses would be students, professors, courses, classes, room, and enrollment status. These entities will be used to format the data within the database so that each student and course is accounted for. Attributes are characteristics of an entity, such as a name, phone number, or address (Coronel, Morris, & Rob, pg. 34). Attributes for the college database would include student first and last name, student phone number, student address, student identification number, student grade point average, student course major, and student classes to describe the student entity. The professor entity would be described by professor…

    • 906 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Database for Scheduling

    • 528 Words
    • 3 Pages

    In the Entity-Relationship Diagram (ERD), we start by identifying the entities. In this instance we will use Instructors and Courses as are entities. Next we will identify how they relate to one another. In this model the Instructors and Courses will relate by Instructor ID and Course ID. Once we have a good ERD we need to review it for normalization which is done automatically in software like Microsoft Access. Once both of these are satisfied we can create the database and check for errors. (Shelly & Rosenblatt, 2012).…

    • 528 Words
    • 3 Pages
    Good Essays
  • Good Essays

    1. Why does the author say that everyone is a theologian? Everyone has an opinion about religion…

    • 9120 Words
    • 37 Pages
    Good Essays
  • Better Essays

    Normalization of the database: This is a critical step for making the database. Normalization will help create table structures as well…

    • 3100 Words
    • 13 Pages
    Better Essays