IT Database / ERD Task
Statement of Work
Executive summary
The database will be implemented by an appropriate software package that will allow for an effective storage of the data. When implemented, it will be possible to access the data by multiple users as well as multiple application programs that are appropriate for various situations. The database will therefore have to represent complex relationships among various items and also control the operations to the data. With this, there will be the need to have the necessary user defined rules to ensure that the integrity of the data is always enhanced. As a result of this, the data within the database of this company will require that there are various interfaces for manipulation of the data
Purpose of the Project
This project is for S7 L Construction equipment with which it will enhance the operations of the company. There are various activities with which the company facilitates in the operations of selling equipment and the services provided. This project will therefore result in the implementation of the most suitable design for managing all the activities within the company. This is to keep track of all the operations to handle the data regarding the customers within the company. Such a design will ensure that the company has a comprehensive overview of the details and all the contacts of the customers within the organization. Since the company deals in various machines it is appropriate that there is a well managed record system to handle the details regarding various machines within the company therefore, the implementation of this project will result into this useful realization. In addition to this, having this system implemented aims at having a record that shows the link which exists between the customers and the machines in the organization. Therefore, having a sales record will ensure that it is possible to keep track of the flow of machines in the company’s stock.
Scope of the Work
The work will cover only the entities within the company which includes the customers, machines, services, sales persons and sales records. However, due to the dynamic nature of businesses, the project will provide options with which it is possible to extend to accommodate new entities that would come with time.
Possible achievements for the implementation
With the database system in place, it provides a primary mechanism with which the company will manage the important details regarding the sale of machines. The following will be the achievements of this implementation:
The database will ensure that there is an intermediate layer between the programs for managing the operations and the data.
With the database implemented, it will be possible to carry out various operations on the data while the required features of the data are maintained.
The other achievement will allow users within the company to create update and extract information from the database whenever it is required.
Implementing the database will realize improved aspects of speed, accuracy and the general accessibility.
Benefits offered by the new database
Data redundancy will be controlled with which the data will be integrated into a single database file therefore making the possibility of having duplicates impossible
It will be possible to effectively share data effectively by authorized users within the organization whereby many users will be enabled to access the information simultaneously depending on the access rights
There will also be consistency of data enhancing the ease of updates or other operations on the data within the company
The database will make it possible to integrate the data since it would always be possible to retrieve and manage the data in other related applications
Data security will be another aspect with which the use of forma will ensure that the data is saved appropriately and behaves like a software component.
