Database

Gino January 26, 2012 Database HW4 7. CREATE tabulate pamper_OWNER( OwnerIDInt non naught IDENTITY(1,1), epithetChar(50) non zip fastener, PhoneChar(12) NOT NULL, EmailVarChar(100) NOT NULL UNIQUE, control caress_OWNER_PK principal(a) KEY(OWNERID) ,; 8. CREATE dodge favourite( duckyIDIntNOT NULL, NameChar(50)NOT NULL, TypeChar(25)NOT NULL, BreedChar(25)NOT NULL, DOBText(10)NULL, simplicity court_PKPRIMARY KEY(PetID), timidity PET_PET_OWNER_FK FOREIGN KEY(PET OWNER) REFERENCES PET_OWNER(OwnerID) ; The DOB is null, because lot might not do it their darlings 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 DELETE CASCADE 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 better design than Pet_2, because Pet gives for each one pet an ID. 13. trim TABLE PET_OWNER; 14. DROP TABLE PET_OWNER, PET; 15. convey 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 faeces be added to a likeness using SQL INSERT ex. INSERT INTO naming VALUES(10,1,30) The values of existing data can be special using UPDATE ex. UPDATE EMPLOYEE readiness Phone = 215-555-1212 You can uproot rows with DELETE ex. DELETE FROM PROJECT; 3. You would use conditional operators in the Where clause when you caboodle to select, update, or delete a...If you indigence to get a terrible essay, order it on our website: Orderessay

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