ЕMP EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO Dept DEPTNO DNAME LOC - MGR field is foreign key references empno - DEPTNO in emp table is foreign key references deptno in dept table. - Using your Apex account (http://apex.oracle.com), upload the script file (scott.sql) that creates emp-dept tables and try to do the following: 1. Insert a new employee info into emp table with the following info: o empno:4000. o name: Your name o hiredate: today date o deptno:null 2. Give for the employees who work as CLERK a commission equals 5% of their salary. 3. Retrieve the names of employees who don't take commission and hired before 1985. 4. Retrieve the names of employees, and their hiredates ordered from the newest hired employee to the oldest hired one.

ЕMP EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO Dept DEPTNO DNAME LOC - MGR field is foreign key references empno - DEPTNO in emp table is foreign key references deptno in dept table. - Using your Apex account (http://apex.oracle.com), upload the script file (scott.sql) that creates emp-dept tables and try to do the following: 1. Insert a new employee info into emp table with the following info: o empno:4000. o name: Your name o hiredate: today date o deptno:null 2. Give for the employees who work as CLERK a commission equals 5% of their salary. 3. Retrieve the names of employees who don't take commission and hired before 1985. 4. Retrieve the names of employees, and their hiredates ordered from the newest hired employee to the oldest hired one.

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Similar questions

PLZ help with the following: Use oracle live sql to change the following commands so that they work with creating the table CREATE TABLE `book`( `num` INT(20) NOT NULL AUTO_INCREMENT, `title` VARCHAR(20), `year` DATE, `subject` VARCHAR(20), `checkedout` DATETIME, `checkedin` DATETIME, PRIMARY KEY (`num`) ); CREATE TABLE `client`( `CID` INT(20) NOT NULL AUTO_INCREMENT, `fname` VARCHAR(25), `lname` VARCHAR(25), `type` VARCHAR(25), `num` INT(20), PRIMARY KEY (`CID`), FOREIGN KEY (`num`) REFERENCES `emp`.`state`(`state_id`) ); CREATE TABLE `author`( `id` INT(10) NOT NULL AUTO_INCREMENT, `year` DATE, `fName` VARCHAR(20), `lname` VARCHAR(20), `num` INT(20), PRIMARY KEY (`id`) ); ALTER TABLE `author` ADD FOREIGN KEY (`num`) REFERENCES `book`(`num`); ALTER TABLE `client` ADD CONSTRAINT `client_ibfk_1` FOREIGN KEY (`num`) REFERENCES `book`(`num`);
Please written by computer source
Task 3: The InstantRide Finance team wants to collect the price and discount information with the driver names for each travel in the system. You need to return the TRAVEL_ID, DRIVER_FIRST_NAME, DRIVER_LAST_NAME, TRAVEL_PRICE, and TRAVEL_DISCOUNT information from the TRAVELS and DRIVERS tables combined over DRIVER_ID field with the ON keyword. Task: Calculate each user's price and discount information. (SQL Database Test)
Why it's useful to have index that partially sort a query if it doesn't present all of the results already sorted?
The Sqlite.py file contains several very specific queries: select_Query = "select sqlite_version()" delete_query = "DELETE from Database where id = "+str(id) sel = 'SELECT id FROM Database WHERE name == "{0}"'.format(value) insert_query = """INSERT INTO Database (id, name, photo, html) VALUES (?, ?, ?, ?)""" sqlite_select_query = """SELECT * from Database""" table_query = '''CREATE TABLE Database ( id INTEGER PRIMARY KEY, name TEXT NOT NULL, photo text NOT NULL UNIQUE, html text NOT NULL UNIQUE)''' Write a QueryBuilder function. The QueryBuilder builds a generic Query to build ANY Query type (i.e. version, delete, select, insert, select, table). The QueryBuilder parameters require: The type of Query, the input tuple data and then constructs a query string based on the parameters.…
Go to the w3schools website’s SQL browser IDE. This is where you canwrite and test your SQL code using their databases. Once you are happywith it, paste your code in a text file named Student.txt and save it in yourtask folder.● Write the SQL code to create a table called Student. The table structure issummarised in the table below (Note that STU_NUM is the primary key):Attribute Name Data TypeSTU_NUM CHAR(6)STU_SNAME VARCHAR(15)STU_FNAME VARCHAR(15)STU_INITIAL CHAR(1)STU_STARTDATE DATECOURSE_CODE CHAR(3)PROJ_NUM INT(2)● After you have created the table in question 1, write the SQL code to enterthe first two rows of the table as below:STU_NUMSTU_SNAMESTU_FNAMESTU_INITIALSTU_STARTDATECOURSE_CODEPROJ_NUM01 Snow John E 05-Apr-14 201 602 Stark Arya C 12-Jul-17 305 11● Assuming all the data in the Student table has been entered as shownbelow, write the SQL code that will list all attributes for a COURSE_CODE of305.…
In a .txt file (using Notepad), write SQL commands to create the tables. Name this .txt file as Lastname_Med_DB.txt (being Lastname is your lastname).
6.7 LAB - Create Vehicle and EventVehicle tables The California DMV's completed table diagram is presented in the zyBook. The following is a portion of the table di Vehicle VehicleID TypeCode R YearNumber R MakeCode R ModelName R PlateID R VehicleEvent StateCode R -restrict- • VehicleID RegistrationDate -restrict- • EventNumber
What is the maximum number of columns you can define as a primary key when using the column-level approach to creating a table? ( refer to the tables in the JustLee Books database). a. 0 b. 1 c. 30 d. 255
Population Database Compile and run CreateCityDB.java which will create a Java DB database named CityDB. The CityDB database will have a table named City, with the following columns: CityName & Population. Their Data Types: CHAR(50) Primary Key & DOUBLE. The CityName column stores the name of a city, and the Population column stores the population of that city. After you run the CreateCityDB.java program, the City table will contain 20 rows with various cities and their populations. Next, create an application that connects to the CityDB database and allows the user to select any of the following operations: Sort the list of cities by population, in ascending order. Sort the list of cities by population, in descending order. Sort the list of cities by name. Get the total population of all the cities. Get the average population of all the cities. Get the highest population. Get the lowest population. CreateCityDB.java import java.sql.*; /** This program creates the CityDB…
PHP Using PHP write a function that does the query to select all transactions order by date desc.