Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Get all LAST_NAME values from the CUSTOMERS table, do not include duplicates in the output. Question 2 (1 point) Review the SQL below, it

Get all LAST NAME values from the CUSTOMERS table, do not include duplicates in the output. Question 2 (1 Question 3 (1 point) Review the SQL below, it has one syntax error. Rewrite just the line containing the Question 5 (1 point) Review the SQL below, it has one syntax error. Rewrite just the line containing the

Get all LAST_NAME values from the CUSTOMERS table, do not include duplicates in the output. Question 2 (1 point) Review the SQL below, it has one syntax error. Rewrite just the line containing the error including the correction. 1 USE DB; 12 2 DELIMITER $$ 3 4 5 6 7 8 098 9 10 CREATE TRIGGER professor delete BEFORE DELETE ON professor FOR EACH ROW BEGIN INSERT INTO professor_audit_trail ProfessorName = OLD. ProfessorName, ProgramName = OLD. Professor Program; END$$ Question 3 (1 point) Review the SQL below, it has one syntax error. Rewrite just the line containing the error including the correction. 11 12 13 HULIH 14 345 15 17 Question 4 (1 point) Review the SQL below, it has one syntax error. Rewrite just the line containing the error including the correction. 18 use DB; create view computer science students SELECT * FROM student computer science students where Student Program = 'Computer Science! ; USE DB; create index Student Program from student (Student Program); Question 5 (1 point) Review the SQL below, it has one syntax error. Rewrite just the line containing the error including the correction. 20 use DB; 21 create table professor_audit_trail ( 22 id int unsigned primary key auto_increment not null, ProfessorName VARCHAR (255) not null; 24 ProgramName VARCHAR (255) not null 23 25 NETI Question 6 (1 point) Review the SQL below, it has one syntax error. Rewrite just the line containing the error including the correction. 26 W W WNNN 069OHN 27 Use DB; SELECT * 29 FROM student 28 30 ); 31 32 left join professor where student Student Program= professor. Professor Program A/

Step by Step Solution

There are 3 Steps involved in it

Step: 1

Sure lets go through each of the SQL statements and correct any syntax errors present For Question 2 ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Systems analysis and design

Authors: kenneth e. kendall, julie e. kendall

8th Edition

135094909, 013608916X, 9780135094907, 978-0136089162

More Books

Students also viewed these Databases questions

Question

Define what an actor is in a use case diagram.

Answered: 1 week ago