Database Development

Question 1

How do you do a UPDATE query?

Answer 1

UPDATE Tutor Group
SET Room = ‘D15’
WHERE TGCode = ‘TG5’;

Question 2

How do you do an INSERT query?

Answer 2

INSERT INTO Result (StudentNo, AssessmentCode, Mark, AssessmentDate)
VALUES (‘101237’,’X216’,’99’, ‘2016-10-23’);

Question 3

How do you do a DELETE query?

Answer 3

DELETE FROM Result WHERE Result.StudentNo = “101237”

Question 4

How do you do a SELECT query?

Answer 4

SELECT Assessment.AssessmentType, Assessment.Title, Assessment.Marks
FROM Assessment
WHERE Assessment.AssessmentType = “Multiple Choice” AND Assessment.Marks <=100
ORDER BY Assessment.AssessmentType DESC, Assessment.Title ASC;

Question 5

What are the two possible participations of an entity in an ER diagram?

Answer 5

Mandatory, Optional