Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE tblQuestion( QuestionID INT PRIMARY KEY,
- SurveyID INT NOT NULL,
- Question VARCHAR(120) NOT NULL,
- FOREIGN KEY (SurveyID) REFERENCES tblSurvey(SurveyID)
- )
- CREATE TABLE tblAnswer(
- AnswerID INT PRIMARY KEY AUTO_INCREMENT,
- QuestionID INT NOT NULL,
- Answer VARCHAR(120) NOT NULL,
- FOREIGN KEY (QuestionID) REFERENCES tblQuestion(QuestionID),
- )
- CREATE TABLE tblSurvey(
- SurveyID INT PRIMARY KEY,
- Name VARCHAR(120) NOT NULL
- )
Add Comment
Please, Sign In to add comment