Database

Gino January 26, 2012 Database HW4 7. CREATE TABLE pamper_OWNER( OwnerIDInt non unimportant IDENTITY(1,1), epithetChar(50) non NULL, PhoneChar(12) NOT NULL, EmailVarChar(100) NOT NULL UNIQUE, control caress_OWNER_PK principal(a) KEY(OWNERID) ,; 8. CREATE TABLE pet( PetIDIntNOT NULL, NameChar(50)NOT NULL, TypeChar(25)NOT NULL, BreedChar(25)NOT NULL, DOBText(10)NULL, simplicity positron emission tomography_PKPRIMARY KEY(PetID), timidity PET_PET_OWNER_FK FOREIGN KEY(PET OWNER) REFERENCES PET_OWNER(OwnerID) ; The DOB is null, because plurality might not do it their pets birthday. 9. CONSTRAINT PET_PET_OWNER_FKFOREIGN KEY(PET_OWNER) REFERENCES PET_OWNER(OwnerID) ON score out NO ACTION 10. . CONSTRAINT PET_PET_OWNER_FKFOREIGN KEY(PET_OWNER) REFERENCES PET_OWNER(OwnerID) ON remove come down 11. CREATE TABLE PET_2( NameChar(50)NOT NULL, TypeChar(25)NOT NULL, Bre edChar(25)NOT NULL, DOBText(10)NULL, CONSTRAINT PET_PET_OWNER_FK FOREIGN KEY(PET OWNER) REFERENCES PET_OWNER(OwnerID) ; 12. Pets is a wear out design than Pet_2, because Pet gives for each one pet an ID. 13. recede TABLE PET_OWNER; 14. DROP TABLE PET_OWNER, PET; 15. SELECT PetID, Name, Type, Breed, DOB, OwnerID FROM PET; 16.

SELECT * FROM PET; 17. SELECTBreed, Type FROM PET; 18. SELECT Breed, Type, DOB FROM PET; WHEREType = Dog 2. Data feces be added to a sex act using SQL INSERT ex. INSERT INTO assignmen t VALUES(10,1,30) The values of! animated data can be limited using modify ex. UPDATE EMPLOYEE SET Phone = 215-555-1212 You can extirpate rows with DELETE ex. DELETE FROM PROJECT; 3. You would use conditional operators in the Where article when you fate to select, update, or delete a...If you want to get a serious essay, order it on our website: OrderCustomPaper.com

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