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:
order_ID (5 alpha numeric characters)
client_ID (5 alpha numeric characters)
product_name (50 alpha numeric characters and not null)
product_price(5 numeric characters and 2 decimals greater than zero)
Define order_ID as primary key
Define client_ID as foreign key to clients, column ID.
 Write the SQL Code (DDL) to create a table named "orders"

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!