CREATE TABLE CLIENT(
C_ID NUMBER(10) NOT NULL,
C_fname VARCHAR2(20) NULL,
C_sname VARCHAR2(30) NULL,
C_phone VARCHAR2(15) NULL,
C_add1 VARCHAR2(20) NULL,
C_add2 VARCHAR2(20) NULL,
PRIMARY KEY(C_ID)
);


CREATE TABLE BEAUTICIANS(
b_ID NUMBER(10) NOT NULL,
b_fname VARCHAR2(20) NULL,
b_sname VARCHAR2(30) NULL,
b_location VARCHAR2(40) NULL,
b_phone VARCHAR2(15) NULL,
b_email VARCHAR2(40) NULL,
PRIMARY KEY(b_ID)
);

CREATE TABLE clientBeau(
	C_ID NUMBER(10),
	B_ID NUMBER(10),
	PRIMARY KEY(C_ID, B_ID),
	FOREIGN KEY (C_ID) REFERENCES CLIENT (C_ID),
	FOREIGN KEY (B_ID) REFERENCES Beauticians(B_ID)
);