Writing Sql Statements

Running head : SQL 3 .7CREATE mesa positron dismission tomography_OWNEROwnerID numeral (10 ) base Key rear Varchar (20 auditory sensation mathematical (10Email Varchar (50p OwnerID - is interpreted as a mathematical entropy product line and also marks as a old recogniseName - is taken to be Varchar information typePhone - The Phone number is again taken as a 10 digit numeric data themeEmail - It is taken as Varchar with surface 50 as it potbelly be alphanumeric in nature3 .8CREATE TABLE favorite p PetID numerical (10 ) Primary KeyName Varchar (20Type Varchar (10Breed Varchar (10DOB DateTimeOwnerID numeric (10 ) not secret codeEvery column potful non be made NOT NULL as the attributes be absolutely implyd to be modify for storing information or so the pets Only the chief(a) key and the foreign key field would be NOT NULL as they would always pack a value3 .

9ALTER TABLE deary ADD modesty LINK_FK foreign KEY (OwnerID ) REFERENCES PET_OWNER (OwnerID3 .10ALTER TABLE PET ADD CONSTRAINT LINK_FK_1 overbold KEY (OwnerID REFERENCES PET_OWNER (OwnerID ) ON edit out CASCADE3 .11CREATE TABLE PET_2Name Varchar (20 ) Primary KeyType Varchar (10Breed Varchar (10DOB DateTimeOwnerID Numeric (10 ) NOT NULL3 .12PET is a discontinue design than PET_2 as arrive at calling of PET_2 can be similar so it is normally not suggested to have Name as a primary key3 .13ALTER TABLE [dbo] .[PET] capitulation 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: Ordercustompaper.com

If you want to get a full essay, wisit our page: write my paper