Table - parent

[yudisentosa]

DROP TABLE IF EXISTS parent; CREATE TABLE parent( student_id CHAR(5) NOT NULL PRIMARY KEY ,parent_name VARCHAR(8) NOT NULL ,sex CHAR(1) NOT NULL ,birthdate DATE NOT NULL ,relationship VARCHAR(12) NOT NULL, FOREIGN KEY (student_id) REFERENCES student(student_id) ); INSERT INTO parent(student_id,parent_name,sex,birthdate,relationship) VALUES ('00001','Nurul','F','1981-10-15','Ibu kandung'); INSERT INTO parent(student_id,parent_name,sex,birthdate,relationship) VALUES ('00002','Surya','M','1987-05-27','Ayah kandung'); INSERT INTO parent(student_id,parent_name,sex,birthdate,relationship) VALUES ('00003','Ali','M','1965-11-13','Ayah kandung'); INSERT INTO parent(student_id,parent_name,sex,birthdate,relationship) VALUES ('00004','Daud','M','1965-11-13','Ayah Kandung'); INSERT INTO parent(student_id,parent_name,sex,birthdate,relationship) VALUES ('00005','Sri','F','1982-10-14','Ibu kandung'); INSERT INTO parent(student_id,parent_name,sex,birthdate,relationship) VALUES ('00006','Aditya','M','1965-11-13','Ayah Kandung'); INSERT INTO parent(student_id,parent_name,sex,birthdate,relationship) VALUES ('00007','Amir','M','1972-06-14','Ayah Kandung'); INSERT INTO parent(student_id,parent_name,sex,birthdate,relationship) VALUES ('00008','Raja','M','1978-09-02','Ayah Kandung'); INSERT INTO parent(student_id,parent_name,sex,birthdate,relationship) VALUES ('00009','Abdul','M','1977-04-28','Ayah Kandung'); INSERT INTO parent(student_id,parent_name,sex,birthdate,relationship) VALUES ('00010','Ibrahim','M','1979-04-22','Ayah Kandung'); INSERT INTO parent(student_id,parent_name,sex,birthdate,relationship) VALUES ('00011','Arif','M','1979-04-22','Ayah Kandung'); INSERT INTO parent(student_id,parent_name,sex,birthdate,relationship) VALUES ('00012','Iman','M','1981-08-13','Ayah Kandung'); INSERT INTO parent(student_id,parent_name,sex,birthdate,relationship) VALUES ('00013','Hasan','M','1966-10-17','Ayah Kandung'); INSERT INTO parent(student_id,parent_name,sex,birthdate,relationship) VALUES ('00014','Muhammad','M','1976-05-25','Ayah Kandung'); INSERT INTO parent(student_id,parent_name,sex,birthdate,relationship) VALUES ('00015','Muhamad','M','1974-01-16','Ayah Kandung'); INSERT INTO parent(student_id,parent_name,sex,birthdate,relationship) VALUES ('00016','Mansur','M','1969-09-01','Ayah Angkat'); INSERT INTO parent(student_id,parent_name,sex,birthdate,relationship) VALUES ('00017','Mansur','M','1973-04-04','Ayah Angkat'); INSERT INTO parent(student_id,parent_name,sex,birthdate,relationship) VALUES ('00018','Mansur','M','1984-05-27','Ayah Angkat'); INSERT INTO parent(student_id,parent_name,sex,birthdate,relationship) VALUES ('00019','Nur','F','1983-06-23','Ibu kandung'); INSERT INTO parent(student_id,parent_name,sex,birthdate,relationship) VALUES ('00020','Nur','F','1979-03-09','Ibu kandung'); INSERT INTO parent(student_id,parent_name,sex,birthdate,relationship) VALUES ('00021','Budi','M','1980-04-28','Ayah Kandung'); INSERT INTO parent(student_id,parent_name,sex,birthdate,relationship) VALUES ('00022','Ani','F','1983-06-04','Ibu kandung'); INSERT INTO parent(student_id,parent_name,sex,birthdate,relationship) VALUES ('00023','Titik','F','1983-09-12','Ibu kandung'); INSERT INTO parent(student_id,parent_name,sex,birthdate,relationship) VALUES ('00024','Komang','M','1977-08-01','Ayah Kandung'); INSERT INTO parent(student_id,parent_name,sex,birthdate,relationship) VALUES ('00025','Malih','M','1979-08-24','Ayah Kandung');