1. Create a view named MAJOR_CUSTOMER. It consists of the customer number, name, bal- ance, credit limit, and rep number for every customer whose credit limit is $10,000 or less. a. Write and execute the CREATE VIEW command to create the MAJOR_CUSTOMER view. b. Write and execute the command to retrieve the customer number and name of each customer in the MAJOR_CUSTOMER view with a balance that exceeds the credit limit. Write and execute the query that the DBMS actually executes. d. Does updating the database through this view create any problems? If so, what are they? If not, why not? C. ODDER It consists of the item number, description, price,

1. Create a view named MAJOR_CUSTOMER. It consists of the customer number, name, bal- ance, credit limit, and rep number for every customer whose credit limit is $10,000 or less. a. Write and execute the CREATE VIEW command to create the MAJOR_CUSTOMER view. b. Write and execute the command to retrieve the customer number and name of each customer in the MAJOR_CUSTOMER view with a balance that exceeds the credit limit. Write and execute the query that the DBMS actually executes. d. Does updating the database through this view create any problems? If so, what are they? If not, why not? C. ODDER It consists of the item number, description, price,

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: For each order, list the order ID, customer ID, order date, and most recent date among all orders.…

A: Given data For each order, list the order ID, customer ID, order date, and most recent date among…

Q: Use SQL commands to finish the questions. Please show BOTH SQL commands and results in your answers.…

A: Hi.. Check below for answer query. Here i give a correct query if you already have table and…

Q: How can recursive functions be beneficial in SQL, and what are the potential pitfalls?

A: A recursive function in SQL refers to a function or query that calls itself repeatedly to solve a…

Q: Write a query to list all client ID(name and last names) and client type who have never checked out…

A: Given: Write a query to list all client ID(name and last names) and client type who have never…

Q: A query can have no more than three common interpretations. a) True b) False

A: The question is asking whether a query, in the context of computer science and specifically…

Q: 4. b. C. Create the following queries: List the names of places from which the company sells. Show…

A: The database contents are not mentionedThe generalized query can be written asSelect * from…

Q: Change to use the database frozenfood Alter table customerOrder add column total as data type…

A: Note: As per our guidelines we can able to solve only three questions. So, please re-post the…

Q: What is the query used to see if the date format is same and find values other than dates in the…

A: I am giving some examples along with queries to explain this. Suppose:…

Q: Please help and clearly explain step by step using access Create the following queries using the…

A: Q1-SELLING-LOCATIONS:Open "Query Design" from the "Create" tab.Add the table with selling…

Q: How can you get the alternate records from the table in the SQL?

A: Question. How can you get the alternate records from the table in the SQL? Answer. If you want to…

Q: This is the problem: (from Database Systems Book, 13th ed) Write a query to display the author last…

A: Create table AUTHORS_OF_BOOKS using the below query: SQL QUERY: /* Create a table called NAMES…

Q: List the names of the production companies and the titles of their movies. This time, include all…

A: Given that, The names of the tables are Movie and Production Assume that, The attributes of Movie…

Q: Write a query that uses INNER JOIN TO connect the EMPLOYEE, EMPPROJACT, PROJACT and PROJECT tables.…

A: The INNER JOIN is also referred as EQUIJOIN.The EQUIJOIN creates a new result table by combining…

Q: List the movie titles and the names of their production companies. Only include production companies…

A: SQL is the language that operates a databases, it includes database creations, deletions, fetching…

Q: e name of a field in an SQL query? When

A: How do you qualify the name of a field in an SQL query? When is it necessary to do so? give few…

Q: Explain the usage of the SELECT statement in a query, and where the WHERE clause might apply.…

A: The solution is given in the below step with example

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

please provide queries and not the theory which is already available at bartley.

Chapter 1). After each change, execute an appropriate query to show that the change was
Exercises
TAL Distributors
. SOL to make the following changes to the TAL Distributors database (see Figure 1-2 in
Ca correctly. If directed to do so by your instructor, use the information provided with the
Chanter 3 Exercises to print your output or save it to a document. For any exercises that use
commands not supported by your version of SQL, write the command to accomplish the task.
1. Create a view named MAJOR_CUSTOMER. It consists of the customer number, name, bal-
ance, credit limit, and rep number for every customer whose credit limit is $10,000 or less.
a. Write and execute the CREATE VIEW command to create the MAJOR_CUSTOMER
view.
b. Write and execute the command to retrieve the customer number and name of each
customer in the MAJOR_CUSTOMER view with a balance that exceeds the credit
limit.
c. Write and execute the query that the DBMS actually executes.
d. Does updating the database through this view create any problems? If so, what are
they? If not, why not?
2. Create a view named ITEM_ORDER. It consists of the item number, description, price,
order number, order date, number ordered, and quoted price for all order lines currently
on file.

Expert Solution

This question has been solved!

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

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1:

VIEW

Step 2: Queries FOR 1

VIEW

Step 3: Query for 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 3 steps

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

Using the relations in the appendix, write the following queries in SQL:i. Display a list of all instructors, showing each instructor’s ID and the number of sections taught. Your query should use an outer join, and should not use sub-queries.ii. Write the same query as in part a, but using a scalar subquery and not using outer join.iii. Display the list of all course sections offered in spring 2018, along with the ID and name of each instructor teaching the section. If a section has more than one instructor, that section should appear as many times in the result as it has instructors. If a section does not have any instructor, it should still appear in the result with the instructor name set to “—”.iv. Display the list of all departments, with the total number of instructors in each department, without using sub-queries. Make sure to show departments that have no instructors, and list those departments with an instructor count of zero.
8. Using a subquery in the FROM clause, find the average unit price of in-stock trucks of any make/model in SQL.
You will be using the Colonial Adventure Tours database. How many current reservations does Colonial Adventure Tours have and what is the total number of persons for all reservations?
write a PL/SQL procedure to find the Maximum of the two values
Inconsistencies:Although update queries can help, you still need human intervention to remove inconsistent values. T to F?
Use SQL and TAL Distributors database to complete the following questions:List the customer number and name for all customers located in the city of Grove. Your query should ignore case. For example, a customer with the city Grove should be included as should customers whose city is GROVE, grove, GrOvE, and so on.