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 4) Write an SQL query to display Name, address,transaction_date,fixed_deposit from bank_masterandbank_details tables.[right Outer Join]

The given problem is related to Oracle data base SQL where the requirement is to make tables named…

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

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

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

SQL QUERY!!
q17
List all products with their highest unit price, i.e. not discounted.the database is
Correct Query from table given.
Q5) What is the normalization of the following table, where the primary keys are underlined: Note: all the data in cells of the table are already atomic. OrderID Order Date 1006 1006 10/24/2010 1006 1007 10/24/2010 1007 10/24/2010 10/25/2010 10/25/2010 Customer Customer Customer ProductID Product ID Name Address Description 2 2 2 6 6 Value Furniture Value Furniture Value Furniture Plano, TX Plano, TX Plano, TX Furniture Boulder, Gallery CO Furniture Boulder, Gallery CO 7 5 4 11 Dining Table Writer's Desk Product Product Finish Standard Price 4-Dr Dresser Natural 800.00 Ash Cherry 325.00 Entertainment Natural 650.00 Center Maple 500.00 4 Entertainment Natural 650.00 Center Maple Ordered Quantity 2 2 1 4 3
5) Write an SQL Query to display the accountno, name, Recurrent_acno, amount whose fixed deposit Less than 80000. (Use inner join)
For below relational tables try to insert given data in PERSON table in given sequence, if you cannot insert data due to violation of a constraint (show 5 errors) just write “error” to the “operation status”
MySQL CREATE TABLE students ( id INT PRIMARY KEY, first_name VARCHAR(50), last_name VARCHAR(50), age INT, major VARCHAR(50), faculty VARCHAR(50)); CREATE TABLE location ( id INT PRIMARY KEY, name VARCHAR(50), rooms INT); CREATE TABLE faculty ( id INT PRIMARY KEY, name VARCHAR(50), department_id INT); 4. Find the number of employees in each department who get no commission or have salary less than5000.5. Find the maximum salary of employees in each department that the employee was hired 15 yearsbefore now. *hint: user TIMESTAMPDIFF(<unit type>,<Date_value 1>,<Date_value 2>), the unitcan be YEAR, MONTH, DAY, HOUR, etc...6. Find the last name of all employees that were not hired on Tuesday *hint: (UseDATE_FORMAT() function amd the format you need is %W, also use UPPER()7. Find the number of employees in each department who have a manager.8. Find the number of employees for each manager whose employees' minimum salary is greaterthan 5000.9. Find the number of…
What is the maximum number of columns you can define as a primary key when using the column-level approach to creating a table? ( refer to the tables in the JustLee Books database). a. 0 b. 1 c. 30 d. 255
Instructorld 1 • Courseld CourseCode 9630 MATH109 Course CourseName Linear Algebra Capacity 175 4964 PHILAT Intro to Philosophy 50 4253 MATH19 Number Theory 150 1896 HIST66 American History 25 8048 HIST58 World History 125 2133 Instructor Instructorld InstructorName Rank Department Del Day Associate Professor Math Rob Ruiz Associate Professor Philosophy Aya Diaz Associate Professor History Note: Both tables may not be necessary to complete this level. Select the rows returned by the query below. SELECT CourseName, Capacity, InstructorId FROM Course C WHERE Capacity > (SELECT AVG (Capacity) FROM Course WHERE InstructorId = c.InstructorId); CourseName Linear Algebra Capacity Instructorld 175 1 Intro to Philosophy 50 2 150 Number Theory American History 25 World History 125 2133
Task Write a query to retrieve the records of students who have their total marks greater than or equal to 500 Total marks refer to the sum of the marks of a single student. The result should be in the following format • STUDENT ID • SUM OF MARKS The result should be sorted in descending order by STUDENT D Table description Table: marks Name STUDENT_ID Type Description INTEGER This is the student's unique ID These are the marks obtained STUDENT MARKS INTEGER