Features Of The Speedy Wheels' Business Strategy - Essay Example

The company has maintained the information about its vehicles, drivers, and customers in MS Excel Workbooks and Spread Sheets. However, to support the enhanced business operations, this file-based information system is required to be replaced with the full-scale database is driven application. This will not only reduced the data synchronization and maintenance issues but will also provide business intelligence. The current system is not only proving costly in terms of time and effort but it also causes considerable delays in the information retrieval.

The management is now considering the current system migration to a complete solution based upon Relational Database Management System (RDBMS) because it provides the factual data which is fundamental to the progress. (Sumathi & Esakkirajan, 2007). 2. In order to facilitate system migration, a detailed system design for the information management in Speedy Wheels is proposed. The model consists of the following major entities (Tables). a. Vehicles: This entity will contain basic information about the Vehicles maintained by the company. b. Drivers: This entity will maintain the basic information of the drivers available in various categories. c. Customer: This entity will maintain the customer information including contact details. d. Rent: This entity will be used to record the rent charged for each service along with date and time information. e. Expense: This entity is supposed to record fuel and maintenance expense of each vehicle maintained by the company. 3. As Helpin & Tony (2010) have stressed that “the information model that clearly reveals the underlying semantics of the domain” is considered the best model, therefore, the proposed information model will be based upon a relational data model and various entities within the model will have a closer relationship with each other.

 Following is a list of three major relations that exist between various entities of the model;