Write in SQL a command that creates the table Supplier according to the above description . Write in SQL a statement that adds a new column named comapnyID of type char(5). This column should be defined as a foreign key that relates the table Supplier to the table Company .  Write in SQL a query that lists the full names (first and last names) of all suppliers arranged in ascending order according to their date of births .  Write a SQL query that displays the number of suppliers who born in December .  Write in SQL a  query that displays the ids of the suppliers who supply the highest number of products .  Create a view named ‘SupplierDetails’ to hold all the details of suppliers whose last names start with ‘bait’ and who supply  between 50 and 200 products .

9. You want to track date and time of the last write access per row in SQL server?a) Add TIMESTAMP column to the tableb) Add a DATETIME column to the table and assign getdate() as the default valuec) Add a DATETIME column to the table and write a trigger that sets its valued) Add a UNIQUEIDENTIFIER column to the table and use it with SQL Server’s built-in functions

This is a database system question regarding SELECT: Which of the following statements is true for SELECT statements in general? a. HAVING is executed before WHERE when running an SQL query b. SELECT is executed before FROM when running an SQL query c. Each SELECT clause must have a WHERE clause as well. d. COUNT(column_name) function returns the number of values in the column, including any NULLs e. HAVING clause specifies a condition for selecting grouped tuples from the GROUP BY clause.

SQL procedure    a. Write a procedure in SQL that inserts a new customer record into the "Customers" table.   b. Create a procedure that updates the quantity of a product in the "Inventory" table based on the product ID.   c. Write a procedure that calculates the average salary of all employees in the "Employees" table and displays the result.

INFO 2303   Database Programming Assignment # : PL/SQL Procedure & Function Practice   Note: PL/SQL can be executed in SQL*Plus or SQL Developer or Oracle Live SQL.   Write a script to create a PL/SQL procedure called findSal that displays the doctor’s salary and bonus after passing in the doc_id into the procedure. For example, if you pass in doc_id 504, you will get the following output.   execute findSal(504)   The salary for Dr.Cotner (504) is: 11500 The bonus is: 7500     PL/SQL procedure successfully completed.

Where shouId I put the while loop in these programs thanks? Develop a two small PL/SQL programs. 1. Enter instructor ID from the keyboard. The program then finds instrutor's first name, last name and phone, stores them in variables and prints them on the screen. USE WHILE LOOP to print all instructors while selecting them one by one in the loop. 2. Similar to the above, only this time the program will receive student's first name only (instead of ID)Then program finds full name and address and prints it on the screen  (work with STUDENT table here) For both programs please implement NO_DATA_FOUND and TOO_MANY_ROWS exceptions. (please refer to chapter 8 in PL/SQL by Example book)For number 2 program, display a message "Possibly you have two or more students with the first name ...." in TOO_MANY_ROWS exception block. 1* select table_name from user_tablesSQL> desc studentName Null? Type----------------------------------------- -------- ----------------------------STUDENT_ID NOT NULL…

Online shopping system & online book store: Rebuild View/Edit cart and checkout pages using PL/SQL like the following: Create a function/procedure to update the quantity of the product in the cart if the new quantity is available in the store. Create a trigger that deletes the product from the cart after updating the quantity to 0. Don't forget to return the old quantity to the store. Create a trigger that empties the customer cart after the customer clicks on the checkout.

Assume that you have a product code that has the following format: XXXXNNN  Where X is a character and N is a digit. Notice that the length of the character part is not fixed, it may range from 2 to 4 characters, while the length of the second part may range from 2 to 3 digits but the first digit from the left is always 0 (zero).     Write a PL/SQL program to separate the code into its two parts as shown in the following example: if the input is ABC031, the output should be:    Product Name is: ABC  Serial Number is: 031

Assume that you have a product code that has the following format: XXXXNNN  Where X is a character and N is a digit. Notice that the length of the character part is not fixed, it may range from 2 to 4 characters, while the length of the second part may range from 2 to 3 digits but the first digit from the left is always 0 (zero).     Write a PL/SQL program to separate the code into its two parts as shown in the following example: if the input is ABC031, the output should be:    Product Name is: ABC  Serial Number is: 031    Hints: Use the following functions if needed:  instr( string1, string2 [, start_position [, nth_appearance ] ] )  substr( string, start_position, [ length ] )  length( string )  DBMS_OUTPUT.PUT_LINE( )