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

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter4: Constraints

Section: Chapter Questions

Problem 11MC: In the initial creation of a table, if a UNIQUE constraint is included for a composite column that...

See similar textbooks

Related questions

Q: Table Schema: Amazon_Item (P#, P_NAME, SELL_PRICE, QTY) Amazon_Supply (S#*, P#*, SUP_PRICE)…

A: We need to find all product names whose selling price is 100% more than their supply price. 100%more…

Q: Write a query in SQL to list the titles of the employees for a specific date

A: Hello student Greetings Hope you are doing great. Thank You!!!

Q: Write an SQL query for the following questions: List the name of doctors with the number of written…

A: List the name of doctors with the number of written prescriptions SELECT dd.first_name, dd.last_name…

Q: Write SQL queries to answer the following questions:a. Which studen ts have an ID number that is…

A: SQL queries are given below

Q: Create the following SQL queries, referencing the university schema as a starting point. Find the…

A: Introduction: Structured Query Language (SQL) is an acronym for Structured Query Language. SQL is a…

Q: Create the following SQL queries with the university schema in mind. Find the lowest maximum salary…

A: Query for determining the minimum wage Using the select statement, you may get data from a database.…

Q: Using the university schema, write the following SQL queries. Find the lowest per-department maximum…

A: The syntax for the MIN function in SQL is: SELECT MIN(aggregate_expression) FROM tables [WHERE…

Q: Write an SQL query to find the manufacturer and model for all aircraft models with capacity at least…

A: The query is

Q: 5. Write a query to get the total salaries payable to employees. 6. Write a query to get the…

A: Sorry, we are supposed to answer only three subparts of question ad kindly resubmit the remaining…

Q: 4) Write the following SQL queries in Algebraic Query form. Query 1: SELECT Pnumber, Dnum, Lname,…

A: Solution: Given,

Q: 3) Write an SQL query to display the accountno, name, Recurrent_acno, transaction_date whose Fixed…

A: Required:

Q: 7) Write an SQL query to count how many account holders belong to each recurrent_acno

A: NOTE Below is the answer for the given question. Hope you understand it well. If you have any…

Q: Using the table Student and Course already available in the given workspace, execute the following…

A: REFER:- Refer syntax of below --> Outer Joins: Three types of outer join LEFT JOIN RIGHT JOIN…

Q: Determine the output of the following SQL queries. 1. SELECT DATEADD(minute, 3, DATEADD(second, 30,…

A: As per the guidelines, we are advised to answer only the first three subparts of a question. Please…

Q: Define MINUS and give one (1) example in ORACLE SQL commands.

A: In Oracle, MINUS operator is used to return all rows in the first SELECT statement that are not…

Q: Write an appropriate SQL query to delete the following record from the STUDENTS table:…

A: Answer: We need to write the query for the delete the record from the table so we will see in the…

Q: Construct an appropriate SQL query (Create Table) for the following i. Member ii. Make

A: “Since you have asked multiple questions, we will solve the first question for you. If you want any…

Q: Write an appropriate SQL query to determine which student is registered for the most credits (total…

A: In this question we have to write a sql query for given statement and table. Let's complete the sql…

Q: Write a SQL query to find the number of students in the school from the table: Students (RollNo.,…

A: Given Table: Students (RollNo., Name, Father'sName, Class, Mobile No., Address) To Find: Count of…

Q: Q-4. Write an SQL query to print all Worker details from the Worker table order by FIRST NAME…

A: Answer 4. SQL Query to print details of the workers from Worker table order by First_Name Ascending…

Q: Write SQL/PLSQL to perform the following functionalities: 1-Write trigger which prevents any CRUD…

A: To create and enable a database trigger, use the CREATE TRIGGER statement, which is: A stored…

Q: List all book information for the book or books which sold for the average price of all books sold…

A: We need to display all book information for the book or books which sold for the average price of…

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

A: SQL Query: Query Output:

Q: Write a PL/SQL block to select and display the names of all students who scored more than the…

A: Given values, Student_ID Name of Student Marks Obtained Department_ID 1 Asma 78 1 2 Anwar…

Q: 13. Describe the function of the following SQL code. update student set age = age +1

A: The function of the Query update student set age = age + 1 is

Q: Salary from highest to lowest Sorting emp name alphabet

A: Please find the answer below

Q: Write the following queries in SQL, using the university schema. Find the lowest, across all…

A: Query for selecting minimum salary The select statement is used to select data from a database.…

Q: a) Consider the following tables: Employee (Emp_no, Name, Emp_city, Company_name, Salary) ni. a)…

A: Given table is, Employee (Emp_no, Name, Emp_city, Company_name, Salary) The name of the table is…

Q: 3) Write an SQL query to display the accountno, name, Recurrent_acno, transaction_date whose Eixed…

A: NOTE Below is the answer for the given question. Hope you understand it well. If you have any…

Q: 35. From the product_price table, write an SQL query to find the total and average market price for…

A: We are going to write SQL query for the given statement.

Q: Using SQL DML statements, write SQL statements using the instance of the DreamHome case study to;…

A: NOTE: Student asked only the statements for Inserting record , update record and list the branches.…

Q: Write the standard MYSQL query to retrieve the average customer balance grouped by SalesRepNo Write…

A: I have provided answers in step 2.

Q: ascending order using status. d. Write an SQL query to find the number of clients from each order_no…

A: Answer: select count(*) from client_details group by order_no having cost not null;

Q: Write an appropriate SQL query to determine if there are any students that are not registered for…

A: Given: Write an appropriate SQL query to determine if there are any students that are not registered…

Q: te An SQL Query To Fetch “FIRST_NAME” From Worker Table Using The Alias Name As <WORKER_NA

A: Lets see the solution.

Q: Write and run an SQL query to list all students and courses they are registered for. Include, in…

A: Given: To Write and run an SQL query to list all students and courses they are registered for.…

Q: Write an appropriate SQL query to delete the following record from the STUDENTS table: STUDENT_ID:…

A: Here is the solution:

Q: Write a SQL query to list the product code, vendor code, and vendor name for all products and…

A: Use a right outer join or left outer join based on where we are specifying the VENDOR and PRODUCT If…

Q: Question: Which colleges offer courses? (Change the SQL query to an relational algebra query.)…

A: Given Sql query will provide college name from course relation with department code in course is…

Q: SQL query select with condition of multiple values from column?

A: What is SQL query Ans :- An SQL SELECT statement gets records from a database table based on…

Q: c) Write the standard MYSQL query to retrieve the Name and CustNumber of customers with a balance…

A: In the question it is asked for retrieving the Name, But in the CUSTOMER table there is column name…

Q: Suppose that you want a table listing for the following conditions: the V CODE is either 25595 or…

A: To write a SQL query.

Q: Create a PL/SQL query to display the customer name, employee name and the coin product returned. In…

A: SELECTconcat(left(CUSTOMER_TABLE.FIRST_NAME,1),'.',CUSTOMER_TABLE.SURNAME) AS…

Q: According to the given database schema, develop a SQL query to find the model number of the phone…

A: According to the given problem statement we have to develop a SQL code to find the model number of…

Q: a) Consider the following tables: Employee (Emp_no, Name, Emp_city, Company_name, Salary) i. a)…

