May 29th, 2015
Studypool Tutor
Price: \$0 USD

Tutor description

Word Count: 2187
Showing Page: 1/15
Relational Model Concepts:The relational Model of Data is based on the concept of a RelationThe strength of the relational approach to data management comes from the formal foundation provided by the theory of relationsRelational Model Concepts:A Relation is a mathematical concept based on the ideas of setsThe model was first proposed by Dr. E.F. Codd of IBM Research in 1970 in the following paper:"A Relational Model for Large Shared Data Banks," Communications of the ACM, June 1970The above paper caused a major revolution in the field of database management and earned Dr. Codd the coveted ACM Turing AwardInformal Definitions:Informally, a relation looks like a table of values.A relation typically contains a set of rows.The data elements in each row represent certain facts that correspond to a real-world entity or relationship In the formal model, rows are called tuples Each column has a column header that gives an indication of the meaning of the data items in that columnIn the formal model, the column header is called an attribute name (or just attribute)Informal Definitions:Key of a Relation:Each row has a value of a data item (or set of items) that uniquely identifies that row in the tableCalled the keyIn the STUDENT table, SSN is the keySometimes row-ids or sequential numbers are assigned as keys to identify the rows in a tableCalled artificial key or surrogate keyFormal Definitions:The degree of a relation is the number of attributes n of its r

## Review from student

Studypool Student
" Thanks for the help. "

1819 tutors are online

### Other Documents

05/29/2015
05/29/2015
05/29/2015
05/29/2015

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors