Huffman Trucking: Database Design and Development

Running head HUFFMAN TRUCKING Huffman hauling Database pictureing and Development Huffman Trucking started out as a nonpargonil owner, single hand truck and trailer, operating in the Cleveland Ohio area back in 1936 doing local contract hauls. Today, Huffman Trucking is a National carrier with 1,400 employees, 800 tractors, 2,100 trailers, and 260 roll-on/roll-off units, operating from 3 logistical hubs located in Los Angeles, California, St. Louis, Missouri, and Bayonne, New Jersey and its central criminal maintenance facility located in Cleveland Ohio (Apollo Group Inc. , 2005).With the growth through the years, Huffman Trucking has maintained their competitiveness by world an industry leader in leveraging technology to the maximum to provide customer service and traffic efficiencies (Apollo Group Inc. , 2005). In the fashion to maintain this competitiveness, Huffman Trucking hired metalworker Systems Consulting to develop a coer up of entities and attri besideses that lead be needed for a spend Truck Maintenance Database. Upon receipt of Smiths report percentage pointing the entities and attributes needed, our IT Manager submitted a Service Request SR-ht-003 to role a Fleet Truck Maintenance Database.In the side by side(p) paragraphs LTA pull up stakes discuss the infobase computer computer architecture briefly and primary coil mainstays, which play a vital role in an Entity-Relational Database. The discussions of the different types of mistakes that are made in the design phase that lead to a brusque informationbase design are also discussed. Mistakes include the overlook of careful supply, proper normalization of info, poor naming conventions, lack of qualified documentation and extensive interrogatory. The ERD for the database will be revealed along with the plectron of the political program to manage the database and allow for versatility for various platforms, applications, and features.Huffman Truckings fleet truck mainten ance disgraces are fairly straight-forward, therefore, a basic database design architecture is recommended as a start in the entry of information, and importing of menstruation database records into the new basic database. By starting simple, this database usher out be upgraded over time, as the comp some(prenominal) grows and the fleet grows. The important items to consider when intent a new database include puff of use for the users, the production of query reporting, as well as financial records, parts orders, maintenance records, and purchase rders. A good model and a proper database design form the root of an information system. Building the data layer is often the first little step towards implementing a new system, and pick outting it right requires attention to detail and a whole lot of careful planning. A database, like any computer system, is a model of a small piece of the accepted world. And, like any model, its a narrow representation that disregards oft o f the complexity of the veritable thing (Malone, 2007). A primary recognize, which is a record or an attribute, uniquely identifies a table.Primary keys make mapping relational data simple, in order to uniquely identify apiece entry in the database. The concept of some sort of unique value is common in database designing using account way outs to identify part outcomes, seller numbers, and maintenance work orders. These are also known as immanent keys, common entities that are use to uniquely identify objects. Generally, if the data that is being modeled has a decent natural key, or identifier, that information should non be used as a primary key.Natural keys should not be used as primary keys, as the purpose of the primary key is to uniquely identify a value in a database record. some(prenominal) primary key characteristics are the primary key must be able to identify each row in a table. The primary key should not describe the characteristics of the entity. A part number ID of 2566 is usually like over Air riddle. The value of a primary key should never change. Changing a primary key value means changing the identity of an entity. Changing the identity is not advised. Non-intelligent keys are preferred be grow they are less believably to change.For example, the part number 2566 for an Air stress for one model of truck, and the part number of 2560 would be an Air Filter for another model of truck. To have just a part number of Air Filter would be too ambiguous, and could result in upset time trying to locate the correct air filter for a particular proposition model of truck. Those part numbers, in general would most likely never change over time, therefore, are best to use as primary keys in a database of part numbers. Primary keys should have the smallest number of attributes possible.It is easier to manage unique keys that are numeric. Items to Consider During flesh Phase several(prenominal) things that are easy to overlook during the datab ase design process include design and planning of the database, normalization of data, insufficient naming conventions, documentation, and scrutiny. A brief follow up on of these common errors during the design phase of a database is listed below. By listing them now, it can be used as an in force(p) guide report to follow when designing the database for Huffman Truckings Fleet Maintenance. Design and Planning of the DatabaseGood databases are intentional with careful thought, and with the proper care and attention given to the needs of the data that will be part of it. Since a care in full constructed database is at the tit of every business go for, insufficient planning and detailing of the needs of the project could cause the whole project to lose its direction and purpose. Additionally, by not taking the time at the beginning, any changes in the database structures that may be needed to be made in the future could cause crushing consequences on the whole project, and grea tly increase the likelihood of the project timeline slipping.If the planning phase is rushed, problems will inevitably arise, and because of the lack of proper planning and design, there is usually no time to go back and fix any issues properly. That is when the hacking starts, with the veiled promise to return and fix things later, something that happens very rarely so (Davidson, 2007). Normalization of Data Normalization defines a set of standards to break win tables into their basic parts until each table represents only one thing, and its columns fully describe the only thing that the table represents.Normalizing the Huffman Truckings data is important to ensure proper performance and ease of future festering projects. Insufficient Naming Conventions Naming conventions are most the important line of documentation for any application. What is important to consider is the importance of consistency. Names should be kept simple while at the same time, identifying their purpose to the data being entered. Documentation Not only will a well-designed database aline to certainly quality tandards, it will also contain definitions and examples about its tables, so that its purpose is clear to everyone on how the tables, columns and relationships are intended to be used. The closing of proper documentation should be to provide enough information for a support programmer to find any bugs and fix them easily. Testing As some Information Technology professionals know, the first thing to be unsaved when a business system starts running slow is because the database can get bogged down with fragmented information, or too often information.Deep knowledge of the system is the best way to dispel this notion Unfortunately, testing is the usually one of the things to go in a project when time starts to run out. What is important to consider in this whole process is that deep system testing is done to make sure that the design is implemented correctly. The first real test is for any database is when it goes into production, and users attempt to do real work. And if the system does not work fast enough, or contains bugs when it goes live, then more work will have to done on a live system, which could inherently cause the loss of r so farue of any company.By insisting on strict testing as an important aspect of database development, then perhaps the day will come when the database will not be the first thing to be pointed out when the system slows down. In order to accomplish the goal of establishing a functional database that Huffman can use now and in the future to in effect manage their data, it is recommended that Huffman Trucking decide to use MySQL. in that location are many a(prenominal) great things about MySQL, including the fact that MySQL is very normal among web applications and acts as a database for a multitude of platforms.Some of these platforms include FreeBSD, BSDi, AIX, HP-UX, Linux, Novell NetWare, OS/2 Warp, Solaris, i5/OS, Win dows 95, Solaris, Windows 98, SunOS, Windows ME, Windows 2000, Windows XP, and Windows Vista. MySQL is popular among open source code and bug tracking tools such(prenominal) as Bugzilla as well. MySQL is written in C and C++. Libraries that are used to access MySQL databases can be found in many of directlys programming languages by using language specific APIs. There is also an Open Database Connectivity (ODBC) that allows additional programming languages to communicate with MySQL, including ColdFusion or asp.MySQL features options that are not in many other RDBMSs. One feature that is not included in many RDBMSs is multiple stock engines. This feature allows for a user to select the most effective memory board engine for each table in the application. Another great feature that MySQL offers is native storage engines. These are storage engines that are developed by MySQL and are optimized for specific application storage domain. They offer data warehousing, data archiving, high availability clustering, and many more features. MySQL recently developed a new good transactional storage engine called Falcon.Falcon was designed for modern day corporations and web applications which makes it unblemished for Huffman Trucking. One feature not to be overlooked is the availability of Partner-developed storage engines. Search engines that are partner developed are developed grease ones palms outside companies, but they are then highly tested by MySQL in order to ensure workability and compatibility with MySQL. MySQL also has open source programmers that are independent and develop storage engines. These are used as well, but only after they pass MySQL rigorous inspection and testing.Customers are even developing and designing community storage systems. Commit chemical group is a MySQL feature that allows for the gathering of multiple transactions. This is done from a multitude of connections in order to increase the number of commits per second. Conclusion In c onclusion the Fleet Truck Maintenance Database will be easy to use, provide effective tracking of finances, maintenance, and queries. The primary key(s) used in the database will have the following characteristics be a single attribute, uniquely identify an entity, be non-intelligent, not change over time and be numeric.This will ensure the ease of normalizing the database during the design phase to prevent update anomalies when database is implemented. LTA discussed several mistakes that occur during the design phase in order to avoid the same mistakes. These mistakes include poor design/planning, ignoring normalization, poor naming standards, lack of documentation and testing. The DBMS of choice for Huffman Trucking is MySQL. MySQL will effectively manage our data while allowing many different platforms to interact with the database.MySQL is written in C and C++. However, MySQL offers much versatility in programming languages by using language specific APIs or ODBC to allow additi onal programming languages such as ASP or Coldfusion. MySQL has many options that other RDBMSs do no possess such as multiple storage engines, open source programmers, commit grouping and more. Bottom line is that MySQL offers versatility for our database to allow for continued growth, updates and changes in our companys needs. References Apollo Group Inc. (2005). Huffman Trucking.Retrieved October 1, 2008, from Huffman Trucking Intranet https//ecampus. phoenix. edu/secure/aapd/CIST/VOP/Business/Huffman/HuffmanHome002. htm DavidsonL. ,(2007). Ten Common Database Design Mistakes. Simple-Talk. com. RetrievedSeptember29,2008,fromhttp//www. simple-talk. com/sql/database-administration/ten-common-database-design-mistakes/ MaloneM,(2007). Im Mike. Database Design Choosing A Primary Key. RetrievedOctober1,2008,fromhttp//immike. net/blog/2007/08/14/database-design-choosing-a-primary-key/