Advantages of a Relational Model for ACME Global Consulting
Following are the advantages which would be experienced by ACME global consulting through the implementation of relational model.
Through the implementation of relational model ACME Global Consulting can avoid duplication of records.
Through the implementation of relational model ACME Global Consulting can referential integrity and, to delete a record deletes all records pertaining dependents.
It would provide ACME Global Consulting restricted access to data access to data, and accessing the data through other means will not be possible. The user can not only have transparent access to all the information you need, but also is enabled to process as you like (van de Groenendaal, & Chakraborty, A. (2012).
Through the implementation of relational model ACME Global Consulting the customer can work in most convenient environment without worrying conversion interfaces and protocols. It focuses on the work to be performed more than technology.
The implementation of relational model would make it possible to add or remove servers and workstations since the system can be more or less easy to reconfigure. It is also easier to implement a new application by means of building an extension to a server and new workstations.
Purpose of an E-R Model Specific to ACME Global Consulting
This E-R model will provide ACME Global Consulting with a graphical representation of the logical structure of a database. The structure is characterized by using a series of symbols and rules for representing data and relationships. This model is obtained at design time database. The main elements of entity-relationship model are the entities with their attributes and relationships between entities. Elements entity-relationship model Entity is an object that contains information of interest regarding the database.
Components of E-R Model
This model represents reality through a scheme using the terminology graphic ...