Database Tables Nizwa Store Sells Bread Cookies Cakes Pastries And Chocolates It Has Many Branches Across Oman They 1 (130.16 KiB) Viewed 114 times
Database Tables Nizwa Store Sells Bread Cookies Cakes Pastries And Chocolates It Has Many Branches Across Oman They 2 (37.14 KiB) Viewed 114 times
Database Tables Nizwa Store sells bread, cookies, cakes, pastries and chocolates. It has many branches across Oman. They are using Store Management Software solution to manage their sales details. This software solution is using STORE database schema to record the stores, products, salesman and sales details. Use this schema and write all the questions. SQL> select * from products; SQL> select * from store; STOREID CITY REGION PRODUCTID PRODUCTNAME BRAND 1 Musketeers 2 5 Star 3 Aero 4 Aero Mint 5 Bounty 6 Galaxy 7 Moro Mars Cadbury Nestle Nestle Mars Mars Cadbury 10 Nizwa 20 Ibri 30 Ibra 40 Muscat 50 Sohar 60 Salalah Ad Dhahiliyah Ad Dhahirah Ash Sharqiyah Muscat Al Batinah Dhofar SQL> select * from sales_details; TRANS_ID STOREID PRODUCTID COST SALES_AMOUNT PROFIT 0 3.5 3.5 3.6 min 00 1 2 3 4 5 6 7 8 10 20 30 40 50 60 40 20 1 1 2 2 2 3 3 3 3 3 2 2 2 4 4 4 3.5 6 Մ Մ Դ Մ Մ Դ Φ Φ Φ Φ Φ 4.5 SQL> select * from salesman; SALESMANID STOREID NAME JOING_DATE SALARY 101 201 301 401 501 601 10 Nizar 20 Ibrahim 10 Izkaq 40 Munir 50 Sulaiman 60 Salman 12-Jan-2016 11-Feb-2009 02-Jan-2011 24-Jan-2014 05-Mar-2016 25-Apr-2014 80e 1200 1100 900 800 900
Create a PL/SQL program that increase the salary of all the salesmen in the salemen table. Apply the conditions given below in the table. When you increase the salary, you need to block the records. So that other user cannot access the same records. Total years Experience More than 5 years Otherwise Increment 20 percent of current salary 15 percent of current salary
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!