Please use sql to answer the following question an erd also provide as the picture shown COMPI22 W21 ERS 100ASGM1 ORDER ITEMSPF. ORDER IDP TEM IDF PRODUCT IDQUANTITY* UNIT PRICENUMBER (12)NUMBER (12)NUMBER (12)NUMBER (8,2)NUMBER (82)COMPI22 W21 ERS 100ASGM1 ORDERSP. ORDER IDF CUSTOMER_IDSTATUSCOMPI22 W21 ERS 100 ASGM1 EMPLOYEESP. EMPLOYEE ID* FIRST NAMELAST NAMEEMAIL• PHONE* HIRE DATEMANAGER IDJOB TITLENUMBERNUMBERVARCHAR2 (255 BYTE)VARCHAR2 (255 BYTE)VARCHAR2 (255 BYTE)VARCHAR2 (50 BYTE)DATENUMBER (12)VARCHAR2 (255 BYTE)NUMBER (6)VARCHAR2 (20 BYTE)NUMBER (6)DATESALESMAN ID* ORDER DATEPK ASGM1 ORDER_ITEMS (ORDER_ID, ITEM_ID)O FK ORDER_ITEMS_ORDERS (ORDER_ID)FK ORDER_ITEMS PRODUCTS (PRODUCT_ID)O PK ASGM1 ORDER_ITEMS (ORDER_ID, ITEM_ID)ASGM1 ORDERS PK (ORDER ID)O FK ORDERS_CUSTOMERS (CUSTOMER_ID)FK ORDERS EMPLOYEES (SALESMAN_D)ASGM1 EMPLOYEES PK (EMPLOYEE ID)Og FK EMPLOYEES MANAGER (MANAGER_ID)COMP122 W21 ERS 100.ASGM1_INVENTORIESPF PRODUCT_IDPF WAREHOUSE ID* QUANTITYNUMBER (12)NUMBER (12)NUMBER (8)PK ASGM1_INVENTORIES (PRODUCT_ID, WAREHOUSE ID)FK INVENTORIES PRODUCTS (PRODUCT_ID)FK_INVENTORIES_WAREHOUSES (WAREHOUSE ID)O PK ASGM1_INVENTORIES (PRODUCT_ID, WAREHOUSE ID)COMP122_W21_ERS_100 ASGM 1_CUSTOMERSP CUSTOMER_ID NUMBERNAMEVARCHAR2 (255 BYTE)VARCHAR2 (255 BYTE)VARCHAR2 (255 BYTE)NUMBER (8,2)COMP122 W21_ERS_100 ASGM1_PRODUCTSP PRODUCT_D* PRODUCT NAMEDESCRIPTIONADDRESSWEBSITECREDIT LIMITNUMBERVARCHAR2 (255 BYTE)VARCHAR2 (2000 BYTE)NUMBER (92)NUMBER (92)NUMBERASGM1 CUSTOMERS PK (CUSTOMER_ID)STANDARD COoSTLIST PRICE• CATEGORY IDASGM1_PRODUCTS PK (PRODUCT_ID)FK ASGM1 PRODUCTS CATEGORIES (CATEGORY ID)COMP122 W21 ERS 100 ASGM1 WAREHOUSESCOMP122 W21 ERS 100.ASGM1 CONTACTSP. WAREHOUSE IDWAREHOUSE NAMELOCATION_IDP CONTACT ID* FIRST_NAMELAST NAMEEMAILPHONECUSTOMER IDNUMBERVARCHAR2 (255 BYTE)VARCHAR2 (255 BYTE)VARCHAR2 (255 BYTE)VARCHAR2 (20 BYTE)NUMBERNUMBERVARCHAR2 (255 BYTE)NUMBER (12)IFa ASGM1_WAREHOUSES PK (WAREHOUSE ID)COMP122 W21_ERS 100 ASGM1_PRODUCT CATEGORIESP. CATEGORY ID• CATEGORY NAMEFK _WAREHOUSES_LOCATIONS (LOCATION_ID)NUMBERVARCHAR2 (255 BYTE)> ASGM1 CONTACTS_PK (CONTACT_ID)FK CONTACTS CUSTOMERS (CUSTOMER_ID)ASGM1_PRODUCT CATEGORIES_PK (CATEGORY_ID)COMP122 W21 ERS 100 ASGM1 LOCATIONSP. LOCATION IDADDRESSPOSTAL CODENUMBERVARCHAR2 (255 BYTE)VARCHAR2 (20 BYTE)VARCHAR2 (50 BYTE)VARCHAR2 (50 BYTE)CHAR (2 BYTE)COMP122 W21 ERS 100.ASGM1 COUNTRIESCHAR (2 BYTE)VARCHAR2 (40 BYTE)NUMBERCOMP122 W21 ERS 100 ASGM1 REGIONSP. REGION IDREGION NAMECOUNTRY IDCOUNTRY NAMECITYNUMBERSTATEVARCHAR2 (50 BYTE)REGION IDCOUNTRY_ID- ASGM1_COUNTRIES_PK (COUNTRY_ID)a ASGM1 REGIONS PK (REGION_ID)ASGM1 LOCATIONS PKLOCATION IDA 1. Display the employee number, full employee name, job title, and hire date of allemployees hired in September with the most recently hired employees displayedfirst.Enlevee NteName12 James, Elliott Accountant11 Ramirez, Tyler Accountant27 Long, Kai2Rivera, Jude101 Dunn, Annabelle Administration Assistant[September 30oth of 2016][September 28th of 2016][september 2eth of 2016)Stock clerkAdministration Vice President (September 2lst of 2016](September 17th of 2016]Milestone 2 - Week 3 (Question 2, 3, 4, 5, and 6)2. The company wants to see the total sale amount per sales person (salesman) for allorders. Assume that online orders do not have any sales representative. For onlineorders (orders with no salesman ID), consider the salesman ID as 0. Display thesalesman ID and the total sale amount for each employee.Sort the result according to employee number.Enlyee te tat SO $18,245, 463.50$1,884,295.40$3, 525, 462.19$2, 754,951.05$3, 522, 704.53$3, 900, 172.99ו3. 737 ,233 ,$35455565759603. Display customer Id, customer name and total number of orders for customers thatthe value of their customer ID is in values from 35 to 45. Include the customers withno orders in your report if their customer ID falls in the range 35 and 45.Sort the result by the value of total orders.Cuntone Nane38 Kraft Meinz37 Hunt sman35 Kimberly-Ciark40Fluor39 Lear36 Hartford Finaneial services Group41 ABCOM43 Facebook42 Becton Dickinson45 Centurylink44 Jabil Cireuit

