VOTO GIORGIO
S245563
HOMEWORK N.1
EXERCISE 1
TABLES:
1. DANCER!(SSN,!Name,!DateOfBirth,!CityOfResidence,!MainDanceType)!
2. DANCE_SCHOOL!(DSCode,!Name,!City,!Artistic!Director)!
3. BALLET!(BCode,!DSCode,!Title,!#Scene,!Type,!Choreographer!Name)!
4. DANCER-PARTICIPATES-IN-BALLET(SSN,!BCode,!DSCode,!Role)!!
!
!
!
!
!
!
1. DPIB_1, DIPB_2: DANCER-PARTECIPANTES-IN-BALLET
2. BAL_1, BAL_2: BALLET
3. DS_1, DS_2: DANCE_SCHOOL
4. DANCER: DANCER
DPIB_1!
BAL_1
⨝!
DPIB_1.BCode=BAL_1.BCode
DPIB_2!
BAL_2
⨝!
DPIB_2.BCode=BAL_2.BCode
⨝!
BAL_1.BCode<>BAL_2.BCode
BAL_1.Type=BAL_1.Type
DPIB_1.DSCode<>DPIB_2.DSCode
DS_1.Artistic_Director=DS_2.Artistic_Director
DPIB_1.SSN=DPIB_2.SSN
!
DS_1
DS_2
⨝!
BAL_1.DSCode=DS_1.DSCode
⨝!
BAL_2.DSCode=DS_2.DSCode
DANCER
⨝!
DANCER.SSN=DPIB_1.SSN
!
∏DANCER.SSN,DANCER.CityOfResidence!
!
