ahlawat-ACC321_RelationshipExamples-3044171112

ahlawat-ACC321_RelationshipExamples-3044171112 -...

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

View Full Document Right Arrow Icon
Relationships between database tables: Dr. AHLAWAT 3/20/12
Background image of page 1

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

View Full DocumentRight Arrow Icon
Review D a t a b a s e e s s An Entity Table -- a person, place or thing about which we want to collect and store multiple instances of data It has a name It has attributes (fields) that describe the data we are * employee-id employee-L- name employee-F- name EMPLOYEE
Background image of page 2
Relationships In the context of database, there are three basic types of relationships: 1) one-to-one, 2) one-to-many, and 3) many-to-many. 3/20/12
Background image of page 3

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

View Full DocumentRight Arrow Icon
Relationship between two entities (tables) 3/20/12
Background image of page 4
Review D a t a b a s e e s s Relationship -- illustrates the association between two entities (tables) It has a name. enroll 3/20/12 Student Course
Background image of page 5

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

View Full DocumentRight Arrow Icon
Relationships MINIMUM: expresses the minimum number of times one instance of an entity set must participate in a relationship 0 = optional participation 1 = mandatory participation MAXIMUM: expresses the maximum number of times one instance of an entity set may participate in a
Background image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 03/20/2012 for the course BUS LAW 320 taught by Professor Soos during the Spring '10 term at Rutgers.

Page1 / 18

ahlawat-ACC321_RelationshipExamples-3044171112 -...

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

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