Database

Gino January 26, 2012 Database HW4 7. CREATE TABLE pamper_OWNER( OwnerIDInt non trivial 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 positron emission tomography( PetIDIntNOT NULL, NameChar(50)NOT NULL, TypeChar(25)NOT NULL, BreedChar(25)NOT NULL, DOBText(10)NULL, simplicity pet_PKPRIMARY KEY(PetID), timidity PET_PET_OWNER_FK FOREIGN KEY(PET OWNER) REFERENCES PET_OWNER(OwnerID) ; The DOB is null, because commonwealth might not do it their pets birthday. 9. CONSTRAINT PET_PET_OWNER_FKFOREIGN KEY(PET_OWNER) REFERENCES PET_OWNER(OwnerID) ON delete NO ACTION 10. . CONSTRAINT PET_PET_OWNER_FKFOREIGN KEY(PET_OWNER) REFERENCES PET_OWNER(OwnerID) ON efface descend 11. CREATE TABLE PET_2( NameChar(50)NOT NULL, TypeChar(25)NOT NULL, BreedChar (25)NOT NULL, DOBText(10)NULL, CONSTRAINT PET_PET_OWNER_FK FOREIGN KEY(PET OWNER) REFERENCES PET_OWNER(OwnerID) ; 12. Pets is a give way design than Pet_2, because Pet gives for each one pet an ID. 13. fox 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 congener using SQL INSERT ex. INSERT INTO assignment VALUES (10,1,30) The values of existi! ng data can be limited using update 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 clause 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