Normalization of the Erd free essay sample

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. We will write a custom essay sample on Normalization of the Erd or any similar topic specifically for you Do Not WasteYour Time HIRE WRITER Only 13.90 / page 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 would be used to keep an accurate account of the total hours for employees when they are not working. In addition to the three tables already created there would be a need for a fourth table. The fourth table that needs to be created would contain the following information; Name, Employee ID Number, Sleeper Berth, Start and Stop Time, and the Total Sleeper Berth Time. This particular table would show how long each employee uses the sleeper berth and also the total number of hours for each employee in the sleeper berth log. Next there needs to be a fifth table created for the diagram. This table would need to consist of the following information; Name, Employee ID Number, Date, Driving Start and Driving Stop Time, and the total number of hours that the employee is driving. This table would be used to see how long each employee is driving on each trip. This table also contains information of the total number of hours that each employee will drive while on shift.The sixth table that needs to be created needs contain additional information about the driver. This information will need to consist of the following; Name, Employee ID Number, On Duty (not driving) start and stop time, and the total number of hours on duty (not driving). This table would track each employee’s hours that were worked when not driving, this table also shows the total amount of hours worked but not while driving. The last table that needs to be created is would have to contain the following information; Name, Employee ID Number, Odometer start and stop miles and also the total amount of miles that each driver drives.The last table that I create is going to be used to track each of the driver’s odometer readings. This would include each time that they drive and the total amount of miles driven by each driver. All of the tables will have a comment column section included on the table. This is added so that additional information can be added when needed by office personnel or by the driver. I believe that the violations table only needs normalization if there is more than one citation and if there are more than one in a different sate or municipality issuing the citation. The driver’s log tables are important for drivers and employee to fill out in order to provide correct and accurate information. In order for the drivers log ERD to be successful is to make sure that there is no duplicate and unnecessary information. In this paper, we looked at the ERD of the driver’s log. We then looked at other tables that share a relationship with additional tables that go with the original table. I hope that you were able to learn about the ERD and the driver’s log.