442_Review_Relational

442_Review_Relational - Review:TheRelationalModel 198:442...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Review: The Relational Model 198:442 Rutgers University
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Relational Database: Definitions Relational database :   a set of  relations Relation:  made up of 2 parts: Instance  : a  table ,  with rows and columns.  #Rows =  cardinality , #fields =  degree / arity. Schema  :   specifies   name of relation, plus name and type of  each column. E.G. Students( sid : string,  name : string,  login : string,  age : integer,  gpa : real). Can think of a relation as a  set   of rows or  tuples  (i.e.,  all rows are distinct).
Background image of page 2
Example Instance of Students Relation Rutgers University sid  name  login  age  gpa  53666  Jones  jones@cs  18  3.4  53688  Smith  smith@eecs  18  3.2  53650  Smith  smith@math  19  3.8   Cardinality = 3, degree = 5, all rows distinct  Do all columns in a relation instance have to     be distinct?
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/24/2011 for the course CS 442 taught by Professor Mlittman during the Fall '08 term at Rutgers.

Page1 / 9

442_Review_Relational - Review:TheRelationalModel 198:442...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online