Acme

Acme Global Consulting

Jermaine Patterson

Strayer University

CIS 110

[ April 16, 2012 ]

Professor Robert Davy

Acme Global Consulting

My name is Jermaine Patterson and I am here to convince you to use an E-R model to develop a database. First the advantage of using a relational model is it allows for Data Independence. This helps to provide a sharp and clear boundary between the logical and physical aspects of database management. Also simplicity, this provides a more simple structure than those that were being used before it. A simple structure that is easy to communicate to users and programmers and a wide variety of users in an enterprise can interact with a simple model. Last it is a good theoretical background. This means that it provides a theoretical background for the database management field. The benefit of using an E-R model is allows the designer to express the conceptual properties of the database in an enterprise schema by using E-R diagrams that is independent of any DBMS. The E-R model is simple to use, they are user friendly, and they can provide a unified view of data, which is independent of any data model.

There are components of an E-R model such as entities which is any object that exists and can be distinguished from other objects. An entity can represent a person, event, place, or object in the real world that you plan to model in the database. Attributes represent the defining properties or qualities of the entity type. A superkey is an attribute set that uniquely identifies entity instances. This means that it allows us to tell on entity instance from another. A candidate key is one that does not contain extra attributes. The composite key consists of more than one attribute. The relationships in the E-R model are connections or interactions among the entity instances. The role is similar to the relationship component. Existence dependency describes whether an entity in a relationship is optional or mandatory.

Besides the...