This preview shows page 1. Sign up to view the full content.
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