Reference no: EM133852062
LAB EXERCISE 1
Database Systems
Instruction:
In this lab exercise, you are required to construct SQL statements to perform data selection within the Northwind database, which was provided in Tutorial 3.
In this lab exercise, you must provide solutions for 5 tasks listed below. Your submission should be in an MS Word document and include the following:
A cover page.
Solutions for each of the 5 tasks. Each solution must include three parts:
SQL Statement: The query written in plain text.
Explanation: A brief explanation of how the SQL statement works (approximately 150 words).
Screenshot of Results: A screenshot showing the result of running the SQL statement on your computer.
Task 1:
Construct an SQL statement to retrieve the names and postal codes of all customers who are located in London.
Task 2:
Construct an SQL statement to find the total number of orders placed by each customer. Display the customer ID and the total count of orders.
Task 3:
Construct an SQL statement to find all employees who were hired after January 1, 2010. Display their employee ID, name, and hire date.
Task 4:
Construct an SQL statement to retrieve the names of customers and the names of the products they have ordered. The result should display the customer name and the corresponding product name. Get expert online assignment help in the USA now!
Task 5:
Construct an SQL statement to retrieve the names of employees and the territories they manage. The result should display the employee's first name, last name, and territory description.
In this lab exercise, you must provide solutions for 5 tasks listed below. Your submission should be in an MS Word document and include the following:
A cover page
Solutions for each of the 5 tasks. Each solution must include three parts:
SQL Statement: The query written in plain text.
Explanation: A brief explanation of how the SQL statement works (approximately 150 words).
Screenshot of Results: A screenshot showing the result of running the SQL statement on your computer.
LAB EXERCISE 2
Task 1:
Construct a SQL statement that retrieves the titles of movies that have not been rented yet.
Task 2:
Construct a SQL statement that displays the member ID and name of the members who have rented at least one movie released in the same year they started their membership.
Task 3:
Construct a nested SQL statement using the NOT EXISTS function to display the names and addresses of members who have not rented any movies.
Task 4:
Construct a nested SQL statement using the EXISTS function to display members (memberID, name, address) who have rented movies from a specific genre ‘Action'.
Task 5:
Construct a nested SQL statement using the EXISTS function to display members (memberID, name, email) who have rented movies released in the last 6 months in 2024.
|
Describe your experience with a payroll software system
: Describe your experience with a payroll software system and the sepecification of the remote work enviroment? How would you trouble shoot with these systems?
|
|
Which age-related factor supports the nurses actions
: Before providing care for older adult the nurse washes their hands to decrease the chance of infection. Which age-related factor supports the nurse's actions?
|
|
Explain the plan to control the risk of failure
: Explain the plan to control the risk of failure to maintain first aid kit using standard operating procedures and training in nsw Australia.
|
|
What is a combined heat transfer coefficient
: Explain what a combined heat transfer coefficient is, and how it is used. Show any equations necessary to explain, and name all the terms in these equations.
|
|
Construct an sql statement to find all employees
: Construct an SQL statement to find all employees who were hired after January 1, 2010. Display their employee ID, name, and hire date.
|
|
Describe the key marketing principles
: Describe the key marketing principles and how these apply to APPLE INC chosen organisation.
|
|
Identify goals of counter-proliferation instrument selected
: Construct a presentation by selecting two of the four counter-proliferation instruments (i.e., strategies, treaties, conventions, and conferences).
|
|
What is the checkout and discharge process of the ehr
: What is enterprise master patient index? In your response provide two similarities and two differences. What is the checkout and discharge process of the E.H.R.
|
|
Construct a nested sql statement using the exists function
: Construct a nested SQL statement using the EXISTS function to display members (memberID, name, email) who have rented movies released in the last 6 months
|