This preview shows page 1. Sign up to view the full content.
Unformatted text preview: with updating and maintaining integrity.] Consider the example of a uni-versity registry database, which has a relation Student storing the students’ names, addresses and examination numbers. It is usual to represent such a database relation as a table: name address number . . . . . . . . . Brown, B 5 Lawn Rd. 105 Jackson, B. 1 Oak Dr. 167 Smith, J. 9 Elm St. 156 Walker, S. 4 Ash Gr. 189 . . . . . . . . . Each tuple of the relation corresponds to a row in the table. The records in a database, in this case name , address , number , are called the attributes of the relation; each attribute corresponds to a column. Associated with each 21...
View Full Document
This note was uploaded on 01/02/2010 for the course MATH Math2009 taught by Professor Koskesh during the Spring '09 term at SUNY Empire State.
- Spring '09