Execute the following statements using MYSQL: 1.Create a Trigger "trigger regno" for the salesman table (Before INSERT) set the value as O for the experience > 7 and evaluate it. Also write the syntax to drop the Trigger "trigger regno* 2. Insert a value for Customer table (#Last 3 digit of your register no, #Your name, Vellore, 55, 010). Insert a value for salesman table ("10", #Your name, 5, 4000). 3. List out the number of customers in each city by arranging them from low to high. ( 4. Select all the salesman who's work experience is between 4 and 8.

Execute the following statements using MYSQL: 1.Create a Trigger "trigger regno" for the salesman table (Before INSERT) set the value as O for the experience > 7 and evaluate it. Also write the syntax to drop the Trigger "trigger regno* 2. Insert a value for Customer table (#Last 3 digit of your register no, #Your name, Vellore, 55, 010). Insert a value for salesman table ("10", #Your name, 5, 4000). 3. List out the number of customers in each city by arranging them from low to high. ( 4. Select all the salesman who's work experience is between 4 and 8.

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter3: Performing Calculations With Formulas And Functions

Section: Chapter Questions

Problem 4.6CP

See similar textbooks

Similar questions

Add the following record to the VACATION_UNIT table: condo ID: 20; location number: 2; unit number: A04; square feet: 1680; bedrooms: 3; bathrooms: 3; condo fee: 775; and owner number: BL720. Display the contents of the VACATION_UNIT table.
3. In the OrderItems table, display a count of the number of products, grouped by prod_id. Display the count with the alias shown. Sort by prod_id in ascending order. BNBG01 BNBG02 BNBG03 BRO1 BRO2 BRO3 RGANO1 7 rows returned in 0.01 seconds PROD_ID Download 3 3 3 2 1 4 2 NUM_PROD_ID
Problem 1. Using the INVOICE table structure shown in table below do the following: INVOICE Attribute Name Sample Value Sample Value Sample Value Sample Value Sample Value INV_NUM 211347 211347 211347 211348 211349 PROD_NUM AA-E3422QW QD-300932X RU-995748G AA-E3422QW GH-778345P SALE_DATE 15-Jan-2016 15-Jan-2016 15-Jan-2016 15-Jan-2016 16-Jan-2016 PROD_LABEL Rotary sander 0.25-in. drill bit Band saw Rotary sander Power drill VEND_CODE 211 211 309 211 157 VEND_NAME NeverFail, Inc. NeverFail, Inc. BeGood, Inc. NeverFail, Inc. ToughGo, Inc. QUANT_SOLD 1 8 1 2 1 PROD_PRICE $49.95 $3.45 $39.99 $49.95 $87.75 Write the relational schema, draw its dependency diagram, and identify all dependencies, including all partial and transitive dependencies. You can assume that the table does not contain repeating groups and that an invoice number references more than one…
Name the candidate keys in the following table: Student L number Student Name Student_SS_Number Student_Address Student City Student State LO005485 Leigh 811-47-4449 5744 KENSINGTON Ave. Boston MD LO004812 Tammy 441-79-7448 30936 OAK Alley Colorado Springs TX LO004415 Alfredo 375-78-2633 5115 BOWEN St. Kansas City VT LO003478 Ramona 360-82-2835 5097 HUBBARD LOWER Blvd. Miami PA LO003058 Crystal 528-16-2635 73192 RANDOLPH SUB Dr. Riverside MD LO004588 Angie 765-16-4433 5115 GROVELAND PARK Dr. Cincinnati FL L0005484 Tonya 410-76-3632 5115 BISHOP FORD Blvd. Irving MS LO003161 Preston 451-47-2634 95289 MONROE Ave. Boston NC HTM B I A - A - I E E E E E X X, E E D T T 12pt Paragraph
Table : PURCHASE_ORDER ORDER_NO AMOUNT ORDER DATE CUSTOMER_ID SALESMAN_ID DELIVERY DATE 1001 300 05-03-2017 2001 3001 05-05-2017 1002 200.20 10-07-2017 2002 3003 10-10-2017 1003 600 12-06-2017 2005 3002 12-08-2017 1004 400.25 10-05-2017 2003 3004 10-07-2017 1005 500.10 03-08-2017 2004 3005 03-05-2017 1006 400 10-07-2017 2005 3006 10-10-2017 Table: PURCHASE _DETAILS ORDER_NO PRODUCT_NAME PRICE QUANTITY 1001 KEYBOARD 56 100 1002 MONITOR 36 200 1003 MOUSE 100 1004 HARD_DISK 58 300 1005 RAM 25 500 1007 CABINET 100 a) Write a SQL query to display PRODUCT_NAME, ORDER DATE and find number of years between the DELIVERY_ DATE from the CURRENT DATE [Hint: Use ON Clause]. b) Write a SQL query to display matched records from PURCHASE_ORDER table and all records from PURCHASE_DETAILS. c) Write an SQL query to display ORDER_NO, PRODUCT_NAME from table ORDER_DETAILS of products where the price is less than average price of products. [Hint: Use Subquery]. d) Write an SQL query to display ORDER_NO,…
Write SQL Queries for following Emp table :EMPLOYEE_IDName EMAILHIRE_DATESALARYDEPARTMET 1001 Juniad Juniad@abc.com 2010-06-18 110000.00 CS1002 Irfan Irfan@abc.com 2011-04-16 100000.00 Sales1003 Hassan Hassan@abc.com 2010-03-08 88000.00 Marketing1004 Fahad Fahad@abc.com 2013-01-28 90000.00 Sales1005 Husnain Hus@abc.com 2012-01-28 55000.00 ES 5. Write a query to get the total salaries payable to employees.6. Write a query to get the maximum, minimum, sum, average salary and number of employees from emp table.7. Write a query to find name whose name Start with ‘H’ and 'J'.8. Write a query get all names from employees table in upper case.9. Write a query to select first 2 records from a table.10. Write a query to get the name of employees ends with character ‘N’. Such as Hassan etc.11. List all employee and add 500 to their salaries, also change the column heading to Salary WithBonus.12. Show all records whose salary is more than 55000.00 and less than 100000.00 Plz give me all ans
Using the STUDENT table structure shown below, normalize the table to BCNF. Sample STUDENT Records Attribute Name Sample Value Sample Value Sample Value 199876 Sample Value 199877 STU_NUM 211343 200128 STU_LNAME Stephanos Smith Jones Ortiz STU_MAJOR Accounting Accounting Marketing Marketing DEPT_CODE ACCT ACCT MKTG MKTG DEPT_NAME Accounting Accounting Marketing Marketing DEPT_PHONE 4356 4356 4378 4378 COLLEGE_NAME Business Admin Business Admin Business Admin Business Admin ADVISOR_LNAME Grastrand Grastrand Gentry Tillery ADVISOR_OFFICE T201 T201 T228 T356 ADVISOR_BLDG Torre Building Torre Building Torre Building Torre Building ADVISOR_PHONE 2115 2115 2123 2159 STU_GPA 3.87 2.78 2.31 3.45 STU_HOURS 75 45 117 113 STU_CLASS Junior Sophomore Senior Senior Sample Value 223456 McKulski Statistics MATH Mathematics 3420 Arts & Sciences Chen J331 Jones Building 3209 3.58 87 Junior
Using the STUDENT table structure shown, do the following: Attribute Name Sample Value Sample Value Sample Value Sample Value Sample Value INV_NUM 211347 211347 211347 211348 211349 PROD_NUM AA-E3422QW QD-300932X RU-995748G AA-E3422QW GH-778345P SALE_DATE 15-Jan-2018 15-Jan-2018 15-Jan-2018 15-Jan-2018 16-Jan-2018 PROD_LABEL Rotary sander 0.25-in. drill bit Band saw Rotary sander Power drill VEND_CODE 211 211 309 211 157 VEND_NAME NeverFail, Inc. NeverFail, Inc. BeGood, Inc. NeverFail, Inc. ToughGo, Inc. QUANT_SOLD 1 8 1 2 1 PROD_PRICE $49.95 $3.45 $39.99 $49.95 $87.75 A. Write the relational schema, draw its dependency diagram and identify all dependencies, including all partial and transitive dependencies. You can assume that the table does not contain repeating groups and that any invoice number may reference more than one product. (Hint: This table…
Insert the following data into your database tables.STUDENTSSTUDENT_ID STUDENT_NAME STUDENT_SURNAMES123456 Neo PetleleS246810 Derek MooreS369121 Pedro NtabaS654321 Thabo JoeS987654 Dominique WoolridgeMODULESMODULE_ID MODULE_NAME MODULE_CREDITDATA6212 Database Intermediate 30INPU221 Desktop Publishing 20PROG6211 Programming 2A 15PROG6212 Programming 2B 15WEDE220 Web Development (Intermediate) STUDENT_MODULESSTUDENT_ID MODULE_IDS123456 PROG6211S123456 PROG6212S246810 DATA6212S369121 DATA6212S369121 INPU221S369121 WEDE220S987654 PROG6211S987654 PROG6212S987654 WEDE220LECTURERSLECTURER_ID LECTURER_NAME LECTURER_SURNAMEL578963 Kwezi MbeteL876592 Julia RobinsL916482 Trevor JanuaryLECTURER_MODULESMODULE_ID LECTURER_IDDATA6212 L578963INPU221 L876592PROG6211 L916482PROG6212 L916482WEDE220 L876592Correct INSERT statements used and all data correctly inserted per table.
5. In the OrderItems table, display a count of the number of products where item_price is greater than or equal to $6, grouped by prod_id, but only for those groups having 3 or more of a given prod_id. Display the count with the alias shown. Sort by prod_id in ascending order. BRO3 1 rows returned in 0.03 seconds PROD ID Download 4 NUM PROD ID
Write SQL Queries for following Emp table :EMPLOYEE_IDName EMAILHIRE_DATE SALARY DEPARTMET 1001 Juniad Juniad@abc.com 2010-06-18 110000.00 CS1002 Irfan Irfan@abc.com 2011-04-16 100000.00 Sales1003 Hassan Hassan@abc.com 2010-03-08 88000.00 Marketing1004 Fahad Fahad@abc.com 2013-01-28 90000.00 Sales1005 Husnain Hus@abc.com 2012-01-28 55000.00 ES 1. Write a query to display the names and email of all employees.2. Write a query to display sales and marketing department data.3. Write a query to get all employee details from the employee table order by first name, descending.4. Write a query to get the names, salary, PF of all the employees (PF is calculated as 15% of salary).5. Write a query to get the total salaries payable to employees.6. Write a query to get the maximum, minimum, sum, average salary and number of employees from emp table.7. Write a query to find name whose name Start with ‘H’ and 'J'.8. Write a query get all names from employees table in upper case.9. Write a query to…
Display the JOB_ID and the position of the character S in the JOB_ID on jobs table as the following: Search of the character S in the JOB_TITLE Result S not found in the name Not Found S in the last character of the name Last Character The name contains the character S Contains S S in the first character of the name First Character