Answered step by step
Verified Expert Solution
Question
1 Approved Answer
create table supplier(S_NO int identity(1,1), SUP_ID varchar(50) primary key,SUP_NAME varchar (50), SUP_ADD varchar (50), SUP_NIC int, rank int) create table Product(Prod_ID varchar(50) primary key,Prod_Name varchar(50),[Price/Unit]
- create table supplier(S_NO int identity(1,1), SUP_ID varchar(50) primary key,SUP_NAME varchar (50), SUP_ADD varchar (50), SUP_NIC int, rank int)
- create table Product(Prod_ID varchar(50) primary key,Prod_Name varchar(50),[Price/Unit] float)
- create table Orders(Ord_ID varchar(50) primary key,Prod_ID varchar(50),Qty int,Totalrate int,SUP_ID varchar (50))
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