Part A - SCOTT Schema1. Select all employees in salary grade 2.EMPNO ENAME1 7521 WARDJOBM...Y HIREDATESALCOMMDEPTNOSALESMAN 7698 22-FEB-81 125050014007782 23-JAN-82 1300 (null)302 7654 MARTIN SALESMAN 7698 28-SEP-81 1250303 7934 MILLER CLERK102. Select all employees in salary grade 1 and 3.COMM7902 17-DEC-80 800 (null)300EMPNO ENAMEJOBMGRHIREDATEO SALDEPTNO17369 SMITH CLERK27499ALLEN SALESMAN 7698 20-FEB-81 16003 7844 TURNER SALESMAN 7698 08-SEP-81 15004 7876ADAMS CLERK5 7900 JAMES CLERK307788 23-MAY-87 1100 (null)7698 03-DEC-81 950 (null)20303. Select all employees located in Chicago.EMPNO ENAMEJOBMGRHIREDATESALt COMMDEPTNO1 7499ALLEN SALESMAN 7698 20-FEB-81 1600300302 7521 WARDSALESMAN 7698 22-FEB-81 1250500303 7654 MARTIN SALESMAN 7698 28-SEP-81 12501400304 7698 BLAKE MANAGER 7839 01-MAY-81 2850 (null)5 7844 TURNER SALESMAN 7698 08-SEP-81 15006 7900 JAMES CLERK30307698 03-DEC-81 950 (null)30O0000N3323m

I have written the query below:

EMPNO ENAME JOB M...Y HIREDATE SAL t COMM DEPTNO 1 7521 WARD 2 7654 MARTIN SALESMAN 7698 28-SEP-81 1250 3 7934 MILLER CLERK SALESMAN 7698 22-FEB-81 1250 500 30 1400 7782 23-JAN-82 1300 (null) 30 10 2. Select all employees in salary grade 1 and 3. EMPNO ENAME JOB MGR 8 HIREDATE SAL 8 COMM DEPTNO . 72 CO MTO MIT 700 217 000

EMPNO ENAME JOB M...Y HIREDATE SAL t COMM DEPTNO 1 7521 WARD 2 7654 MARTIN SALESMAN 7698 28-SEP-81 1250 3 7934 MILLER CLERK SALESMAN 7698 22-FEB-81 1250 500 30 1400 7782 23-JAN-82 1300 (null) 30 10 2. Select all employees in salary grade 1 and 3. EMPNO ENAME JOB MGR 8 HIREDATE SAL 8 COMM DEPTNO . 72 CO MTO MIT 700 217 000

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Q # 3. Implement a Tour Planner and Budget Calculator for Holidays. Program will ask the user to enter number of persons and the number of days for the tour. Program will show the menu for tour destination and accommodation options on the screen and ask the user to select the desired options. In budget calculation, destination expense will be multiplied with number of persons and the accommodation expense will be multiplied with number of days. Program will add Rs. 10,000 for Food Expense and Rs. 2500 as miscellaneous expense. Total tour budget will be calculated using the formula shown below: Total Budget = Travel Expense * No. of Persons + Hotel Expense * No. of Days t 10.000 + 2500 (Program should use switch-case statements to get user choice for Destination and Accommodation). Table 1. Destination Expense per person S# Destination Budget Rs. 10,000 Naran-Kaghan Neelum Valley Rs, 12,000 Malam Jabba Rs. 9,500 Rs. 28,000 4 Shangrilla Resort Rs. 5,000 Banjosa Lake
Draw the UML diagram. Account num: 1122Account name: my checking accountBalance: 1100.0 USD4 transactions since created at Thu Jul 06 12:55:20 PDT 2023Account num: 1133Account name: my savings accountBalance: 12000.0 USD2 transactions since created at Thu Jul 06 12:55:21 PDT 2023Account num: 1190Account name: my all money at the bankBalance: 13100.0 USD6 transactions since created at Thu Jul 06 12:55:20 PDT 2023
FIGURE 5.10 MAINTAINING MANAGER HISTORY Current Data EMPLOYEE DEPARTMENT PK EMP NUM PK DEPT ID EMP LNAME HE- manages EMP FNAME EMP INITIAL EMP E_MAIL JOB_CODE EMP SALARY DEPT NAME FK1 EMP NUM DATE ASSIGN EMP MGR_HIST %3 EMP SAL HISTORY Historic Data MGR HIST DEPT MGR_HIST SALARY HIST PK,FK1 PK,FK2 DEPT ID PK EMP NUM PK,FK1 EMP NUM PK DATE ASSIGN SALARY START DATE SALARY_AMT FIGURE 5.11 MAINTAINING JOB HISTORY EMPLOYEE Current Data PK EMP NUM DEPARTMENT EMP LNAME EMP FNAME EMP_INITIAL HE-- EMP E MAIL FK1 DEPT ID JOB CODE DATE_ASSIGN EMP SALARY PK DEPT ID manages DEPT NAME employs H-FK1 EMP_NUM DATE ASSIGN Historic Data JOB HIST DEPT JOB_HIST EMP_JOB HIST PK,FK1 EMP NUM PK,FK2 DEPT ID PK DATE ASSIGN PO JOB_CODE EMP SALARY
Mapping from EER to Relational Model
A Small supermarket employs workers who are paid every week in hourly bases according to one of the following three rates (depending on their positions). Position Type Position Name Hours rate (AED) Admin Al 60 Worker P1 40 3 Worker P2 30
Define Normalization & Normalize the following table to 3rd NF
Who are "accelerated filers," and what factors (such as yearly revenue or number of workers) determine their eligibility?
SQL Help
"Honda Civic (a car) only needs a yearly maintenance not costing more than RM2500" is a .. * functional requirement non functional requirement
Question 4 Say you bought as many whole shares of AMZN stock as you could with $4,383 at the Close price on the first trading day in the month of July each year from 2001 until 2010. How many total shares did you purchase? Your answer should be a whole number.
The spreadsheet contains codes (BA, DA, SA) to represent agent roles (Buyer's Agent, Dual Agent, Seller's Agent). You want to switch the codes for the actual descriptions. In cell E12 of the Details sheet, insert the SWITCH function to evaluate the agent code in cell D12. Include mixed cell references to the codes and roles in the range J2:K4 for the values and results arguments. use all cell references in the function. Copy the function to the range E13:E39. Now you want to calculate the number of days between the list date and sale date. In cell J12, insert the DAYS function to calculate the number of days between the Listing Date and the Sale Date. Copy the function to the range J13:J39. You want to calculate agent commissions based on their role. In cell K12, insert the IFS function to calculate the agent's commission based on the agent code and the applicable rates in the range L2:L4. Use relative and mixed references correctly. Copy the function to the range K13:K39. You want to…
Consider the following Employees relationEmployeeIDFirstNameSurname Department HiredateSalary1 Sam Shokongo Marketing 15 Sept2005N$25 0002 Ellouise Iipinge Shipping 23 April2006N$35 0003 Geoffrey #Eixas Acquisitions 12March2004N$15 0004 Sam Beukes Operations 2 Dec2001N$55 0005 Issy Shikongo Shipping 2 Dec2001N$35 000i. List all the attributes of this table. ii. Based on the Employees relation, what would you select as the primary key andbriefly discuss why? iii. What datatypes would you choose for each of the columns?iv. State the advantages of using such a data model