Skip to content

assignment.md

Latest commit

 

History

History
46 lines (28 loc) · 1.11 KB

assignment.md

File metadata and controls

46 lines (28 loc) · 1.11 KB
Raw

Assignment

Brief

Write the SQL statements for the following questions.

Instructions

Paste the answer as SQL in the answer code section below each question.

Question 1

Write the SQL statement to create a unique index on the email column of the students table in the lesson schema.

Answer:

CREATE UNIQUE INDEX students_email_idx ON lesson.students(email);

Question 2

Write the SQL statement to alter the teachers table in the lesson schema to add a new column subject of type VARCHAR.

Answer:

ALTER TABLE lesson.teachers ADD COLUMN subject VARCHAR;

Question 3

Write the SQL statement to update the email of the teacher with the name 'John Doe' to 'john.doe@school.com' in the teachers table of the lesson schema.

Answer:

UPDATE lesson.teachers
SET email = 'john.doe@school.com'
WHERE name = 'John Doe';

Submission

  • Submit the URL of the GitHub Repository that contains your work to NTU black board.
  • Should you reference the work of your classmate(s) or online resources, give them credit by adding either the name of your classmate or URL.