DATABASE SQL shipmentOrder No WarehouseNo210250220240230WarehouseWarehouseNo CityWH1WH2WH3WH4WH5OrdersOrder No210220230240250260WH1WH2WH3WH4WH5270NAJMAKHORDOHAMUNTZARAYAANOdate06-OCTOBER-201003-APRIL-2002 10109-MARCH-200423-JANYARY-200111-AUGUST-200820-OCTOBER-200823-FEBRUARY-Ship_date200811-JANUARY-200224-FEBRUARY-201013-JUNE-200516-SEPTEMBER-200928-APRIL-2003CustNo Ord_amt10000202303404505606707110001400016000200003000055000 2. Fill the table by following data: (Insert the dates in this format (DD-MONTH-YYYY)CustomercustNo101202303404505606707ItemItem No1122334455cnameSARAorder_ItemOrder No210250220240230ABDULAZIZFATMAABDULLAOMARHASSANABDULAZIZSALAHABDELKAREEMABDELKAREEMALI ABDULLA SHAMALAMMAABDULAZIZUnitPrice1100.751200.901300.701400.951500.50Item No1155224433CityDOHAQty2030401060DOHAKHORKHORWAKRAWAKRAPhone333-444-111444-333-222555-444-666777-444-222303-404-101404-303-202505-404-606

The SQL queries are given below with table output screenshot

2. Fill the table by following data: (Insert the dates in this format (DD-MONTH-YYYY) Customer custNo 101 202 303 404 505 606 707 Item Item No 11 22 33 44 55 order_item OrderNo 210 250 220 240 230 cname SARA ABDULAZIZ FATMA ABDULLA OMAR ABDELKAREEM ALI ABDULLA HASSAN ABDULAZIZ SALAH ABDELKAREEM AMMA ABDULAZIZ UnitPrice 1100.75 1200.90 1300.70 1400.95 1500.50 Item No Qty 20 30 40 10 60 11 55 243 22 44 33 City DOHA DOHA KHOR SHAMAL KHOR WAKRA WAKRA Phone 333-444- 111 444-333- 222 555-444- 666 777-444- 222 303-404- 101 404-303- 202 505-404- 606

2. Fill the table by following data: (Insert the dates in this format (DD-MONTH-YYYY) Customer custNo 101 202 303 404 505 606 707 Item Item No 11 22 33 44 55 order_item OrderNo 210 250 220 240 230 cname SARA ABDULAZIZ FATMA ABDULLA OMAR ABDELKAREEM ALI ABDULLA HASSAN ABDULAZIZ SALAH ABDELKAREEM AMMA ABDULAZIZ UnitPrice 1100.75 1200.90 1300.70 1400.95 1500.50 Item No Qty 20 30 40 10 60 11 55 243 22 44 33 City DOHA DOHA KHOR SHAMAL KHOR WAKRA WAKRA Phone 333-444- 111 444-333- 222 555-444- 666 777-444- 222 303-404- 101 404-303- 202 505-404- 606

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter5: Data Manipulation And Transaction Control

Section: Chapter Questions

Problem 5HOA: Add a new row in the ORDERS table with the following data: Order# = 1023 and Customer# = 1009....

See similar textbooks

Similar questions

Add a new row in the ORDERS table with the following data: Order# = 1023 and Customer# = 1009. Describe the error raised and what caused the error.
A new table has been requested to support tracking automated emails sent to customers. Create the table and add data as described below. Tablename: email_log Columns: emailid (numeric), emaildate (datetime), customer# (numeric) Primary key: emailid column, define as an Identity Column Add the following data rows and display resulting rows (if any errors occur, explain why the error is expected) Emaildate = current date, customer# = 1007 Emailid = specify to use the column default value, emaildate = current date, customer# = 1008 Emailid = 25, emaildate = current date, customer# = 1009
Add a new row in the ORDERS table with the following data: Order# = 1022, Customer# = 2000, and Order date = August 6, 2009. Describe the error raised and what caused the error.
Delete the index named ITEM_INDEX3.
Create a new table containing these four columns: Emp#, Lastname, Firstname, and Job_class. The table name should be EMPLOYEES. The Job_class column should be able to store character strings up to a maximum length of four, but the column values shouldn’t be padded if the value has less than four characters. The Emp# column contains a numeric ID and should allow a five-digit number. Use column sizes you consider suitable for the Firstname and Lastname columns.
The Horse table has the following columns: ID - integer, auto increment, primary key RegisteredName - variable-length string Breed - variable-length string, must be one of the following: Egyptian Arab, Holsteiner, Quarter Horse, Paint, Saddlebred Height - decimal number, must be between 10.0 and 20.0 BirthDate - date, must be on or after Jan 1, 2015 Insert the following data into the Horse table: RegisteredName Breed Height BirthDate Babe Quarter Horse 15.3 2015-02-10 Independence Holsteiner 16.0 2017-03-13 Ellie Saddlebred 15.0 2016-12-22 NULL Egyptian Arab 14.9 2019-10-12 Notes: Your SQL code does not display any results in Develop mode. Use Submit mode to test your code. In another lab that creates the Horse table, RegisteredName is NOT NULL. In this l
The Horse table has the following columns: ID - integer, auto increment, primary key registered name - variable-length string Breed - variable-length string, must be one of the following: Egyptian Arab, Holsteiner, Quarter Horse, Paint, Saddlebred Height - decimal number, must be between 10.0 and 20.0 BirthDate - date, must be on or after Jan 1, 2015 Insert the following data into the Horse table: RegisteredName Breed Height BirthDate Babe Quarter Horse 15.3 2015-02-10 Independence Holsteiner 16.0 2011-03-13 Ellie Saddlebred 15.0 2016-12-22 NULL Egyptian Arab 14.9 2019-10-12
The Horse table has the following columns: ID - integer, auto increment, primary key RegisteredName - variable-length string Breed - variable-length string, must be one of the following: Egyptian Arab, Holsteiner, Quarter Horse, Paint, Saddlebred Height - decimal number, must be between 10.0 and 20.0 BirthDate - date, must be on or after Jan 1, 2015 Insert the following data into the Horse table: RegisteredName Breed Height BirthDate Babe Quarter Horse 15.3 2015-02-10 Independence Holsteiner 16.0 2017-03-13 Ellie Saddlebred 15.0 2016-12-22 NULL Egyptian Arab 14.9 2019-10-12
Link of the procedure: https://www.bartleby.com/questions-and-answers/computer-engineering-question/110b20bb-9fc9-44d7-885d-c28ed9f41bf7 Using the sp_InsertTeamDetails (check link above) procedure, create a query to insert the following values into the Rugby_world_cup table. Team_id Team_name Country Tries Conversions Drop_Goals Points 10 The Brave Blossoms Japan 4 3 1 35 12 Wallabies Australia 14 7 1 93 14 Welwitschias Namibia 4 3 3 44 16 Springboks South Africa 10 5 1 78 18 The Bati Fiji 2 1 1 24
With the following table: PRODUCTS(PRODUCT_NUMBER, DESCRIPTION,PURCHASE_DATE,CATEGORY) Write the mySQL statement that will insert the following PRODUCT into the table: PRODUCT_NUMBER: ‘67832’ DESCRIPTION: ‘KRAZY CAT CEREAL’ PURCHASE_DATE: 2023-11-14 CATEGORY: ‘CPG’ Write the mySQL statement that will insert that product but without a description.
Please create this two trigger and write down as Mysql statement Create a trigger named trg_charter_time that will automatically update the AIRCRAFT table when a new CHARTER row is added. Use the CHARTER table’s CHAR_HOURS_FLOWN to update the AIRCRAFT table’s AC_TTAF, AC_TTEL, and AC_TTER values. The meaning for the AIRCRAFT table columns are as follows: AC_TTAF: Total time on the air frame (before maintenance) AC_TTEL: Total time on the left engine (before maintenance, also track single engine) AC_TTER: Total time on the right engine (before maintenance) So in the trigger, you need to decrease all of them by the number of CHAR_HOUR_FLOWN Create a trigger named trg_cust_charge that will automatically update the CUSTOMER table’s CUS_BALANCE when a new CHARTER row is added. Use the CHARTER table’s CHAR_TOT_CHG as the update source (Assume that all charter charges are charged to the customer balance.) In addition to the CHAR_TOT_CHG, add a $5 service charge for every 50 miles…
Answer the following questions then copy your code to a text document (with print screens) and upload it on Blackboard before the due date. A- Create this Employees table Department_id 66 First name salary 1500 Last name Almahmod Alnaser Al badr Saad Saleh 10500 50 Abdullah 2000 50 Mohammad Alabdukarem 18000 50 Almasoud B- Then apply the following queries: Nasser 11000 70 1- Retrieve all the employees who got salary more than 2000$ 2- Retrieve all the employees who got salary in the range 2000$ to 11000$ 3- Retrieve all the employees who got salary out of the range 2000$ to 11000$ 4- Retrieve all the employees who got salary 2000$ , 10500$ or 17000$ using the IN operator 5- Retrieve all the employees who got salary other than 2000$ , 10500$ or 17000$ using the IN operator 6- Retrieve employee first name, last name and display his Full name which is the concatenation of his first name and last name together. 7- Retrieve the first name, last name and salary for all employees whose first…