Wite a SQL query to create gientable. ТАBLE-TITLE WORKER REP_ID WORKER TITLE AFFECTED_FROM Manager 2016-02-20 00:00:00 Executive 2016-06-11 00:00:00 Executive 2016-06-11 00:00:00 Manager 2016-06-11 00:00:00 Ast. Manager 2016-06-11 00:00:00 Executive 2016-06-11 00:00:00 Lead 2010-06-11 00:00:00 Lead 2016-06-11 00:00:00

Wite a SQL query to create gientable. ТАBLE-TITLE WORKER REP_ID WORKER TITLE AFFECTED_FROM Manager 2016-02-20 00:00:00 Executive 2016-06-11 00:00:00 Executive 2016-06-11 00:00:00 Manager 2016-06-11 00:00:00 Ast. Manager 2016-06-11 00:00:00 Executive 2016-06-11 00:00:00 Lead 2010-06-11 00:00:00 Lead 2016-06-11 00:00:00

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

SQL FOR THERES TABLES
SQL SQL Provide the StayWell Property Management team with a list of all property addresses combined with the name of the owners. here is what i have so far but says query completed but nothing shows SELECT O.FIRST_NAME, O.LAST_NAME,P.ADDRESS FROM OWNER AS O,PROPERTY AS P two tables im grabbing the information from are attached owner table and property expected outcome FIRST_NAME LAST_NAME ADDRESS Ernest Burke 30 West Thomas Rd. Ceyda Aksoy 782 Queen Ln. Nicole Bianchi 9800 Sunbeam Ave. Jakub Kowalczyk 105 North Illinois Rd. Haydon Sims 887 Vine Rd. Elle-May Moore 8 Laurel Dr. Meerab Cole 447 Goldfield St. Jakub Kowalczyk 594 Leatherwood Dr. Makesh Patel 504 Windsor Ave. Janine Lopez 891 Alton Dr. Ammarah Jones 9531 Sherwood Rd. Seth Redman 2 Bow Ridge Ave. Haydon Sims 916 Kent Drive
JANUARY DATA MANAGEMENT SHORTAND NOTATION FOR RELATIONAL SQL TABLES Notation Underlined Example Meaning The attribute(s) is (are) a primary key The attribute(s) is (are) a foreign key referencing relation R CREATE TABLE R A or A, B A cany SQL type>, B cany SQL type>, C cany SQL type>, D cany SQL type>, E cany SQL type>, A or A", B* Superscript name of relation PRIMARY KEY(A), As an example, the schema FOREIGN KEY (E) REFERENCES S(F) ): R(A, B, C, D, E') S(E, G, H) CREATE TABLE S F , G cany SQL type>, H cany SQL type>, PRIMARY KEY(F)) corresponds to the following SQL tables: EXERCISE Consider the following relational schema, representing five relations describing shopping transactions and information about credit cards generating them [the used notation is explained above]. SHOPPINGTRANSACTION (Transld, Date, Amount, Currency, ExchangeRate, CardNbrREDITCARD, StoreldSTORE) CREDITCARD (CardNbr, CardTypeCARDTYPE, CardowneroWNER, ExpDate, Limit) OWNER (Ownerld, Name, Surname, BirthDate,…
How to SQL injection-enabling characters?
Write SQL Queries for following Employee table : EMPLOYEE_ID Name EMAIL HIRE_DATE SALARY DEPARTMENT Juniad@abc.com | 2010-06-18 Irfan@abc.com Hassan@abc.com 2010-03-08 Fahad@abc.com 2013-01-28 110000.00 CS 100000.00 Sales 88000.00 Marketing 101 Juniad Irfan 102 2011-04-16 103 Hassan 104 Fahad 90000.00 Sales 105 Husnain Hus@abc.com 2012-01-28 55000.00 ES 1. Write a query to display sales and marketing department data. 2. Write a query to get the names, salary, PF of all the employees (PF is calculated as 15% of salary). 3. Write a query to get the total salaries payable to employees. 4. Write a query to get the average salary and number of employees in the employees table. 5. Write a query to select first 2 records from a table. 6. Write a query to get the name of employees ends with character 'N'. Such as Hassan etc.
LAB 2: SUBTASK 1: Fill in the following tables: as preliminary lab work (some are filled for your guidance) SUBTASK 2: Build the tables in Oracle Live SQL with your account according to the tables above. SUBTASK 3: Build the relations among the tables. Addresses Column Name Primary Key Foreign Key Data Type Nullable Default Sample Entry address_id V NO 1234567890 Customers Column Name Primary Key Foreign Key Data Type Nullable Default Sample Entry customer id V number NO Good_groups Column Name Primary Key Foreign Key Data Type Nullable Default Sample Entry good_group_id V number varchar2(10) NO