Question: Following tables with data are created: AGENTS (agent_code, agent_name, working_area, commission, phone_no, country) CUSTOMERS (cust_code, cust_name, cust_city, working_area, cust_country, grade, opening_amt, receive_amt, payment_amt, outstanding_amt, phone_no,

Following tables with data are created: AGENTS (agent_code, agent_name, working_area, commission, phone_no, country) CUSTOMERS (cust_code, cust_name, cust_city, working_area, cust_country, grade, opening_amt, receive_amt, payment_amt, outstanding_amt, phone_no, agent_code)

1. Create a view 'agentview6' with customer name, agent name from the table 'agents', and customers with the following condition:

Customers agents working area is in 'London'

2. Create a view 'top_customer' as the table 'customer' with the following conditions -

opening_amt, receive_amt, payment_amt, outstanding_amt is greater than 5000

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!

Exercises: a) Insert at least 5 rows for each table (logical insertion). b) Find all agents that have at least one customer. c) Find all agents that have customers with order amount higher than 10....

Your work for a company that sells and installs landscaping plants. Your job is to k track of plant sales (related to landscaping), property locations where landscaping work has been accomplished (or...

Chapter 1 0 ( 3 0 pts ) Database Design Complete the following database design based on the requirements. If you chose to free - hand draw your solution, you can either scan it or take a picture of...

my question in the picture please answer correctly with upvote thank you. this is the unclear picture edioil LLC, a company manufactoring edible oil is currently using all - rail route logitic system...

1a) Write one or more scripts to set up the following tables with data as shown below, then run them using SQLplus. As you can guess, ArtPop means the popularity of a particular Artist, perhaps...

Styles Paragraph installs landscaping plants. Your job is to keep Your work for a company that sells and track of plant sales (related to landscaping), property locations where landscaping work has...

Risk classes and RADR Moses Manufacturing is attempting to select the best of three mutually exclusive projects, X, Y, and Z. Although all the projects have 5-year lives, they possess differing...

Accounting Unlimited tries Contents Notebook A veterinarian office uses a relational database to store information about employees, customers, and services the company provides (information about...

3. Under the industry index model, the return on a share in Company i, which is in Industry j. is described by the formula: R; = a; + bim?... + bijl+4 You have been given the following tables of data...

4) You will create and use a new second database, sem_projectB. Your script must be able to be run repeatedly as a single file. Add the following tables, Add data with a single INSERT for each table:...

The report Improving Undergraduate Learning (Social Science Research Council, 2011) summarizes data from a survey of several thousand college students. These students were thought to be...

Let xn R and suppose that there is an M R such that |xn| s2 > . Prove an analogous result about...

With respect to the at - risk rules, qualified nonrecourse financing is a debt A ) that is convertible into an equity interest. B ) for which at least one individual is personally liable. C ) from a...

P-1) (100 Pts.) A chemical manufacturing company (CMC) has a contract for the procurement of the neccssaly chemicals from four suppliers. The chemicals purchased from Supplier A are priced at $20...

In the Meteor case study, what were the key aspects of the meeting that left Sarah satisfi ed and enthusiastic?

Read the article on which focus on research 5.4 is based and give your views on what diffi culties could be faced by introducing 360-degree feedback at a university.

Moving the goalposts, taking the goalposts away and changing the rules of the game can all present diffi culties. Take each of these situations in turn and present arguments from the viewpoint of...