Unformatted text preview: a. Create an index named BoatIndex on the BoatName field in the MarinaSlip table. CREATE INDEX BoatIndex ON MarinaSlip(BoatName) ; b. Create an index named BoatIndex2 on the OwnerNum field in the MarinaSlip table. CREATE INDEX BoatIndex2 ON MarinaSlip(OwnerNum) ; c. Create an index named BoatIndex3 on the Length and BoatName fields in the MarinaSlip table and list the lengths in descending order. CREATE INDEX BoatIndex3 ON MarinaSlip(Length, BoatName DESC) ; 6. Assume the MarinaSlip table has been created but there are no integrity constraints. Create the necessary integrity constraints so the rental fee must be less than $5,000 and the slip length must be 25, 30, or 40. PRIMARY KEY (RentalFee, Length) SELECT RentalFee, Length FROM MarinaSlip WHERE RentalFee&lt;5000, Length =25, 30, 40 ;...
View Full Document
- Spring '11
- $5,000, 40 feet, MarinaSlip table, Alexamara Marina Group Case