Features Of The Speedy Wheels' Business Strategy Essay

Features Of The Speedy Wheels Business Strategy - Essay ExampleThe company has keep 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 provide not completely 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 expatiate 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. snag 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 arouse 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 better 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 betw een various entities of the model