SQL queries for ITD640_B database
Not what you're looking for?
Create the following queries on the attached ITD640_B database and save them all in a file called ITD640_P5.SQL . Remember to define what database to use with a USE statement.
- Using a join, get the full details of all the employees who are working on the Harvest Ball promotion.
- Get the promotion names (duplicates eliminated) being worked on by employees from the Rocky Mountain Produce store.
- Get the last names of all the employees who are working on promotion P1.
- Get the employee numbers and start dates of all the employees with start dates equal to the earliest date.
- Insert yourself in the employee table using the last five digits of your phone number as the employee number and show yourself as working for Rocky Mountain Produce. Then show all the records in the employee table.
- Delete yourself from the employee table by matching your employee number, and then show all of the records in the employee table.
Purchase this Solution
Solution Summary
Specific SQL queries for ITD640_B database working with Employee and Store tables. Below is a sample:
--Get the last names of all the employees who are working on promotion P1.
SELECT employee.employee_lname
FROM summary
JOIN employee ON summary.employee_no = employee.employee_no
WHERE summary.promotion_no = 'P1'
Solution Preview
Please find attached the sql script. You will need to modify the part with Insert and Delete of ...
Purchase this Solution
Free BrainMass Quizzes
Basic UNIX commands
Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.
C# variables and classes
This quiz contains questions about C# classes and variables.
Word 2010: Tables
Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.
Excel Introductory Quiz
This quiz tests your knowledge of basics of MS-Excel.
Inserting and deleting in a linked list
This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.