Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please I need it urgent thank You have a customer table called CUSTOMERS and an order table called ORDERS: CustomerID 123 234 301 345 etc
please I need it urgent thank
You have a customer table called CUSTOMERS and an order table called ORDERS: CustomerID 123 234 301 345 etc CustomerName CustomerCit Alpine Co Zebra Inc H & M Nonce & Co Brookl Aspen Brookl Wilson CustomerState NY CO NY PA OrderNum CustomerID OrderDate OrderAmount HasItBeenPaid A111 A156 A211 A213 345 345 123 345 02/12/2013 5000.00 03/11/2013 4000.00 02/17/2013 6000.00 12/11/2013 3000.00 etc Using these tables, write one or more SQL statements for each of the following: a. Write the create table (DDL) statement for the CUSTOMERS table. Show all integrity constraintsStep 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