Question: Consider the following relational schema: Person (pid integer, name: string) Owns (pid integer, cid integer cost: real) Cat (cid integer, cat Name: string, age: integer)
Consider the following relational schema: Person (pid integer, name: string) Owns (pid integer, cid integer cost: real) Cat (cid 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 = cost >= 0) none of these CHECK (0 = 0 AND cost = 0 AND cost
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
