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
VOTO GIORGIO
S245563 HOMEWORK N.1
∏DANCER.SSN,DANCER.CityOfRes
idence
2 A 1 D
DANCER.SSN=DPIB_1.SSN
2 A 1 D
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
DANCERDS_2DPIB_2BAL_2 2 A 1 D
DPIB_2.BCode=BAL_2.BCode
2 A 1 D
BAL_2.DSCode=DS_2.DSCode
DPIB_1 2 A 1 D
DPIB_1.BCode=BAL_1.BCode
BAL_1DS_1 2 A 1 D
BAL_1.DSCode=DS_1.DSCode
