Modern Database Management (12th Edition)
12th Edition
ISBN: 9780133544619
Author: Jeffrey A. Hoffer, Ramesh Venkataraman, Heikki Topi
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Question
Chapter 6, Problem 6.77PAE
Program Plan Intro
To list:
The total number of ordersfor 2018.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Can you explain the data dictionary's function inside the DBLC procedure?
. Write the following inserts, deletes, updates, and select in SQL.a. Increase the salary of each instructor in the Comp. Sci. department by 10%.b. Delete all courses that have never been offered (i.e., do not occur in the section relation).c. Insert every student whose tot cred attribute is greater than 100 as an instructor in the same department, with a salary of $10,000.d. Find the ID and name of each student who has not taken any course offered before 2017.
using oracle sql
Create the DONORS table with the following columns: donor_id ( PRIMARY KEY), donor_name (Not Null), donor_age. Then Create DONATIONS table with the following columns: pledge_id (PRIMARY KEY), pledge_date, amount_pledged, amount_paid, Is_paid, donor_id that REFERENCES to DONORS table (donor_id).
2- Populate every relation with three rows.
3- Now, your supervisor has asked you to modify the donor_age column in the DONORS table. He wants the column to be configured to accept a value that must be >=20. Which statement should you issue to accomplish this task?
4- Create a Trigger to update Is_paid column to 1 when the amount_paid equal to amount_pledged.
Chapter 6 Solutions
Modern Database Management (12th Edition)
Ch. 6 - Prob. 6.1RQCh. 6 - Prob. 6.2RQCh. 6 - Contrast the following terms: a. base table; view...Ch. 6 - Prob. 6.4RQCh. 6 - Prob. 6.5RQCh. 6 - Prob. 6.6RQCh. 6 - List six potential benefits of achieving an SQL...Ch. 6 - Prob. 6.8RQCh. 6 - Distinguish among data definition commands, data...Ch. 6 - Prob. 6.10RQ
Ch. 6 - Prob. 6.11RQCh. 6 - Prob. 6.12RQCh. 6 - Prob. 6.13RQCh. 6 - Drawing on material covered in prior chapters,...Ch. 6 - Explain and provide at least one example Of how to...Ch. 6 - Prob. 6.16RQCh. 6 - What is the difference between COUNT, COUNT...Ch. 6 - What is the evaluation order for the Boolean...Ch. 6 - If an SQL statement includes a GROUP BY clause,...Ch. 6 - Prob. 6.20RQCh. 6 - Prob. 6.21RQCh. 6 - Prob. 6.22RQCh. 6 - Explain why SQL is called a set-oriented language.Ch. 6 - When would the use of the LIKE key word with the...Ch. 6 - Prob. 6.25RQCh. 6 - Prob. 6.26RQCh. 6 - In what order are the clauses of an SQL statement...Ch. 6 - Within which clauses of an SQL statement can a...Ch. 6 - Prob. 6.29RQCh. 6 - Prob. 6.30RQCh. 6 - Prob. 6.31RQCh. 6 - Explain the difference between the WHERE and...Ch. 6 - Prob. 6.33RQCh. 6 - Prob. 6.34PAECh. 6 - Are based on the class scheduling 3NF relations...Ch. 6 - Prob. 6.36PAECh. 6 - Are based on the class scheduling 3NF relations...Ch. 6 - Are based on the class scheduling 3NF relations...Ch. 6 - Are based on the class scheduling 3NF relations...Ch. 6 - Prob. 6.40PAECh. 6 - Are based on the class scheduling 3NF relations...Ch. 6 - Prob. 6.42PAECh. 6 - Prob. 6.43PAECh. 6 - Are based on the class scheduling 3NF relations...Ch. 6 - Prob. 6.45PAECh. 6 - Prob. 6.46PAECh. 6 - Prob. 6.47PAECh. 6 - Prob. 6.48PAECh. 6 - Prob. 6.49PAECh. 6 - Prob. 6.50PAECh. 6 - Prob. 6.51PAECh. 6 - Prob. 6.52PAECh. 6 - Prob. 6.53PAECh. 6 - Modify the Product_T table by adding an attribute...Ch. 6 - Prob. 6.55PAECh. 6 - Add an order to the Order_T table and include a...Ch. 6 - Use the Pine Valley database to answer the...Ch. 6 - Prob. 6.58PAECh. 6 - Prob. 6.59PAECh. 6 - Prob. 6.60PAECh. 6 - Prob. 6.61PAECh. 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 - Prob. 6.72PAECh. 6 - Prob. 6.73PAECh. 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 - Prob. 6.80PAECh. 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
- If we think about it in terms of SQL, why can indexing cause updates and deletions to take longer? Due to the difficulty of reading handwriting, please be as specific as possible and write your responses in text. [Please accept my thanks in advance for your time.]arrow_forwardplease use sql to answer the following question Create a procedure, ADD_EMPLOYEE., to insert a new employee into the EMPLOYEES table. The procedure should call a VALID_DEPTID function to check whether the department ID specified for the new employee exists in the DEPARTMENTS table. d, Add another employee named Joe Harris in department 80. leaving remaining parameters with their default values. What is the result?arrow_forwardplease use sql to answer the following question Create a procedure, ADD_EMPLOYEE., to insert a new employee into the EMPLOYEES table. The procedure should call a VALID_DEPTID function to check whether the department ID specified for the new employee exists in the DEPARTMENTS table. c. Call ADD_EMPLOYEE for the name Jane Harris in department 15. leaving other parameters with their default values. What is the result?arrow_forward
- For this exercise use the following schema, the script to create this schema and populate data is given in ATM.SQL file. 1- List all names of the users from Lahore in Descending Order.2- List all cards, who have card type “Credit” in ascending order.3- List the name of all the users who are Gold type.4- List the names of the user who’s Card number ends with 6. (HINT: USE LIKE)arrow_forwardName - dbo.Patient Columns - PatientId, First name, Last name, Dob, Height, Weight, Sex Name - dbo.PatientAddress Columns - PatientId, Address line 1, Address line 2, Address line 3, City, State, Zip Write SQL queries to obtain the following data: Select all records from the table dbo.Patient table where patient last names include the word 'smith' Get all the details including the address of a patient named 'Betty White' Get all the records from dbo.Patient that do not have a matching record in dbo.PatientAddress Get the number of patients who live in Florida.arrow_forwardUsing the relations given in the appendix, write the SQL statements to perform the following operations:i. Add a new employee in the employee table whose employee number is 1009, full name is Stephen M. Clinton, date of birth is 23rd July 1970, and hire date is 1st July, 2022.ii. Add a dependant of this employee in the employee table, with dependant number of 1, first name specified as Johannes and date of birth specified as 5th February, 2005.iii. Delete records in the dependant table where the dependantnumber is 2.iv. Delete all dependants of the employee with employee number 1008 from the dependant table.arrow_forward
- please use sql to answer the following question and erd had been attach 1.Which books were written by an author with the last name Adams? Perform the search using the author name. (join)arrow_forwardHow will you represent the following multiple relation in SQL DBMSarrow_forwardPlease answer the following in SQL: Find all pairs of customers who have purchased the exact same combination of cookie flavors. For example, customers with ID 1 and 10 have each purchased at least one Marzipan cookie and neither customer has purchased any other flavor of cookie. Report each pair of customers just once, sort by the numerically lower customer ID. The MySQL-specific GROUP_CONCAT and JSON_ARRAYAGG functions are not permitted. customers dataset CId: unique identifier of the customerLastName: last name of the customerFirstName: first name of the customer goods dataset GId: unique identifier of the baked goodFlavor: flavor/type of the good (e.g., "chocolate", "lemon") Food: category of the good (e.g., "cake", "tart")Price: price (in dollars) items dataset Receipt : receipt number Ordinal : position of the purchased item on the receipts. (i.e., first purchased item, second purchased item, etc...)Item : identifier of the item purchased (see…arrow_forward
- List all products with their highest unit price, i.e. not discounted.the database isarrow_forwardHow can I remove the duplicates in SQL? Here is the code. SELECT [EmployeeID] ,[RoleID] ,Count(*) as '# of duplicates'FROM [dbo].[EmployeeRoles]Group by [EmployeeID] ,[RoleID]Having Count(*) > 1arrow_forwardWhat mechanisms are in place within SQL to handle errors within user-defined functions?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology Ptr
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
SQL Basics for Beginners | Learn SQL | SQL Tutorial for Beginners | Edureka; Author: edureka;https://www.youtube.com/watch?v=zbMHLJ0dY4w;License: Standard YouTube License, CC-BY