Write the following queries in the WPC database and save these queries as Query 15 and...
Write the following queries in the WPC database and save these queries as Query 15 and Query 16 respectively.
- Show the ProjectID, ProjectName, Department, Department Phone for all the projects run by the Finance Department.
- Display EmployeeNumber, FirstName, LastName for employees whose EmployeeNumber is greater than or equal to 3 but less than or equal to 9 and last name contains the phrase “on”.
Homework Answers
A.
Select ProjectID,ProjectName,Depatment,DepartmentPhone from Projects inner join Departments on Projects.DepartmentId = Departments.DepartmentId where Department = 'Finance';
B.
Select EmployeeNumber,FirstName,Lastname from Employees where EmployeeNumber >= 3 and EmployeeNumber <= 9 and LastName LIKE '%on%'
Do ask if any doubt. Please upvote.
Add Answer to:
Write the following queries in the
WPC database and save these queries as Query 15 and...
For this set of Review Questions, we will create and use a database for the Wedgewood...
For this set of Review Questions, we will create and use a database for the Wedgewood Pacific Corporation (WPC) that is similar to the Microsoft Access database we created and used in Chapters 1 and 2. Founded in 1957 in Seattle, Washington, WPC has grown into an internationally recognized organization. The company is located in two buildings. One building houses the Administration, Accounting, Finance, and Human Resources departments, and the second houses the Production, Marketing, and Information Systems departments. The...
Problem 33, chapter 7 from Database Systems 13th edition by Coronel Write a query to display...
Problem 33, chapter 7 from Database Systems 13th edition by Coronel Write a query to display the employee number, last name, email address, title, and department name of each employee whose job title ends in the word “ASSOCIATE.” Sort the output by department name and employee title Problem 36, chapter 7 from Database Systems 13th edition by Coronel Write a query to display the number of products within each base and type combination, sorted by base and then by type...
Using the database: Write SQL queries for each of the questions below. 1. Find the media...
Using the database: Write SQL queries for each of the questions
below.
1. Find the media type which
has 100 or more tracks. Print the name of such media type. Number
of rows returned in the result = 3
A) Find the playlists which have one or more tracks that have
never been purchased in California (CA). Print the Id, and the name
of such playlists. Number of rows returned in the result = 18
B) Find the customers who...
2) Consider the database schema on the relations (where key attributes have been underlined): PROJECTS(Number, Department,...
2) Consider the database schema on the relations (where key attributes have been underlined): PROJECTS(Number, Department, ProjectName) EMPLOYEES(Number, Surname, FirstName, Department) ALLOCATIONSEmplovee, Project, Function, Date) NOTE: relation ALLOCATIONS stores the registration number (attribute Employee) of employees that are assigned to a given project (attribute Project is the number of the project, not the name of the project), the function the employee has in that project (i.e., technician, manager, etc.) and the date when the employee has been assigned to that...
2. SQL queries (40 points total, 5 points each query) Write SQL query statements to query...
2. SQL queries (40 points total, 5 points each query) Write SQL query statements to query the following Hotel Room Booking Database Tables. "cid" is Customer ID. "rid" is Room ID. "bid" is Booking ID. "dob" means Date of Vwwww Birth; "beds" means the number of beds in the room which is normally 1 or 2 beds. "DueDate" and "DueAmount" are the payment due dates and due amounts of this booking. Customers fname name phone email cid dob zipcode Rooms...
EXERCISE Provide working SQL DML statements for the following database schema and queries CUSTOMER (ID, Type,...
EXERCISE Provide working SQL DML statements for the following database schema and queries CUSTOMER (ID, Type, Firstname, Lastname, Address, City) INVENTORY(ID, ItemName, Type, MadeInStore, SupplierName, DailyAverageSold, Price) ORDERS(ID, Customer_FK, Item_FK, Quantity, DeliveryDate) 16. Find the total amount due for each order, where the total is at least $70 . Show: order id, lastname, and total-amount . Hint: variation of previous query 17. Find the total amount due for each order placed by a customer that is a restaurant owner, total...
HELP DATABASE QU Question 1: Think About the relational database table data as given below, write...
HELP DATABASE QU
Question 1: Think About the relational database table data as given below, write the following queries in Oracle SQL. Company (Cid, Cname, City, Budget, Branch) Department (Deptno, Dname, Building, Cname) Employee (Ename, Deptno, Street, City, Phone, Salary) Works (Ename, Deptno, Hire_date) Location (Cname, Location ) 1. Write Query to Create the Company table, suggest appropriate data type of each attribute, consider that there should be a name for each company. 2. Find employee name/names who live in...
Consider EMPLOYEE database. Create the database and run the following queries and write the result you...
Consider EMPLOYEE database. Create the database and run the
following queries and write the result you get.
What would be the result of the following query (please create
the resulting table will all the columns and rows)?
SELECT
D.Dname, E.Lname, P.Pname
FROM
DEPARTMENT D, EMPLOYEE E, WORKS_ON W, PROJECT P
WHERE
D.Dnumber=E.Dno AND E.Ssn=W.Essn AND W.Pno=P.Pnumber
ORDER BY
D.Dname DESC,
E.Lname DESC;
Due date: November 6, 2018 (Tuesday) Problems: 1. Specify the following queries on the database schema...
Due date: November 6, 2018 (Tuesday) Problems: 1. Specify the following queries on the database schema shown in Figure 3.6 using both the tuple relational calculus and the domain relational calculus. You don't need to show the result of each query if applied to the database of Figure 3.6. (a) Retrieve the names of employees in department 5 who work more than 10 hours per week on the 'ProductX' project (b) List the names of employees who have a dependent...
Using HR database solve the following queries: [Use Join concept] List all employee names who are...
Using HR database solve the following queries: [Use Join concept] List all employee names who are living at ‘United Kingdom’ List all the cities of region ‘Asia’ List employee details whose manager lives in Toronto location Display department name located at ‘California’ Display name of the managers whose street address is ‘2011 Interiors Blvd’
Using the database: Write SQL queries for each of the questions
below.
1. Find the media type which
has 100 or more tracks. Print the name of such media type. Number
of rows returned in the result = 3
A) Find the playlists which have one or more tracks that have
never been purchased in California (CA). Print the Id, and the name
of such playlists. Number of rows returned in the result = 18
B) Find the customers who...
2) Consider the database schema on the relations (where key attributes have been underlined): PROJECTS(Number, Department, ProjectName) EMPLOYEES(Number, Surname, FirstName, Department) ALLOCATIONSEmplovee, Project, Function, Date) NOTE: relation ALLOCATIONS stores the registration number (attribute Employee) of employees that are assigned to a given project (attribute Project is the number of the project, not the name of the project), the function the employee has in that project (i.e., technician, manager, etc.) and the date when the employee has been assigned to that...
2. SQL queries (40 points total, 5 points each query) Write SQL query statements to query the following Hotel Room Booking Database Tables. "cid" is Customer ID. "rid" is Room ID. "bid" is Booking ID. "dob" means Date of Vwwww Birth; "beds" means the number of beds in the room which is normally 1 or 2 beds. "DueDate" and "DueAmount" are the payment due dates and due amounts of this booking. Customers fname name phone email cid dob zipcode Rooms...
EXERCISE Provide working SQL DML statements for the following database schema and queries CUSTOMER (ID, Type, Firstname, Lastname, Address, City) INVENTORY(ID, ItemName, Type, MadeInStore, SupplierName, DailyAverageSold, Price) ORDERS(ID, Customer_FK, Item_FK, Quantity, DeliveryDate) 16. Find the total amount due for each order, where the total is at least $70 . Show: order id, lastname, and total-amount . Hint: variation of previous query 17. Find the total amount due for each order placed by a customer that is a restaurant owner, total...
HELP DATABASE QU
Question 1: Think About the relational database table data as given below, write the following queries in Oracle SQL. Company (Cid, Cname, City, Budget, Branch) Department (Deptno, Dname, Building, Cname) Employee (Ename, Deptno, Street, City, Phone, Salary) Works (Ename, Deptno, Hire_date) Location (Cname, Location ) 1. Write Query to Create the Company table, suggest appropriate data type of each attribute, consider that there should be a name for each company. 2. Find employee name/names who live in...
Consider EMPLOYEE database. Create the database and run the
following queries and write the result you get.
What would be the result of the following query (please create
the resulting table will all the columns and rows)?
SELECT
D.Dname, E.Lname, P.Pname
FROM
DEPARTMENT D, EMPLOYEE E, WORKS_ON W, PROJECT P
WHERE
D.Dnumber=E.Dno AND E.Ssn=W.Essn AND W.Pno=P.Pnumber
ORDER BY
D.Dname DESC,
E.Lname DESC;
Due date: November 6, 2018 (Tuesday) Problems: 1. Specify the following queries on the database schema shown in Figure 3.6 using both the tuple relational calculus and the domain relational calculus. You don't need to show the result of each query if applied to the database of Figure 3.6. (a) Retrieve the names of employees in department 5 who work more than 10 hours per week on the 'ProductX' project (b) List the names of employees who have a dependent...
Most questions answered within 3 hours.
-
Which of the following pairs of ions have the same electron
configuration?
I: Br− and Se2−...
asked 29 minutes ago -
The Foremost Composite Materials Company is planning a two-day
sales conference for October 19-20. The conference...
asked 52 minutes ago -
3) Illustrate the observed pattern of relatedness of organisms
versus adaptations to specific conditions. This means...
asked 1 hour ago -
In winter a lake has a 0.35 m thick ice layer over 1.10 m of
water....
asked 2 hours ago -
Assuming the following has been encrypted with a Vigenere cipher
below, use the method(s) and assumptions...
asked 2 hours ago -
How would I use switch statements to write a program that will
take an input of...
asked 2 hours ago -
Imagine a reaction in which methane gas combusts at a constant
pressure of 1 atm and...
asked 2 hours ago -
Two parallel wires (each 12 m in length) are separated by a
distance of 0.065 m...
asked 2 hours ago -
Suppose there were three masses at the corner of uniform
equilateral triangle. The masses are m1...
asked 2 hours ago -
Situation: A building that is 618 m above the ground floor. How
many times would a...
asked 2 hours ago -
help me and discuss one successful and one
unsuccessful international company/busines in Indonesia.whyit
succeed and why...
asked 2 hours ago -
I- Choose the best answer
Which of the following statements about the structure and
packaging of...
asked 2 hours ago