CEIS 236 Module 2 Course Project Jaspreet Talwar.docx - CEIS 236 Module 2 Course Project select from assignment select from employee select from job

CEIS 236 Module 2 Course Project Jaspreet Talwar.docx -...

This preview shows page 1 - 7 out of 11 pages.

CEIS 236 Module 2 Course Project select * from assignment; select * from employee; select * from job;
Image of page 1
CEIS 236 Module 2 Course Project select * from project; Problem 1
Image of page 2
CEIS 236 Module 2 Course Project Write the SQL code required to list the employee last name, first nameof all employees whose middle initialisK. Problem 2 Write the SQL code required to list the employee number, last name, first name, and middle initial of all employees whose last names start with Smith. In other words, the rows for both Smith and Smithfield should be included in the listing. Sort the results by employeenumber.
Image of page 3
CEIS 236 Module 2 Course Project Assume case sensitivity. Problem 3
Image of page 4
CEIS 236 Module 2 Course Project Write the SQL code to insert a newrecord to employee table:employee number: 119; last name: Wellman;first name: Bill; Middle Initial: K; employee hire date: 1996-02-12; Job Code: 501; emp years: 8 Problem 4
Image of page 5
CEIS 236 Module 2 Course Project Write the SQL code to update the newly added employee Bill Wellman’s Job Code to506. Problem 5 Write the SQL code to remove the newly added employee Bill Wellman.
Image of page 6
Image of page 7

You've reached the end of your free preview.

Want to read all 11 pages?

  • Fall '19
  • Decimal, Personal name, Family name, Given name, Arabic name

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes