Unformatted text preview: c. [4 points] The fol owing DDL SQL statement creates the table to store the “includes” relationship from the original ER diagram. Fil in the missing details, so that it captures the constraints that the ER diagram represents. CREATE TABLE includes ( id INTEGER, name VARCHAR(20), composer VARCHAR(20) -1 PRIMARY KEY ( id, name, composer ), -1 FOREIGN KEY(id) REFERENCES Performance -1 FOREIGN KEY(name, composer) REFERENCES Composition -1 ); Name_________________________________________- 7 -...
View Full Document
This note was uploaded on 08/30/2009 for the course CS 186 taught by Professor Staff during the Fall '08 term at Berkeley.
- Fall '08