1. Use the following table to answer the questions below:Table name: ProductsColumnRoleData Type LengthConstraintNameStores the ID of a productStores the name of aproductP_entryDate Stores the entry date of a| productStores the expiry date of aproductP_IDP_NameNumberVarchar2|Primary key25DateCannot be nullP_ExpiryDateP_Expiry dateshould be greaterthan P_entryDate|Cannot be nullP_Price| Stores the price of a product | Number3,22.a. Write in SQL a command that creates the table Products according to the above descriptionb. Write in SQL a statement that adds to the table Products a new column named supplierlD of type Number(5).This column should be defined as a foreign key that relates the table Products to the table Supplierc. Write in SQL a query that lists all the details of products arranged in descending order according to the entrydatea. Write a SQL query that displays the number of products that will expire in the year 2021|e. Write in SQL a query that displays the ids of the most expensive products |f. Create a view named 'ProductDetails' to hold all the details of products whose names start with 'DELL' andtheir prices are between 200 and 500 Omani Rials

a Write in SQL a command that creates the table Products according to the above description a. Write in SQL a statement that adds to the table Products a new columm named supplierID of type Number(5). This column should be defined as a foreign key that relates the table Products to the table Supplier c. Write in SQL a query that lists all the details of products arranged in descending order according to the entry date

a Write in SQL a command that creates the table Products according to the above description a. Write in SQL a statement that adds to the table Products a new columm named supplierID of type Number(5). This column should be defined as a foreign key that relates the table Products to the table Supplier c. Write in SQL a query that lists all the details of products arranged in descending order according to the entry date

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

in sql The keyword that you would use to grant an object privilege to all database users is: Select one: a. PUBLIC b. ADMIN c. ALL d. GRANT
Adjust the following information so that1) all users on the system are able to run the SQL Executable and 2) multiple users (such as a team of software engineers) have the power to modify the SQL Executable Introduce any new groups that are needed and assign them group IDs USERS SQL Manager UID: 3 GROUPS SQL Users GID: 5 FILESDatabase File Owner 3 Group NA owner: rw group: - world: - setUID: 0 setGID: 0 sticky: 0 SQL Executable Owner 3 Group 5 owner: rwx group: r-x world: - setUID: 1 setGID: 0 sticky: 0
Assume the following tables: Student (studid, email, name) Club (clubid, telephone, name, #president) MemberOf(#clubid, #studid ) Activities(actid, actdt, place) Organize (#actid , #clubid , fee), Then answer the following questions by using SQL. 1- Create a stored procedure called 'StudentsActivities' to display the list of students and the activities in which they participated. 2- Create a stored Function called 'Checkavailability' to check whether 'Salalah Hall' is busy or not in a given date. 3- Create a stored Procedure called 'CheckavailabilityProc' to call the function 'Checkavailability' and display the appropriate message according to the value returned by the function (If function returns true, the procedure will display 'Salalah Hall is free on date ######' otherwise'Salalah Hall is busy on date ###### ').
In what situations might the SOUNDEX function be useful in SQL when querying text data?
8. Prepare SQL statement to find more than ONE (1) students supervised by an advisor. Display advisor name and number of advisee. Label the columns as AdvisorName, and NumberofSupervision respectively. SQL statements:
code BANK branches N ACCOUNT loanNo enrolls CUSTOMER phone address name Q1. Transform the ERD above to its corresponding Relational Schema. Q2. Using the transform ERD, Write appropriate SQL DDL statement to define the database. Q3. Specify the following queries in SQL. a.) Retrieve all account numbers with balance greater than 100,000. b.) Retrieve the bank name, branch name and account number of each customer account. c.) Find the average loan per branch. Q4. Write SQL update statements to do the following. a.) Insert new customer Manuel Cruz, with social security number of 987-65-4320 who lives at Iligan City and a contact number of 09170000001 b.) Marie Sanchez's loan amount was increased by 15,000. c.) Sergio Ramos opened a checking account with a minimum balance of 150,000 d.) Remove the account record with account number 262262100 name address accountNo SSN M N N offers balance address type N BRANCH loans M applies N branch No LOAN amount type
Convert the following statements into SQL queries. 1) i want to retrieve all records from a table student. 2) i want to retrieve all record from a table "student" who have marks greater than 80. 3) i want to delete all records from a table "student"
in sql The ALTER SEQUENCE statement can be used to: Select one: a. Change the maximum value to a lower number than was last used b. Change the name of the sequence c. Change the START WITH value of a sequence d. Change the amount a sequence increments each time a number is generated
PL/SQL Display the first name and last name of all employees who work for department 50 or have a salary greater than 3500. Handle the exceptions like No Data Found and Invalid Cursor
Database
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.
In sql how would you write a stored procedure with two parameters and check if those two are subsets of each other?