Cis 111

Topics: Entity-relationship model, Entity, Relationship Pages: 3 (790 words) Published: June 11, 2013
Assignment 2: Logical Design, Part 1
Professor Cohen
CIS-111
April 15, 2013
Advantages of Relational Model
The relational model would provide Acme Global with a better understanding of the data needs of their organization. A Relational model offers data independence and efficient access. “The conceptual and external schemas provide independence from physical storage decisions and logical design decisions respectively.” (Ramakrishnan, 2007) “The benefits of using the relational model would result in an easy to use, flexible, high performance database at a low cost.” (Anita, 2010) Therefore, allowing them to participate in the entire design process of the logical construction. The relational model provides an easy and flexible way of manipulating data with a system that offers: o Data independence: Guarantees that the data cannot be redefined or reorganized. o Reduced application development time: It will not interrupt the user from accessing the data. o Data integrity and security: The view process and the authorization facilities provide access control mechanisms. o Data administration: Allowing permissions to be set for each user so that restricted information can be hidden so unauthorized users cannot make changes. o Reduced data storage and redundancy

The relational model would provide end users with improved access, by allowing quick answers to ad hoc queries, which reduces the probability of inconsistent data. Acme Global would acquire a firm understanding of the everyday functions of their organization. Purpose of ER model

The purpose of the E-R diagram is to provide an organization with a simple drawing that can be used to describe the organization’s data. The E-R model consists of three primary components o Entities – Can be a person, place, object, event, or a concept. o Attribute – Is a property or characteristic of an entity type that is of interest to an organization. o...

References: Oracle. (2000). Oracle concepts: The relational model. Retrieved from http://docs.oracle.com/cd/A87860_01/doc/server.817/a76965/c01intro.htm
(2012). Database systems: Design, implementation, and management. (10 ed.). United States of America: Joe Sabatino.
Anita, G. (2010). Computer fundamentals. Pearson Education India.
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • CIS 515 Assignment 3 Essay
  • 111 Essay
  • CIS 2010 Final exam copy Essay
  • Essay about English 111
  • CIS Midterm Essay
  • Cis 276 Essay
  • Hum 111 Quiz 2 Essay
  • CIS 510 Quiz ch11 Essay

Become a StudyMode Member

Sign Up - It's Free