Consider the following database tables. Employee (empNo, empName, street, city) Works (empNo, companyName, joiningDate, salary, deptNo) Employee salary (empNo, basic, total_deduction, net salary, gross_salary) Note that empNo is generated using a sequence Write a PL/SQL code to calculate and then print the total gross salary of first 10 records in Employee table.

Consider the following database tables. Employee (empNo, empName, street, city) Works (empNo, companyName, joiningDate, salary, deptNo) Employee salary (empNo, basic, total_deduction, net salary, gross_salary) Note that empNo is generated using a sequence Write a PL/SQL code to calculate and then print the total gross salary of first 10 records in Employee table.

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter9: Joining Data From Multiple Tables

Section: Chapter Questions

Problem 10HOA: An EMPLOYEES table was added to the JustLee Books database to track employee information. Display a...

See similar textbooks

Similar questions

An EMPLOYEES table was added to the JustLee Books database to track employee information. Display a list of each employee’s name, job title, and manager’s name. Use column aliases to clearly identify employee and manager name values. Include all employees in the list and sort by manager name.
Assume the e-commercial database shown in the Appendix. Write the following queries in (a) relational algebra and (b) SQL. State your assumptions if the semantics is not clear. 1) Find the names of all students who have not taken any courses. APPENDIX STUDENTS(student id, first_name, last _name, email, major_code, class_year) COURSES(course id, course_name, course_description, credits, department_code) ENROLLMENTS(student id, course id, semester, grade) MAJORS(major code, major_name, department_code) DEPARTMENTS(department code, department_name)
How does the SQL ORDER BY clause work, and why might it be important when using database functions like MAX() or MIN()? Provide a query illustrating its usage.
Using the relational database given in lab work no. 2, write the following queries in SQL: 7) How many different instructors taught the “Computer Programming” course at least two times?8) Which instructor taught the “Object-Oriented Programming” course the most time?You should also present the output of each query in the lab report. =========================================== The relational database schemas are as follows:department(dept-name, building, budget)instructor(ID, name, dept-name, salary)student(ID, name, dept-name, tot-cred)advisor(s-ID, i-ID)course(course-id, title, dept-name, credits)teaches(ID, course-id, sec-id, semester, year)takes(ID, course-id, sec-id, semester, year, grade)classroom(building, room-number, capacity)time-slot(time-slot-id, day, start-time, end-time)section(course-id, sec-id, semester, year, building, room-number, time-slot-id)prereq(course-id, prereq-id)
Assume the e-commercial database shown in the Appendix. Write the following queries in (a) relational algebra and (b) SQL. State your assumptions if the semantics is not clear. 1) Find the names of all students who have taken courses in both the Computer Science and Mathematics departments. APPENDIX - You may detach this page from the exam: STUDENTS(student id, first_name, last _name, email, major_code, class_year) COURSES(course id, course_name, course_description, credits, department_code) ENROLLMENTS(student id, course id, semester, grade) MAJORS(major code, major_name, department_code) DEPARTMENTS(department code, department_name)
In Sql These are some database from a set of tables insert into AccountHolder(AccountID, CustomerID, AccountType)values (55003, 115, 'Savings'),(44001, 101, 'Chequing'),(55006, 109, 'Savings'),(44002, 102, 'Chequing'),(44003, 113, 'Chequing'),(55007, 108, 'Savings'),(44004, 103, 'Chequing'),(44005, 110, 'Chequing'),(55005, 112, 'Savings'),(44006, 114, 'Chequing'),(55001, 111, 'Savings'),(44007, 107, 'Chequing'),(44008, 104, 'Chequing'),(55004, 106, 'Savings'),(44009, 105, 'Chequing'),(44010, 113, 'Chequing'),(55002, 107, 'Savings'),(44011, 110, 'Chequing'),(44012, 104, 'Chequing') select * from AccountHolder insert into Branch(LocationID, BranchName, Address, Type, DepositSum, LoanSum)values (1, 'Boulevard Branch', '3268 Wade Boulevard', 'Rural', 171848.88, 37681.72),(2, 'Avenue Branch', '4814 Dare Avenue', 'Rural', 232707.42, 68324.56),(3, 'Street Branch', '208 Ferry Street', 'Commercial', 375010.75, 44665.08),(4, 'Road Branch', '468 Zulauf Road', 'Commercial', 496001.41,…
Answer the given question with a proper explanation and step-by-step solution. Using SQL Server and the AdventureWorks2012 Database to create Multi table queries. A) Write a query to find out how many products had a scrapped quantity greater than 20 and an order quantity greater than 2000. List the Product ID, Product Name, Product Number, Work Order ID, Order Quantity, Scrapped Quantity, and Scrap Reason ID. Sort by Scrapped Quantity, and then by Product ID. Use the Production.Product and the Production.Workorder tables. B) Write a query to find out how many Vista credit cards expire in 2008 or more recent (2009, 2010, etc.) from customer 11151, 11223, and 11750. List the Credit Card ID, Card Type, Card Number, Expiration Month, Expiration Year, Sales Order ID, and Customer ID. Order by Customer ID. Use the Sales.Creditcard and Sales.SalesOrderHeader tables
Use Microsoft SQL Server Management Studio for this practical i. Create a database called ‘ORG’ ii. create and populate the following tables: First table CREATE TABLE Worker (WORKER_ID INT NOT NULL PRIMARY KEY, FIRST_NAME CHAR(25), LAST_NAME CHAR(25), SALARY INT, JOINING_DATE DATETIME, DEPARTMENT CHAR(25) ); 2INSERT INTO Worker (WORKER_ID, FIRST_NAME, LAST_NAME, SALARY, JOINING_DATE, DEPARTMENT) VALUES (001, 'Monika', 'Arora', 100000, '2014-02-20 09:00:00', 'HR'),(002, 'Niharika', 'Verma', 80000, '2014-06-11 09:00:00', 'Admin'),(003, 'Vishal', 'Singhal', 300000, '2014-02-20 09:00:00', 'HR'),(004, 'Amitabh', 'Singh', 500000, '2014-02-20 09:00:00', 'Admin'),(005, 'Vivek', 'Bhati', 500000, '2014-06-11 09:00:00', 'Admin')); Second table CREATE TABLE Bonus (WORKER_REF_ID INT,BONUS_AMOUNT INT,BONUS_DATE DATETIME,FOREIGN KEY (WORKER_REF_ID) REFERENCES Worker(WORKER_ID)); INSERT INTO Bonus (WORKER_REF_ID, BONUS_AMOUNT, BONUS_DATE) VALUES(001, 5000, '2016-02-20'),(002, 3000,…
Question 10 Distinguish between SQL views and SQL entities
Having the following table structure (see image). Write MYSQL for: (4) Which students (student first name, student last name) have taken the course “Database Systems”? (5) List all students (student first name, student last name) who have taken both “Database Systems” and “C++”. (6) List all students (student ID, student first Name, student last Name) and the courses (course name, course grade) that they have taken. If there are students who have not taken any course yet, the query result should reflect that (i.e. null for courseName, null for grade). (7) Find all students who have taken computer science courses (i.e. course codes CS***). For the result, list student first name, student last name, and the computer science course names that they have taken.
Q1/ Consider the fruit database with fruit and market tables, where the primary keys are underlined. Give an expression in SQL for each of the following queries. Fruit(ID, fruit_name, fruit_color, price_KG) Market(market name, city, street, fruit_name) 1- Find the names of all red fruits ordered by price 2- Find the names of markets that sell banana in Atlanta city

Recommended textbooks for you

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

A Guide to SQL

Computer Science

ISBN:

9781111527273

Author:

Philip J. Pratt

Publisher:

Course Technology Ptr

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

A Guide to SQL

Computer Science