A: Since there are multiple questions asked in the same query so we will be answering the first three…

Q: Write a SQL query to retrieve the First_name of employees having any of the following SSN_NUMBER…

A: We have to fetch the record with the SSN number 123456789, 987654321.

Q: The query that will show the customer records sorted according to region_id SELECT * FROM customer…

A: The correct option is c) SELECT * FROM customer ORDER BY region_id

Q: Create a SQL query to display the combined customer name, employee id, delivery notes, coinordered…

A: Answer:)

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 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.
Perform the following tasks: a. Create an index named ITEM_INDEX1 on the ITEM_NUM column in the ORDER_LINEtable. b. Create an index named ITEM_INDEX2 on the CATEGORY column in the ITEMtable. c. Create an index named ITEM_INDEX3 on the CATEGORY and STOREHOUSE columnsin the ITEM table. d. Create an index named ITEM_INDEX4 on the CATEGORY and STOREHOUSEcolumns in the ITEM table. List categories in descending order.
In the initial creation of a table, if a UNIQUE constraint is included for a composite column that requires the combination of entries in the specified columns to be unique, which of the following statements is correct? a. The constraint can be created only with the ALTER TABLE command. b. The constraint can be created only with the table-level approach. c. The constraint can be created only with the column-level approach. d. The constraint can be created only with the ALTER TABLE MODIFY command.
Create a view called HOMEWORK13 that includes the columns named Col1 and Col2 from the FIRSTATTEMPT table. Make sure the view is created even if the FIRSTATTEMPT table doesn’t exist.
Create the following indexes: a. Create an index named TRIP_INDEX1 on the TRIP_NAME column in the TRIPtable. b. Create an index named TRIP_INDEX2 on the TYPE column in the TRIP table. c. Create an index named TRIP_INDEX3 on the LAST_NAME and FIRST_NAME columns in the CUSTOMER table.
Create a table named BOOK_STORES to include the columns listed in the following chart.
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

Recommended textbooks for you

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning

A Guide to SQL

Computer Science

ISBN:

9781111527273

Author:

Philip J. Pratt

Publisher:

Course Technology Ptr

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Np Ms Office 365/Excel 2016 I Ntermed

Computer Science

ISBN:

9781337508841

Author:

Carey

Publisher:

Cengage

Programming with Microsoft Visual Basic 2017

Computer Science

ISBN:

9781337102124

Author:

Diane Zak

Publisher:

Cengage Learning

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning

A Guide to SQL

Computer Science

ISBN:

9781111527273

Author:

Philip J. Pratt

Publisher:

Course Technology Ptr

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Np Ms Office 365/Excel 2016 I Ntermed

Computer Science

ISBN:

9781337508841

Author:

Carey

Publisher:

Cengage

Programming with Microsoft Visual Basic 2017

Computer Science