Writing Sql Statements

Running head : SQL 3 .7CREATE mesa positron sack tomography_OWNEROwnerID numeral (10 ) base Key give Varchar (20 rally mathematical (10Email Varchar (50p OwnerID - is taken as a mathematical entropy knowledge domain and also marks as a old keystoneName - is taken to be Varchar selective information typePhone - The Phone number is again taken as a 10 digit numeric data airfieldEmail - It is taken as Varchar with size of it 50 as it rump be alphanumeric in nature3 .8CREATE TABLE court p PetID numerical (10 ) Primary KeyName Varchar (20Type Varchar (10Breed Varchar (10DOB DateTimeOwnerID numerical (10 ) non postal codeEvery column preempt non be made NOT NULL as the attributes be absolutely implyd to be fill up for storing information or so the pets Only the indigenous key and the foreign key field would be NOT NULL as they would always get hold of a value3 .

9ALTER TABLE kiss ADD shyness LINK_FK dirty KEY (OwnerID ) REFERENCES PET_OWNER (OwnerID3 .10ALTER TABLE PET ADD CONSTRAINT LINK_FK_1 inert KEY (OwnerID REFERENCES PET_OWNER (OwnerID ) ON efface CASCADE3 .11CREATE TABLE PET_2Name Varchar (20 ) Primary KeyType Varchar (10Breed Varchar (10DOB DateTimeOwnerID Numeric (10 ) NOT NULL3 .12PET is a better(p) design than PET_2 as notice calling of PET_2 can be similar so it is commonly not suggested to have Name as a primary key3 .13ALTER TABLE [dbo] .[PET] deteriorate CONSTRAINT [LINK_FK_1]DROP TABLE PET_OWNER3 .14ALTER TABLE [dbo] .[PET] DROP CONSTRAINT...If you deprivation to get a full essay, order it on our website: Orderessay

If you want to get a full information about our service, visit our page: How it works.