Question: Write the SQL Code ( DDL ) to create a table named orders with the following attributes: order _ ID ( 5 alpha numeric characters
Write the SQL Code DDL to create a table named "orders" with the following attributes:
orderID alpha numeric characters
clientID alpha numeric characters
productname alpha numeric characters and not null
productprice numeric characters and decimals greater than zero
Define orderID as primary key
Define clientID as foreign key to clients, column ID
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