1) SELECT Employee Number, Full Name as ‘Employee Name’, Job Title, Start Date as ‘Hire Date’ from…

1. Display the employee number, full employee name, job title, and hire date of all employees hired in September with the most recently hired employees displayed first. Eneve Ntea Ne 12 James, Elliott Accountant 11 Ramirez, Tyler Accountant Stoek clerk Sat e [September 30th of 2016] [September 20th of 2016] (september 2eth of 2016) 27 Long, Kai 2Rivera, Jude Administration Vice President [September 21st of 2016] 101 Dunn, Annabelle Administration Assistant [September 17th of 2016]

1. Display the employee number, full employee name, job title, and hire date of all employees hired in September with the most recently hired employees displayed first. Eneve Ntea Ne 12 James, Elliott Accountant 11 Ramirez, Tyler Accountant Stoek clerk Sat e [September 30th of 2016] [September 20th of 2016] (september 2eth of 2016) 27 Long, Kai 2Rivera, Jude Administration Vice President [September 21st of 2016] 101 Dunn, Annabelle Administration Assistant [September 17th of 2016]

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

Assume the following tables: Student (studid, email, name) Club (clubid, telephone, name, #president) MemberOf(#clubid, #studid ) Activities(actid, actdt, place) Organize (#actid , #clubid , fee), Then answer the following questions by using SQL. 1- Create a stored procedure called 'StudentsActivities' to display the list of students and the activities in which they participated. 2- Create a stored Function called 'Checkavailability' to check whether 'Salalah Hall' is busy or not in a given date. 3- Create a stored Procedure called 'CheckavailabilityProc' to call the function 'Checkavailability' and display the appropriate message according to the value returned by the function (If function returns true, the procedure will display 'Salalah Hall is free on date ######' otherwise'Salalah Hall is busy on date ###### ').
Write queries in SQL to answer each of the following questions: 1. Find all students in Comp. Sci. dept 2. Find all students with total credits > 100 3. Find all students who took course in Spring 2010 (Remove duplicates please) 4. Find all courses taken by the student whose ID is 76543 and also find his name create table student (ID varchar(5), name varchar(20) not null, dept_name varchar(20), tot_cred numeric(3,0), primary key (ID) ); create table takes (ID varchar(5), course_id varchar(8), sec_id varchar(8), semester varchar(6), year numeric(4,0), grade varchar(2), primary key (ID, course_id, sec_id, semester, year) ); insert into student values ('00128', 'Zhang', 'Comp. Sci.', '102'); insert into student values ('12345', 'Shankar', 'Comp. Sci.', '32'); insert into student values ('19991', 'Brandt', 'History', '80'); insert into student values ('23121', 'Chavez', 'Finance', '110'); insert into student values ('44553', 'Peltier', 'Physics', '56'); insert into student values…
What is Stored Procedure (SP) in sql?
Describe the circumstances in which you would choose to use embed- ded SQL rather than SQL alone or only a general-purpose programming language.
Use the following table to find the OUTPUT of the following SQL queries: Table Name: Patients MEDICAL NO FIRST NAME SUR NAME GENDER PHONE DOB 12-Jun-2001 FAX 22114454 1001 Said Alalawi Male 98877445 1002 Othman Mualla 20-Apr-2000 Male 1003 Sameera Bader 19-Oct-2005 Female 25541122 1004 Fahad Alhinai 24-Feb-2004 91122544 Male Female 1005 Shamsa Alfahdi 15-Sep-2002 SELECT TO CHAR (DOB, 'DD/YY/MM') FROM patients WHERE Medical_no=1001; Answer: BLOOD TYPE A B O AB B WEIGHT 68 78 52 66 35 SMOKER NO YES NO YES NO PCR_TEST Negative Positive Positive Negative Negative
Describe the circumstances in which you would choose to use embed- ded SQL rather than SQL alone or only a general-purpose programming language.
PLZ hlp with the following: In SQL If you add the PRIMARY KEY constraint to a column, you must also add a UNIQUE constraint to it. Select one: True False
Schema: Frequents(kid, store) Sells(store, candy) Likes(kid, candy) d) Use SQL to list the names of all the candies that are liked by at least one kid, along with the names of the stores that sell them. Sort the result in alphabetical order by candy name.
How to Grant access privileges on objects created in the future in sql.
Describe the use of the CAST and CONVERT functions in SQL.
Write the SQL syntax to create a table in the database called Employee with the employee first and last name, employee hire date, employee number, employee initial, and employee years.
Describe the circumstances in which you would choose to use embed- ded SQL rather than SQL alone or only a general-purpose programming language.