1 M Strong Strong Relation Copyright 2011 Ramez

  • Slides: 10
Download presentation

1 -M Strong & Strong Relation Copyright © 2011 Ramez Elmasri and Shamkant B.

1 -M Strong & Strong Relation Copyright © 2011 Ramez Elmasri and Shamkant B. Navathe 2

1 -M Strong & Strong Relation Copyright © 2011 Ramez Elmasri and Shamkant B.

1 -M Strong & Strong Relation Copyright © 2011 Ramez Elmasri and Shamkant B. Navathe 3

1 -M Strong & Strong Relation Copyright © 2011 Ramez Elmasri and Shamkant B.

1 -M Strong & Strong Relation Copyright © 2011 Ramez Elmasri and Shamkant B. Navathe Slide 6 - 4

1 -M Strong & Weak Identification Relation Copyright © 2011 Ramez Elmasri and Shamkant

1 -M Strong & Weak Identification Relation Copyright © 2011 Ramez Elmasri and Shamkant B. Navathe 5

1 -M Strong & Weak Identification Relation Copyright © 2011 Ramez Elmasri and Shamkant

1 -M Strong & Weak Identification Relation Copyright © 2011 Ramez Elmasri and Shamkant B. Navathe 6

1 -M Strong & Weak Relation Copyright © 2011 Ramez Elmasri and Shamkant B.

1 -M Strong & Weak Relation Copyright © 2011 Ramez Elmasri and Shamkant B. Navathe 7

1 -M Strong & Weak Relation Copyright © 2011 Ramez Elmasri and Shamkant B.

1 -M Strong & Weak Relation Copyright © 2011 Ramez Elmasri and Shamkant B. Navathe 8

1 -M Strong & Weak Relation Copyright © 2011 Ramez Elmasri and Shamkant B.

1 -M Strong & Weak Relation Copyright © 2011 Ramez Elmasri and Shamkant B. Navathe Slide 6 - 9

FARS Flight-No FLIGHT Number Air. Line FLIGHT-LEG Fight-No Fare-Code Leg-No Dept-Air-Code Leg-No SEAT-RESERVATION Flight-No

FARS Flight-No FLIGHT Number Air. Line FLIGHT-LEG Fight-No Fare-Code Leg-No Dept-Air-Code Leg-No SEAT-RESERVATION Flight-No Date Leg-No AIRPLANE Air. Plan. ID AIRPLANE-TYPE Type-Name Restrictions Week. Days LEG-INSTANCE Flight-No Amount Sched-Dept. Time No. Of. Avail. Seat Date Seat-No Total. No. Of. Seats Max-Seats Company Copyright © 2011 Ramez Elmasri and Shamkant B. Navathe Arr-Air-Code Air. Plane. ID Name Sched-Arr. Time Dept-Air-Code Phone Dept-Time Arr-Air-Code AIRPORT Air-Code Arr-Time Name City Air. Plan. Type. Name CAN-LAND Air. Plan. Type. Name Airport-Code 10

Keys Referencing relation foreign key relation Referenced relationKeys Referencing relation foreign key relation Referenced relation
Strong Boards Strong Plan Strong OrganizationNPI 2015 DonStrong Boards Strong Plan Strong OrganizationNPI 2015 Don
STRONG STRONG STRONG HEALTHY THRIVING NEIGHBORHOODS HEALTHY THRIVINGSTRONG STRONG STRONG HEALTHY THRIVING NEIGHBORHOODS HEALTHY THRIVING
AcidBase Reactions strong acid strong base strong acidAcidBase Reactions strong acid strong base strong acid
J M J STRONG CONSCIENCE STRONG WILL STRONGJ M J STRONG CONSCIENCE STRONG WILL STRONG
Relation A relation is a correspondence between twoRelation A relation is a correspondence between two
Bisnis Public Relation Online Konsep Dasar Public RelationBisnis Public Relation Online Konsep Dasar Public Relation
Industrial RelationLabour Relation Workplace Relation Triarko Nurlambang UniversitasIndustrial RelationLabour Relation Workplace Relation Triarko Nurlambang Universitas
Normalisation RELATION NORMALE l Une relation est diteNormalisation RELATION NORMALE l Une relation est dite