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

A Guide to SQL

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter7: Database Administration

Section: Chapter Questions

Problem 4TD: Write, but do not execute, the commands to grant the following privileges: a. User Ashton must be...

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…
Write, but do not execute, the commands to grant the following privileges: a. User Ashton must be able to retrieve data from the ITEM table. b. Users Kelly and Morgan must be able to add new orders and order lines. c. User James must be able to change the price for all items. d. User Danielson must be able to delete customers. e. All users must be able to retrieve each customers number, name, street, city, state,and postal code. f. f User Pere7 must be able to create an index on the ORDFRS table. g. User Washington must be able to change the structure of the ITEM table. h. User Grinstead must have all privileges on the ORDERS table.
Assuming the HOMEWORK10 table has three columns (Col1, Col2, and Col3, in this order), which of the following commands stores a NULL value in Col3 of the HOMEWORK10 table?a. INSERT INTO homework10 VALUES (‘A’, ‘B’, ‘C’);b. INSERT INTO homework10 (col3, col1, col2) VALUES (NULL, ‘A’, ‘B’);c. INSERT INTO homework10 VALUES (NULL, ‘A’, ‘B’);d. UPDATE homework10 SET col1 = col3;
134. EMPDET is an external table containing the columns EMPNO and ENAME. Which command would work in relation to the EMPDET table? a. UPDATE empdetSET ename = 'Amit'WHERE empno = 1234; b. DELETE FROM empdetWHERE ename LIKE 'J%'; c. CREATE VIEW empvuASSELECT * FROM empdept; d. CREATE INDEXempdet_idxON empdet(empno);
PatientDim.AgeInYears is a tiny it column. PatientDim.Sex is an nvarchar(300) column. What would be the results of the query below? SELECT AgeInYears + Sex from PatientDim?
As per our guidelines, we are supposed to answer only 1st three parts. Kindly repost the remaining questions separately. 4.1 use gym_29876543 4.2 db.createCollection("userProfiles") db.userProfiles.insertMany([ {"Name" : "Dominic","Surname":"Badeaux","Date_of_Birth":1982-09-04,"FitnessLevel":1}, {"Name" : "John","Surname":"Dlamini","Date_of_Birth":1974-05-18,"FitnessLevel":2} ]) 4.3 db.userProfiles.find() arrow_forward Step 2 Complete code: use gym_29876543 db.createCollection("userProfiles") db.userProfiles.insertMany([ {"Name" : "Dominic","Surname":"Badeaux","Date_of_Birth":1982-09-04,"FitnessLevel":1}, {"Name" : "John","Surname":"Dlamini","Date_of_Birth":1974-05-18,"FitnessLevel":2} ]) db.userProfiles.find() Q.4.4 Query all the user profiles where the fitness level of the user is equal to 2. Q.4.5 Query all the user profiles where the date of birth of the user is from 1980‐01‐01 to1982‐12‐31 (including both dates)
1. Create/ a sequence, GOV_SEQUENCE_xx, that begins with 100 and increments by 100 and uses all other defaults. Use your initials instead of the xx in the sequence name. 2. Select the next value of your sequence. 3.Use the next value of the sequence you created , GOV_SEQUENCE_xx as the value for the employee ID for every row inserted
Insert the copy of the complete excel functions table here Click here for a video tutorial on how to use the Excel functions: https://youtu.be/LY1ut_uFc8U?si=D6uLXI7nfAxqxrT-
Based on the following table, please find the customers who locate in the same state. sales.customers *customer_id first_name last_name phone email street city state zip_code . Based on the following table, please display the staff and their corresponding manager in the same store. Please display staff’s full name in one column, manager’s full name in another column, and store_id. sales.staffs *staff_id first_name last_name email phone active store_id manager_id
Please help me with the solution: MySQL */ CREATE TABLE AGENT ( AGENT_CODE int, AGENT_LNAME varchar(15), AGENT_FNAME varchar(15), AGENT_INITIAL varchar(1), AGENT_AREACODE varchar(3), AGENT_PHONE varchar(8), AGENT_ADDRESS varchar(30), AGENT_CITY varchar(15), AGENT_STATE varchar(2), AGENT_ZIP varchar(5), AGENT_DATE_HIRED datetime, AGENT_YTD_PAY numeric, AGENT_YTD_FIT numeric, AGENT_YTD_FICA numeric, AGENT_YTD_SLS numeric, AGENT_DEP int ) ENGINE = InnoDB; INSERT INTO AGENT VALUES('501','Alby','Alex','B','713', '228-1249','123 Pleasant View Dr.','Nashville','TN','37119', '2000-11-1','26566.24','6641.56','2125.3','132735.75','3'); INSERT INTO AGENT VALUES('502','Hahn','Leah','F','615', '882-1244','334 East Main Street','Louisville','KY','25246', '1986-5-23','32213.76','8053.44','2577.1','138967.35','0'); INSERT INTO AGENT VALUES('503',' Okon','John','T','615', '123-5589','452 Technology Circle','Oak Ridge','TN','36155', '2005-6-15','23198.29','5799.57','1855.86','127093.45','2'); CREATE…
Don't send plagiarised or wrong response ok.
Name Null? Type --------- ----- ------------ GIFT VARCHAR2(15) MINRETAIL NUMBER(5,2) MAXRETAIL NUMBER(5,2) Based on the structure of the PROMOTION table, which of the following commands will add a PRIMARY KEY constraint to the GIFT column? 1. CREATE constraint promo_pk (gift VARCHAR2(15) PRIMARY KEY; 2. ALTER TABLE promotion MODIFY constraint promo_pk (gift PRIMARY KEY); 3. ALTER TABLE promotion SET constraint promo_pk PRIMARY KEY gift; 4. ALTER TABLE promotion ADD constraint promo_pk PRIMARY KEY(gift);