Cis 111
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.
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.
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.