Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
Project
Complete the following queries using HR Schema. Submit your answer in the form of a SQL text file to the Final Project Dropbox.
1. Show first name, last name, start date and end date for all employees. The dates come from the job_history table. Note a correct answer should return 10 records.
2. Show first name, last name, department of all of the employees with no job history.
3. Show first name, last name, department of the employees in the department with the most people. Note - this query will likely involve nested subqueries.
4. Delete the Recruiting department from the departments table.
5. Add yourself as a new employee to the data employees table.
Write the statement which creates table named Part, with Id field as an int idendity PK, a SupplierId int field, a Description string field of size 25, a Count int field, a Class string field
Use the data on the Christensen worksheet in the range A1:J19 to create a PivotChart on a new sheet. Use the Type, Issue Price, and Est. Value fields and the default locations. Find the average issue price and average estimated value.
Run the lab_03_01.sql script in the attached file to create the SAL_HISTORY table. Display the structure of the SAL_HISTORY table.
Assume an IT technician was working on your machine because they needed to fix something in your account, and you shared your credentials with them so they could do their work.
Consider the following SQL query over tables R(A), S(A), and T (A). Note that "Select Distinct" in SQL represents a duplicate-eliminating projection.
Combine the two diagrams make a visio ERD with Primary and Foreign keys.
Using PL/SQL populate the SALES_FACTS table. One way to do this is to use four nested cursor loops to get every possible combination of the dimension tables' primary keys and then the total vehicles sold and gross sales amount for each combinatio..
Write an SQL statement to produce a single column called ItemLocation that combines the SKU_Description,the phrase "is located in."
Define a one-to-many relationship between the Customer table and Orders table. Right click in the window and select Show table. Select the referential integrity option and both cascade options for the relationships. Save the relationship.
/*Using the STUDENT table in the MISLab1 database in Omnymbus, perform the following tasks: Note the first SELECT is there to label the output, DUAL is a "dummy" table. The second SELECT is the solution.
Write a Query to display the name, department_id of the employee that earns the highest salary in the Employees table.
Please use either Access notation (i.e., one-1, many-∞) or ER modeling notation (i.e., one- , many- )(see slide 3.28) to develop a logical database model for the company.
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd