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
- Fall '08
- Entity-relationship model, entity, Zellerbach Hall