Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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 constraints

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

Students also viewed these Databases questions