Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Data Analytics Systems Engineering Cybersecurity Project Management

Authors: Christopher Greco

1st Edition

168392648X, 978-1683926481

More Books

Students also viewed these Databases questions