Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please answer ASAP. Answer the following questions based on the CLIENT and ORDER tables: CLIENT Clientid 1 2 3 LastName Jason Smith Wagner Blake Jones

image text in transcribed

image text in transcribed

please answer ASAP.

Answer the following questions based on the CLIENT and ORDER tables: CLIENT Clientid 1 2 3 LastName Jason Smith Wagner Blake Jones 4 5 6 FirstName Rita Jackson James Susan Tania Karina Max Liam Noah James Suburb Bella Boulevard High Park Richmond Rockdale Como Dural High Park Crasspark Elwood Hawthrone Phone 3432422 5535333 4425253 5141412 5474574 1231241 4574774 1312425 6746236 1235636 City Sydney Sydney Perth Brisbane Melbourne Sydney Perth Brisbane Melbourne Darwin Lynn 7 8 Walters Poplar Robb Henlon 9 10 ORDER Order No Order Desc Clientld Order Date shippedDate Country 3 2 17895 21678 22456 24562 34764 4 Large Item Small Item Item ABC Medium Item 3 Tier Design Round Box Brand-005 Express Delivery 2 12/10/18 05/01/19 10/03/19 26/12/19 18/07/20 22/09/20 22/09/20 11/11/20 16/10/18 09/01/19 12/03/19 27/12/19 20/07/20 27/09/20 24/09/20 14/11/20 Total Amount 200.50 300.00 400.75 150.00 370.60 190.85 216.75 625.00 Australia Italy France Australia Japan Australia China Denmark 36533 36536 37454 noom 1 Questions: 1. Write CREATE and INSERT statements for the above tables and identify constraints. Make sure that primary key, foreign key, not null and other constraints are included in the table creation scripts

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

Recommended Textbook for

Professional Visual Basic 6 Databases

Authors: Charles Williams

1st Edition

1861002025, 978-1861002020

More Books

Students also viewed these Databases questions