Attaching a file for assignment using MYSQL Server 2012. Appreciate all the fantastic assistance you have provided. It has kept me from failing this course since the instructor doesn't do any teaching in an online course we are suppose to be able to figure everything out from the book. Just doesn't work that way for everybody. Thank you in advance for all your assistance. I've learned more from using your coding and seeing how and why each query runs than I ever would have from the book.

Thanks,

 

Dale

 

 

CPT 242SQL Assignment 6 – Creating and modifying tablesBefore you start on this assignment you need to create a new Database using the commands belowUseMasterGoIFDB_ID('MytestDb')ISNOTNULL--check to see if the database existsDROPDATABASEmytestdb;-- if it does drop the databaseGOCreateDatabaseMyTestDB;--Creates the databaseGoUseMyTestDB-- makes the database the active databaseGoQuestion 1.Using SQL create table command, create the zipcodetable with the following field names anddatatypes/sizesTable:ZipCodeColumnDatatype/SizeConstraintsZipCodeVarchar(10)Not nullCityVarchar(20)StateCodeVarchar(2)Question 2.Establish ZipCode as the primary key of the Zipcode table.Use ALTER TABLEADD CONSTRAINT for this purpose.Question 3.Using SQL create table command, create the customer tableTable:CustomerColumnDatatype/SizeConstraintsCustomerIDIntegerPrimary KeyCustomerNameVarchar(30)AddressVarchar(30)ZipCodeVarchar(10)Foreign key reference to the zipcode table.CreditLimitMoneyBalanceMoneyQuestion 4.Using SQL create table command, create the Orders tableTable:OrdersColumnDatatype/SizeConstraintsOrderIDIntegerPrimary KeyOrderDateDateCustomerIDIntegerForeign key reference to the Customer table.Question 5.Using SQL create table command, create the Products table

• 1495520717-SQL Assignment 6.pdf

ComputerScienceExpert

(11)

Status NEW Posted 23 May 2017 06:05 AM My Price 9.00

-----------

Attachments

file 1495520718-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer