WHAT IS THE ERROR AND FIX IT PLEASE :

create table Customer(custmer_id int primary key,
name varchar2 ( 100) ,
phone_number number unique,
address varchar2 (250) );

create table Order_line(agent_id int primary key ,
address varchar2(200));

create table order_o( order_id int primary key ,
foreign key (agent_id) references order_line(agent_id),
foreign key (customer_id) references customer(customer_id) ,
day date , quantity number );

create table Payment(payment_id int primary key ,
foreign key (order_id) references order_o(order_id),
foreign key (customer_id) references customer(customer_id) ,
typeOfPayment varchar2(100));

create table product(product_id int primary key ,
foreign key (order_id) references order_o(order_id));

create table Wearhouse(Location varchar2 primary key ,
foreign key (product_id)references product(product_id),
quantity number);

Answer rating: 100% (QA)

n the Customer table creation statement theres a typo in custmerid instead of customerid In the Orde... View the full answer