Question
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
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);
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started