Question: Consider the following relational schema: Person (pid integer, name: string) Owns (pid integer, cid integer, cost real) Cat (cick integer, cat Name: string, age: integer)
Consider the following relational schema: Person (pid integer, name: string) Owns (pid integer, cid integer, cost real) Cat (cick integer, cat Name: string, age: integer) First assume we will have one table for each of the above A partial statement to create the Owns table appears below. Select the table constraint that we must add in order to ensure that the cost is between 0 and 50: 0 cost >= 0) 000 6: VERIFY cost > 0 AND coat = 0 AND cost 50 Previous Page Page 13 of 13 ce 7: Submit Quis 0 of 13 questions saved B
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
