drop table CustomerReview;

drop table Restaurant;

create table Restaurant(

	restaurantName 				varchar(80),

	cuisine 				varchar(25),

	neighborhood 				varchar(25),

	address 				varchar(30),

	phone 					varchar(12),

	description 				varchar(200),

	rating 					number(1,0),

constraint pk_Restaurant primary key(restaurantName));

grant all on Restaurant to public;

create table CustomerReview(

	restaurantName 	varchar(80) not null references Restaurant(restaurantName),

	customerName 				varchar(25),

	review 					varchar(200),

constraint pk_CustomerReview primary key(CustomerName, restaurantName));

grant all on CustomerReview to public;

insert into Restaurant (restaurantName, cuisine, neighborhood, address, phone, description, rating) values ('French Lemon','Mediterranean','Rockridge','1200 College Avenue','510 888 8888','Very nice spot.',5);

insert into Restaurant (restaurantName, cuisine, neighborhood, address, phone, description, rating) values ('Bay Fox','Mediterranean','Piedmont','1200 Piedmont Avenue','510 888 8888','Excellent.',5);

insert into CustomerReview (restaurantName, customerName, review) values ('French Lemon','Fred','Nice flowers.');

insert into CustomerReview (restaurantName, customerName, review) values ('French Lemon','Ralph','Excellent service.');

commit;