Given the Employee, Class, and Training tables.EmployeeEmp_id (PK)EM8765AddressUSANamePhoneEmailAliali@yahoo.comnazire@gmail.comkatrina@gmail.comlemi@hotmail.comalican@yahoo.commustafa@hotmail.comhasan@gmail.com98733211ЕМ3456NazireDubai9876453390857464EM7658KatrinaUSAEM1987LemiUSA99663425EM8009AlicanUK95583372|EM7698MustafaDubaiJordan92234452EM6666Hasan92123366ClassClass_id (PK)Class_nameMultimediaCreditСOM106COM206Databaseсомз06Public Speaking9.Training TableEmp_id (FK)EM8765DateClass_id (FK)Result05-May-201008-May-201108-Feb-201008-Feb-2010соM106PassEM3456COM206PassEM7658сомз06FailEM1987сомзо6Fail28-Jan-201110-March-2012EM8009сомз06PassEM7698сом106FailEM876508-May-2011сOM206PassWrite the appropriate SQL queriesa) Get the address of employee whose name is Alicanb) Get the name and email of employees located in Dubai. Sort the results inalphabetical order of name.c) Show the count of employees that stored in Employee Table.d) What is the minimum, maximum, average and total values of credit in Class Tablee) Show the Emp_id and Result column of Training table which class_id is 'COM106' and"COM206' by using IN function.f) Show the employee(s) whose email account is gmail.8) (10 Mark) List Name, Email, Class Name and Result of employees.

Below is the solution all parts step by step: a) Employee Address for Name = ‘Alican’ SQL: Output:

Given the Employee, Class, and Training tables. Employee Emp_id (PK) Name Address Phone Email Ali ali@yahoo.com nazire@gmail.com katrina@gmail.com lemi@hotmail.com alican@yahoo.com mustafa@hotmail.c hasan@gmail.com EM8765 USA 98733211 EM3456 Nazire Dubai 98764533 90857464 EM7658 Katrina USA EM1987 Lemi USA 99663425 Alican Mustafa Hasan EM8009 UK 95583372 EM7698 Dubai 92234452 EM6666 Jordan 92123366 Class

Given the Employee, Class, and Training tables. Employee Emp_id (PK) Name Address Phone Email Ali ali@yahoo.com nazire@gmail.com katrina@gmail.com lemi@hotmail.com alican@yahoo.com mustafa@hotmail.c hasan@gmail.com EM8765 USA 98733211 EM3456 Nazire Dubai 98764533 90857464 EM7658 Katrina USA EM1987 Lemi USA 99663425 Alican Mustafa Hasan EM8009 UK 95583372 EM7698 Dubai 92234452 EM6666 Jordan 92123366 Class

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

CUSTOMERColumns = 7, Rows = 10 CustomerID LastName FirstName Address ZIP Phone Email 1 Shire Robert 6225 Evanston Ave N 98103 206-524-2433 Robert.Shire@somewhere.com 2 Goodyear Katherine 7335 11th Ave NE 98105 206-524-3544 Katherine.Goodyear@somewhere.com 3 Bancroft Chris 12605 NE 6th Street 98005 425-635-9788 Chris.Bancroft@somewhere.com 4 Griffith John 335 Aloha Street 98109 206-524-4655 John.Griffith@somewhere.com 5 Tierney Doris 14510 NE 4th Street 98005 425-635-8677 Doris.Tierney@somewhere.com 6 Anderson Donna 1410 Hillcrest Parkway 98273 360-538-7566 Donna.Anderson@elsewhere.com 7 Svane Jack 3211 42nd Street 98115 206-524-5766 Jack.Svane@somewhere.com 8 Walsh Denesha 6712 24th Avenue NE 98053 425-635-7566 Denesha.Walsh@somewhere.com 9 Enquist Craig 534 15th Street 98225 360-538-6455 Craig.Enquist@elsewhere.com 10 Anderson Rose 6823 17th Ave NE 98105 206-524-6877 Rose.Anderson@elsewhere.com EMPLOYEEColumns = 5, Rows = 5 EmployeeID LastName FirstName…
How many characters can an identity have at the most?
Table name: EMPLOYEE EMP_NUM EMP_LNAME 215 Smith 216 Romero 217 Randall 218 Aarden Table name: EMP_EDUC EMP_NUM EDU_CODE EE_YEAR 2002 1991 1994 1989 2004 2002 1985 1992 2000 1990 2000 2005 1984 1995 215 84 215 HS 215 JC 216 B4 216 CDP 216 CNP 216 HS 217 HS 217 JC 218 B4 218 CDP 218 CNP 218 HS 218 M2 Table name: EDUCATION EDU_CODE EDU_DESCRIPTION 34 CDP CNP CPA DR HS JC M2 Bachelor's degree Certified data Processing Certified Network Professional Certified Public Accountant Earned Doctorate degree Highschool diploma Junior College degree Master's degree
How many characters can an identity have at the most?
Html.
How many characters can an identity have at the most?
List all the dependencies that are applicable to the tables given (full, partial, and transitive)
SQL =========================== Country Table: countryId: integer not null auto increment primary key countryCode: varchar not null =================================================================================== --create the "Country" table --Insert a new row into the "Country" table with a "countryCode" of 'CA'. --Insert two new rows into the "Country" table with "countryCode" values of 'DE' and 'IT'. --Select all rows from the "Country" table. --Select the "countryCode" value for the row with "countryId" equal to 3. --Update the "countryCode" value to 'UK' for the row with "countryId" equal to 1. --Update the "countryCode" value to 'FR' for the row with "countryId" equal to 2. --Delete the row from the "Country" table with "countryId" equal to 3.
Q1 Salesforce Programming Please include multiple fields so more descriptive. Design a salesforce query to fetch the asynchronous jobs that is successfully completed in the salesforce. Run the query on anonymous window. Attach the screenshot for the same. Salesforce Development
Use the table below to find the output PRODUCT_ID PRODUCT_NAME BRAND UNIT PRICE SUPPLIER_ID CATEGORY_ID 113 Note Book Atlas Pieces 5 S1 C1 114 Sticky Note Fanta Воx 4.3 S3 C1 117 Paper Clips Nizwa Packet .5 S4 C1 111 A4 Paper Double A Ream 2 S1 C2 112 Plastic envelope Atlas Packet 1.7 S2 C1 115 White Board Marker Pentel Вох 2.2 S3 C2 116 Stapler Small Nizwa Pieces S4 C1 Write the OUTPUT of the following SQL Statement: 1- SELECT brand FROM products WHERE price = 2.2; 2 - SELECT product_name FROM products WHERE product_name like "%Ma%' 3 - SELECT price * 2 FROM products WHERE product_id = 111 4 - SELECT unit FROM products WHERE supplier_id = 'S3' and Category_id ='C1'
SQL Question
Customer_ID Customer_Name Order_ID Order_Date Product_Name Quantity 101 Alice 1 2023-09-01 Laptop 2 101 Alice 1 2023-09-01 Mouse 1 102 Bob 2 2023-09-02 Monitor 1 102 Bob 2 2023-09-02 Keyboard 1 103 Carol 3 2023-09-03 Laptop 1 103 Carol 3 2023-09-03 Speaker 2 Create a 3nf model