1. a) Create a table bank_masterColumn NameDatatypeVarchar2(4)Varchar2(30)Varchar2(30)Number (7)b) Insert the records using the following table valuesConstraintaccountnoNot NullnameaddressamountaccountnonameAddressamount101MohamedBurka9000102NasserNizwa8000103KhamizSohar8200104MurshidBurka7800106MustasimSohar9500a) Create a table bank_detailsColumn NameDatatypeVarchar2(4)number(4)dateConstraintRecurrent_acnoNot Nullac_noTransaction_dateFixed_depositNumber(8)b) Insert the records using the following table valuesRecurrent_acno | ac_noTransaction_dateFixed_depositС10110112.05.200210000C10210213.01.202080000C10310314.02.202150000C10110413.05.202040000C10210515.06.2019null 6) Write an SQL query to find the minimum fixed deposit of each recurrent_acno whosetransaction_date between 12.05.2002 and 13.05.2020 and their fixed_deposit amount 10000 or40000

Statement to create table: CREATE TABLE bank_details ( Recuurent_acno VARCHAR(24), ac_no INT,…

Answered: 6) Write an SQL query to find the…

6) Write an SQL query to find the minimum fixed deposit of each recurrent_acno whose transaction_date between 12.05.2002 and 13.05.2020 and their fixed_deposit amount 10000 or 40000

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

Related questions

Q: in pl/sql ,use Cursor to get all the records from table job_history for employee_id 121

A: pl/sql code for the above question is solved in step 2:- assume table job_history has columns…

Q: How does the CONCAT_WS function provide advantages over the traditional CONCAT function in SQL?

A: CONCAT_WS function is an SQL function that is used to add two or more strings together with the…

Q: Create the following table in your database with the following schema: Table: Departments Column…

A: Required statement table creation and inserting data in university database given below.

Q: Create the following table in your database with the following schema: Table: Products Column Name 1…

A: As per our guidelines, only 3 sub parts will be answered. So, please repost the remaining questions…

Q: Create a PL/SQL function to increment the salary of all employees of an organization by 15%, and for…

A: Creating a PL/SQL function to increment the salary of all employees of an organization by 15%, and…

Q: What is the significance of the ROW_NUMBER function when dealing with duplicate rows in SQL?

A: SQL stands for Structured Query Language which is used to communicate with a database. It is the…

Q: Using DML SQL, write the appropriate SQL query for each of the following: Insert A new customer…

A: In SQL, DML stands for Data manipulation language which contains Select, Insert, Delete and Update…

Q: Create a PL/SQL query to display the combined customer name, coin purchased, coin price andthe…

A: THE GIVEN SQL QUERRY FOR THE QUESTION

Q: Write an SQL query using the ALTER TABLE and ADD operator to add anattribute named ORDERDATE with…

A: ALTER TABLE command: The ALTER TABLE command is used to add new columns, modify columns in an…

Q: What values are returned while the given query is executed? SELECT 2* (Balance - Payment) FROM…

A: The query selects the result of the expression 2*(Balance - Payment) for each row in the "Customer"…

Concept explainers

Intermediate SQL Concepts

A query is a request for data or information from one or more database tables. This information could be presented in the form of pictorials, graphs, or complicated findings which helps in easy interpretation. Structured Query Language (SQL) is the most widely used programming language for retrieving and organizing data from relational databases. Collection of tables with rows and columns is referred to as a database. SQL is the language of databases. It makes it easier to extract specific data from databases, which can then be used for analysis.

Question

1. a) Create a table bank_master
Column Name
Datatype
Varchar2(4)
Varchar2(30)
Varchar2(30)
Number (7)
b) Insert the records using the following table values
Constraint
accountno
Not Null
name
address
amount
accountno
name
Address
amount
101
Mohamed
Burka
9000
102
Nasser
Nizwa
8000
103
Khamiz
Sohar
8200
104
Murshid
Burka
7800
106
Mustasim
Sohar
9500
a) Create a table bank_details
Column Name
Datatype
Varchar2(4)
number(4)
date
Constraint
Recurrent_acno
Not Null
ac_no
Transaction_date
Fixed_deposit
Number(8)
b) Insert the records using the following table values
Recurrent_acno | ac_no
Transaction_date
Fixed_deposit
С101
101
12.05.2002
10000
C102
102
13.01.2020
80000
C103
103
14.02.2021
50000
C101
104
13.05.2020
40000
C102
105
15.06.2019
null

6) Write an SQL query to find the minimum fixed deposit of each recurrent_acno whose
transaction_date between 12.05.2002 and 13.05.2020 and their fixed_deposit amount 10000 or
40000

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step 3

VIEW

Step by step

Solved in 3 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

Create a function to increment the salary of employees of an organization by 15%, and for employees with department ID 100 give another 10% hike on the updated salary. Also, write the query to update the salary of all records of the salary column in the employee table using the created function. In PL/SQL
I need help with this SQL query: Write a MySQL statement to create a table named jobs including columns job_id, job_title, min_salary and max_salary, and check whether the min_salary amount is lower than the lower limit $15,000 and whether the max_salary amount exceeds the upper limit $50,000.
By using this table answer this question in SQL: Show the department id, department name and the number of employees working in any department which has less than 4 employees
Write an SQL query using the AND operator that show all orders shoppedon April 1, 2009 shipped to the state of Florida
Write the full sql query including (create,insert,select...) please
SQL query using Rank() Retrieve the top-selling product of each day.Use the total sold quantity to determine the top-selling product.The top-selling product has the highest total sold quantity.If there is a tie, the solution must pick up the tie.Include the order date, product id, and the total sold quantity of the top-selling product of each day in the returned data.Sort the returned data by the order date.*/
Please help with pl/sql block!
Write an SQL query using the UPDDATE and SET operator that willoverwrite all values containing 16 with 32 in the SupplierID attribute inthe Products table.
How can the DATEDIFF function be used to calculate the time difference between two dates in SQL?
By using this table answer this question in SQL : Write a SQL query, which shows a list of all employees last name, their department names and their department city where that department is located from the employees table. If an employee does not belong to a department, then their department number and department name should show as “N/A” and their department city should show up as “No City info Found”. MAKE SURE you have all the employees displayed including the employees who do not have a department.
The following database will be used in this question: SALESREP SalesRepNo 654 734 345 434 RepName Jones Smith Chen Johnson HireDate 01/02/2005 02/03/2007 01/25/2004 11/23/2004 CUSTOMER CustNo 9870 8590 7840 4870 CustName Winston Gonzales Harris Miles Balance 500 350 SalesRepNo 345 434 654 345 800 100
Write SQL CODE List all the Course Code (CRS_CODE) that are taught by a Professor that does not hold "Ph.D." as the highest degree (based on PROF_HIGH_DEGREE in the PROFESSOR table).