2
PERSON_ID VARCHAR(50) NOT NULL,
3
DOB VARCHAR(50) NOT NULL,
4
NAME NVARCHAR(255) NOT NULL,
5
CONSTRAINT PK_PERSON PRIMARY KEY (PERSON_ID, DOB)
8
PERSON_ID VARCHAR(50) NOT NULL,
9
DOB VARCHAR(50) NOT NULL,
10
PHOTO_DETAILS VARCHAR(50) NULL,
11
CONSTRAINT PK_PHOTO PRIMARY KEY (PERSON_ID, DOB),
12
CONSTRAINT FK_PHOTO_2_PERSON FOREIGN KEY (PERSON_ID, DOB) REFERENCES PERSON (PERSON_ID, DOB)
14
CREATE TABLE ADDRESS (
15
PERSON_ID VARCHAR(50) NOT NULL,
16
DOB VARCHAR(50) NOT NULL,
17
ADDRESS_ID VARCHAR(50) NOT NULL,
18
ADDRESS_DETAILS NVARCHAR(250) NULL,
19
CONSTRAINT PK_ADDRESS PRIMARY KEY (PERSON_ID, DOB, ADDRESS_ID),
20
CONSTRAINT FK_ADDRESS_2_PERSON FOREIGN KEY (PERSON_ID, DOB) REFERENCES PERSON (PERSON_ID, DOB) ON DELETE CASCADE
22
INSERT INTO PERSON VALUES("10", "11011999", "John");
23
INSERT INTO PHOTO VALUES("10", "11011999", "new photo");