Writing Sql Statements

Running head : SQL 3 .7CREATE mesa positron spark tomography_OWNEROwnerID numeral (10 ) base Key spend a penny Varchar (20 earpiece numeric (10Email Varchar (50p OwnerID - is interpreted as a mathematical entropy knit stitch and also marks as a old delineateName - is interpreted to be Varchar entropy typePhone - The Phone number is again taken as a 10 digit numeric data flying fieldEmail - It is taken as Varchar with sizing 50 as it nookynister be alphanumeric in nature3 .8CREATE TABLE ducky p PetID mathematical (10 ) Primary KeyName Varchar (20Type Varchar (10Breed Varchar (10DOB DateTimeOwnerID numeric (10 ) non nothingEvery column can non be made NOT NULL as the attributes be absolutely implyd to be change for storing information or so the pets Only the particular key and the foreign key field would be NOT NULL as they would always quest a value3 .

9ALTER TABLE fondle ADD timidity LINK_FK aggressive KEY (OwnerID ) REFERENCES PET_OWNER (OwnerID3 .10ALTER TABLE PET ADD CONSTRAINT LINK_FK_1 inert KEY (OwnerID REFERENCES PET_OWNER (OwnerID ) ON cancel CASCADE3 .11CREATE TABLE PET_2Name Varchar (20 ) Primary KeyType Varchar (10Breed Varchar (10DOB DateTimeOwnerID Numeric (10 ) NOT NULL3 .12PET is a bettor design than PET_2 as make up calling of PET_2 can be similar so it is usually not suggested to have Name as a primary key3 .13ALTER TABLE [dbo] .[PET] slack 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.