Question: Q1) Considering the following tables. Write the Sql code and the result of following questions using XAMPP (10 Marks) loan_number branch name amount customer_name loan_number

Q1) Considering the following tables. Write the Sql code and the result of following questions using XAMPP (10 Marks) loan_number branch name amount customer_name loan_number L-170 Downtown 3000 Jones L-170 L-230 Redwood 4000 Smith L-230 L-260 Perryridge 1700 Hayes L-155 loan borrower a) Find all loan number for loans made at the Perryridge branch with loan amounts greater than $1200. b) Find the loan number of those loans with loan amounts between $90,000 and $100,000 (that is, >= $90,000 and =

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

I want answer all the 3 question according to the lecture Q1) Considering the following tables. Write the Sql code and the result of following questions using XAMPP (10 Marks) loan_number branch name...

Database Management Systems: Part 1: create table Branch ( branch_id int NOT NULL PRIMARY KEY, branch_name VARCHAR2(50), branch_city VARCHAR2(50), assets NUMBER(11,2)); CREATE TABLE Loan (...

Q1) Giving the following tables (supplies, catalog, and part). For each part, show the query and demonstrate that it works correctly on the modified sample Parts/Suppliers/Catalog table insert into...

PLEASE ANSWER ONLY B & C :)))) Bank PKBO Q1: Considering the following E-R ATM diagram: A. Transform this E-R diagram into a set of 3NF relations and denormalize them if needed (Make up a primary key...

PLEASE DRAW ANSWER!! :) KO - Q1: Considering the following E-R ATM diagram: A. Transform this E-R diagram into a set of 3NF relations and denormalize them if needed (Make up a primary key where...

Q.1. Considering the following Case Scenario and answers the following questions. [20 marks] You have been working as a Project Manager in IT Company for last three years. Now you are assigned in a...

Write the code by mysql Q1. Create the following tables: client_master Q2- Insert the following data into their respective tables

database Q1- For the following tables find: a) Left join between the tables Product and Sales. b) Project the result of left join over Product_code, Product_name, and Unit_Price. c) Project table...

Q1: Create the following tables with the given attribute data types and constraints: (20 marks) Student id Number Primary Key name Variable character of 15 Not null major Variable character of 20 DOB...

code following using tuple relational calculus. Q1. Consider the following tables (relations) that contain information (all stored as names) about persons visiting theatres, movies played by...

The Naylor Corporation is considering two methods of raising working capital: (1) a commercial bank loan secured by accounts receivable and (2) factoring account receivables. Naylors bank has agreed...

Argile Textiles is evaluating a new product, a silk/wool blended fabric. Assume that you were recently hired as assistant to the director of capital budgeting, and you must evaluate the proposed...

Who wrote Utopia? anm Geoffrey Chaucer Arthur Waley Sir Thomas More Plato

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

6. The 100-employee information technology department of a financial services company had a high turnover rate. A survey of employees revealed that the reason most left was dissatisfaction with the...

7. Go to www.roiinstitute.net, the web site for ROI Institute, Inc., the leading resource on research, training, and networking for practitioners of the Phillips ROI Methodology.TM Click on Tools....

4. Sears designed a training program to improve tool and hardware sales. The two-hour program involved distance learning and was broadcast from the Sears training facility to 50 salespersons at 10...