Question: 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 ,

 create table Customer(custmer_id int primary key, name varchar2 ( 100) ,

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), foreign key (agent_id) references Customer(custmer_id));

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);

please fix error

Table created. Table created. ORA-60904: "AGENT_ID": invalid identifier ORA-60904: "ORDER_ID": invalid identifier ORA-60964: "ORDER_ID": invalid identifier ORA-60906: missing left parenthesis

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!