[Solved]-Question 1 Using Sql Create Table Command Create Zipcode Table Following Field Names Datat Q37215042

Question 1. Using SQL create table command, create the zipcodetable with the following field names and datatypes/sizes

Question 2. Establish ZipCode as the primary key of the Zipcodetable. Use ALTER TABLE ADD CONSTRAINT for this purpose.

Question 3. Using SQL create table command, create thecustomertable

Question 4. Using SQL create table command, create the Orderstable

Question 1.Using SQL create table command, create the zipcode table with the following field names and datatypes/sizes Table: ZipCode Column ZipCode City StateCode Data Varchar 10) Varchar 20 Varchar 2 Constraints Not null Question 2.Establish ZipCode as the primary key of the Zipcode table. Use ALTER TABLE ADD CONSTRAINT for this purpose. Question 3.Using SQL create table command, create the customer table Table: Customer Column CustomerID CustomerName Address ZipCode Creditl imit Balance Data Constraints Primary Key Varchar(30 Varchar(30 Varchar(10 Mo Foreign key reference to the zipcode table Question 4. Using SQL create table command, create the Orders table Table: Orders Column OrderID OrderDate CustomerID Data ts Primary Key Date Integer Foreign key reference to the Customer table Show transcribed image text Question 1.Using SQL create table command, create the zipcode table with the following field names and datatypes/sizes Table: ZipCode Column ZipCode City StateCode Data Varchar 10) Varchar 20 Varchar 2 Constraints Not null Question 2.Establish ZipCode as the primary key of the Zipcode table. Use ALTER TABLE ADD CONSTRAINT for this purpose. Question 3.Using SQL create table command, create the customer table Table: Customer Column CustomerID CustomerName Address ZipCode Creditl imit Balance Data Constraints Primary Key Varchar(30 Varchar(30 Varchar(10 Mo Foreign key reference to the zipcode table Question 4. Using SQL create table command, create the Orders table Table: Orders Column OrderID OrderDate CustomerID Data ts Primary Key Date Integer Foreign key reference to the Customer table

Expert Answer

---

Answer to Question 1. Using SQL create table command, create the zipcode table with the following field names and datatypes/sizes … . . .