Modern Database Management
13th Edition
ISBN: 9780134792293
Author: Hoffer
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 6, Problem 6.84PAE
Program Plan Intro
a. SQL query to list the product ID for all products that have sold more than 20 units across all orders,
Program Plan Intro
b. Modify the above query to list all the IDs for the orders and number of products on those orders.
Program Plan Intro
c. Modify the above query in part b to list all the product that were sold on the orders that are result of part b.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Detailed answer
Business Rules:
Each musician at NewTalent should have a name, address, and phone number on the system. The Instruments used in the songs have a unique name, musical genre (i.e. rock, pop, hip hop), and type (i.e. string, piano, guitar). Every album recorded under the NewTalent label has a title, copyright date, format, and an album identifier. Each song recorded has a title and an author. Musicians can play several instruments, and an instrument can be played by multiple musicians. Every album contains several songs, but a song can only appear on one album. Songs are performed by one or more musicians, and a musician can perform numerous songs. Each album has one musician acting as its producer, although a musician can produce multiple albums.
Create an ERD for the above scenario that describes its business rules.
Use Crow's Foot notations and make sure to include all of the following:
All entities correctly identified with Primary key and any foreign key attributes.…
need diagram only
Draw an ER diagram for the following scenario:
A designer has a store of designer dresses both for male and female.
People can buy as well as take dresses on rent from the store.
Each dress in the designer's store, is identified by unique ID.
A dress in the store can be categorized into various categories Western, Indian, Indo-westem, etc.
The designer maintains the name, phone number of people who have taken dresses on rent.
The designer also maintains the name, phone number, and address of people who have bought dresses from the store.
The designer also collects feedback from the people who have bought or taken dresses on rent from the store.
Design the ER diagram by mentioning all the structural constraints. You may also include additional information in addition to the requirements listed.
Chapter 6 Solutions
Modern Database Management
Ch. 6 - Define each of the following terms: dynamic view...Ch. 6 - Match the following terms to the appropriate...Ch. 6 - Prob. 6.3RQCh. 6 - Prob. 6.4RQCh. 6 - Prob. 6.5RQCh. 6 - Explain the relationship between EXISTS and...Ch. 6 - Prob. 6.7RQCh. 6 - Under what conditions can a UNION clause be used?Ch. 6 - Prob. 6.9RQCh. 6 - Explain why it is necessary to limit the kinds of...
Ch. 6 - Describe a set of circumstances for which using a...Ch. 6 - Prob. 6.12RQCh. 6 - Prob. 6.13RQCh. 6 - Prob. 6.14RQCh. 6 - Prob. 6.15RQCh. 6 - Prob. 6.16RQCh. 6 - Prob. 6.17RQCh. 6 - Prob. 6.18RQCh. 6 - Prob. 6.19RQCh. 6 - List for advantages of SQL-invoked routines.Ch. 6 - Prob. 6.21RQCh. 6 - Prob. 6.22RQCh. 6 - Prob. 6.23RQCh. 6 - This chapter discusses the data dictionary views...Ch. 6 - Write an SQL query to answer the following...Ch. 6 - Write SQL retrieval commands for each of the...Ch. 6 - Write an SQL query to answer the following...Ch. 6 - Write SQL queries to answer the following...Ch. 6 - Write SQL queries to answer the following...Ch. 6 - Write an SQL query to answer the following...Ch. 6 - Prob. 6.31PAECh. 6 - Prob. 6.32PAECh. 6 - Prob. 6.33PAECh. 6 - What do you need to do if a tutor signs up and...Ch. 6 - Prob. 6.35PAECh. 6 - Write the SQL query to find any tutors who have...Ch. 6 - Prob. 6.37PAECh. 6 - Write an SQL query to determine the total number...Ch. 6 - Prob. 6.39PAECh. 6 - Prob. 6.40PAECh. 6 - Prob. 6.41PAECh. 6 - Prob. 6.42PAECh. 6 - Prob. 6.43PAECh. 6 - Which tutor needs to be reminded to tum in...Ch. 6 - Prob. 6.45PAECh. 6 - Write an SQL query to list all product line names...Ch. 6 - Modify to include only those product lines the...Ch. 6 - Prob. 6.48PAECh. 6 - Prob. 6.49PAECh. 6 - Write an SQL query to display the order number,...Ch. 6 - Prob. 6.51PAECh. 6 - Prob. 6.52PAECh. 6 - Prob. 6.53PAECh. 6 - Prob. 6.54PAECh. 6 - Prob. 6.55PAECh. 6 - Prob. 6.56PAECh. 6 - Prob. 6.57PAECh. 6 - Prob. 6.58PAECh. 6 - Write an SQL query to list each customer who...Ch. 6 - Prob. 6.60PAECh. 6 - Modify Problem and Exercise 6-60 so that the list...Ch. 6 - Prob. 6.62PAECh. 6 - Prob. 6.63PAECh. 6 - Prob. 6.64PAECh. 6 - Prob. 6.65PAECh. 6 - Prob. 6.66PAECh. 6 - Prob. 6.67PAECh. 6 - Prob. 6.68PAECh. 6 - Prob. 6.69PAECh. 6 - Prob. 6.70PAECh. 6 - Prob. 6.71PAECh. 6 - Rewrite your answer to Problem and Exercise 6-71...Ch. 6 - Display the customer ID, name, and order ID for...Ch. 6 - Prob. 6.74PAECh. 6 - Prob. 6.75PAECh. 6 - Prob. 6.76PAECh. 6 - Prob. 6.77PAECh. 6 - Prob. 6.78PAECh. 6 - Prob. 6.79PAECh. 6 - Write an SQL query to list the order number,...Ch. 6 - Prob. 6.81PAECh. 6 - Prob. 6.82PAECh. 6 - Prob. 6.83PAECh. 6 - Prob. 6.84PAECh. 6 - Prob. 6.85PAE
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
- A book is identified by its ISBN number, and it has a title, a price, and a date of publication. It is published by a publisher, which has its own ID number and a name. Each book has exactly one publisher, but one publisher typically publishes multiple books over time.arrow_forwardA company has various rules for how payments to suppliers are to be authorized.Some payments are in response to an approved purchase order. For approved purchase orders under $5,000, the accountingclerk can immediately issue a check againstthat purchase order and sign the check. Forapproved purchase orders between $5,000and $10,000, the accounting clerk can immediately issue a check but must additionallyobtain a second signature. Payments for approved purchase orders over $10,000 alwaysrequire the approval of the accounting manager to issue the check as well as the signature of two accounting clerks. Payments thatare not covered by a purchase order that areunder $5,000 must be approved by the accounting manager and a departmental manager who will absorb the cost of the paymentinto that department’s budget. Such checkscan be signed by a single accounting clerk.Payments that are not covered by a purchaseorder that are between $5,000 and $10,000must be approved by the accounting…arrow_forwardHow are handoffs between vehicles protected?arrow_forward
- Draw an ER diagram that captures the following information: A book identified by (unique Id number, a title and one or more authors), A library identified by (unique name and adders), A borrower has a name and a unique ID code. The library service may own several copies of a given book. A borrower can have many books on loan, but each copy of a book can only be on loan to one borrower. A borrower could borrow the same book on several occasions, but it is assumed that each such loan will take place on a different date. *arrow_forwardshould use Lucidchart to draw the ERD.arrow_forwardOne-to-many relationships are defined.arrow_forward
- An employee has only one job code, but a job code can be held by many employees. ERDarrow_forwardUse the information below and create a use case diagram.arrow_forwardEach publisher has a unique name; a mailing address and telephone number are also kept on eachpublisher. A publisher publishes one or more books; a book is published by exactly one publisher. Abook is identified by its ISBN, and other attributes are title, price, and number of pages. Each book iswritten by one or more authors; an author writes one or more books, potentially for differentpublishers. Each author is uniquely described by an author ID, and we know each author's name andaddress. Each author is paid a certain royalty rate on each book he or she authors, which potentiallyvaries for each book and for each author. An author receives a separate royalty check for each book heor she writes. Each check is identified by its check number, and we also keep track of the date andamount of each check.TasksDesign a SQL database using the above US superstore sales data set.1.Use Visual Paradigm to draw conceptual diagram2.Use Visual Paradigm todraw ERDarrow_forward
- Programming language: SQL Tool: Oracle SQL Developer The database schema Employee (Lastname, FirstName, MidInitial, gender, street, city) Works (Lastname, FirstName, MidInitial, company-name, salary) company (company-name, city) company (company-name, city) Manages(Lastname, FirstName, MidInitial, ManagerLastname, MFirstName, MMidInitial, start-date) Manages(Lastname, FirstName, MidInitial, ManagerLastname, MFirstName, MMidInitial, start-date) employee_table (you should define three attributes for employee and manager names) Name street city gender -------------------------------------------------------- Anderson, Susan L 108th Omaha F Brady, Dan L P street Lincoln M Chen, Peter K 124th Omaha M Clemson, Ann M O Lincoln F Dale, Mary K 132th Omaha F Gill, Mary L P street Lincoln F Harrison, Susan…arrow_forwardWhen is it necessary to qualify the name of a field, and how do you go about doing so?arrow_forwardhelparrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Operations Research : Applications and AlgorithmsComputer ScienceISBN:9780534380588Author:Wayne L. WinstonPublisher:Brooks Cole
COMPREHENSIVE MICROSOFT OFFICE 365 EXCEComputer ScienceISBN:9780357392676Author:FREUND, StevenPublisher:CENGAGE LNp Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage
A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology Ptr
Operations Research : Applications and Algorithms
Computer Science
ISBN:9780534380588
Author:Wayne L. Winston
Publisher:Brooks Cole
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr