Fleet Truck Maintainenace Database Paper
Its mind numbing to reflect the amount of technical change that has taken place in only a short period of time. In this current age, innovation has opened doors to a wide capacity for data collection and management. An example is the amount of business use with Microsoft Access. Businesses have gained from Access’s technical capabilities by using it to offer a wide range of ways to add value and efficient to any facility. Today we use Access databases to organize the way we live and work. This software is very technical savvy and uses tables, fields and records to organize company data and ultimately to speed up solving any business problems or inquires. Team B has developed a Microsoft Access database for Huffman Trucking Company to manage their Fleet Truck Maintenance. Within this database factors such as drivers, vehicle and tire maintenance descriptions and orders, parts, vendors, and violations are tracked and maintained. This paper will serve as a design document on the database Team B created. It will discuss the definition of a database, why Huffman Trucking needed to develop a database for their Fleet Truck Maintenance, and finally what the database will accomplish. What is a Database?
Databases are designed to offer an organized mechanism for storing, managing and retrieving information. They do so through the use of tables. A database table is a structured collection of records or data that is stored in a computer system. The structure is achieved by organizing the data according to a database model. The model that is most commonly used today is the relational model. Other models such as the hierarchical model and the network model use a more explicit representation of relationship (About, 2009). Just as the tables in Microsoft Excel, database tables consist of columns and rows too. Each column has a different classification and each row corresponds to a single record. For example, Team B created a database...
Please join StudyMode to read the full document