Database Systems: Design, Implementation, & Management

13th Edition

ISBN: 9781337627900

Author: Carlos Coronel, Steven Morris

Publisher: Cengage Learning

See similar textbooks

Concept explainers

SQL

SQL stands for Structured Query Language, is a form of communication that uses queries structured in a specific format to store, manage & retrieve data from a relational database.

Queries

A query is a type of computer programming language that is used to retrieve data from a database. Databases are useful in a variety of ways. They enable the retrieval of records or parts of records, as well as the performance of various calculations prio…

Videos

Textbook Question

Chapter 8, Problem 20P

Create an Oracle sequence named CUST_NUM_SEQ to generate values for customer numbers. The sequence should start with the value 2000.

Expert Solution & Answer

Trending nowThis is a popular solution!

See solution

Check out sample textbook solution

Chapter 8, Problem 19P

Chapter 8, Problem 21P

Students have asked these similar questions

Problem #11: 1111 FR 10 500000 300000 Problem #12 : 2222 NB 16 400000 300000 Problem #13: 3333 BO 16 400000 275000 Problem #14: 4444 PR 23 400000 200000

Use the following pseudocode for questions 18-20: Main Program: Start Declare variables idno, location, dept, budget, spent, msg Input idno, location, dept, budget, spent budgetMsg() Output idno, location, dept, budget, spent, msg Stop budgetMsg() If dept < 20 If budget > 350000 msg = cut 7% Else msg = cut 6% Endif Endif Question at position 18 18 Fill in the Blank 1 point Question 18 is unpinned. Click to pin. Question at position 18 What would the msg be set to if the following was input: Input: 1111 BO 20 400000 300000 Output: cut Question Blank 1 of 1 Question at position 19 19 Question at position 19 What would msg be if the input was the following: Input: 2222 PR 14 100000 110000 Output: cut Question 20 What would msg be if the input was the following: Input: 3333 FR 25 200000 100000

Use the following pseudocode for questions 21-23: Main Program: Start Declare variables idno, location, dept, budget, spent, msg Input idno, location, dept, budget, spent budgetMsg() Output idno, location, dept, budget, spent, msg Stop budgetMsg() If dept < 20 If budget > 350000 msg = cut 7% Else msg = cut 6% End if Else msg = cut 5% End if Question at position 21 What would msg be with the following input? Input: 1111 BO 20 400000 300000 Output: cut % Question at position 22 What would msg be with the following input? Input: 2222 PR 14 100000 110000 Output: cut % Question at position 23 What would msg be with the following input? Input: 3333 FR 25 200000 100000 Output: cut %

Chapter 8 Solutions

Database Systems: Design, Implementation, & Management

Ch. 8 - Prob. 1RQ Ch. 8 - Explain why it might be more appropriate to...Ch. 8 - What is the difference between a column constraint...Ch. 8 - What are referential constraint actions?Ch. 8 - What is the purpose of a CHECK constraint?Ch. 8 - Explain when an ALTER TABLE command might be...Ch. 8 - What is the difference between an INSERT command...Ch. 8 - What is the difference between using a subquery...Ch. 8 - What is the difference between a view and a...Ch. 8 - Prob. 10RQ

Ch. 8 - Prob. 11RQ Ch. 8 - Prob. 12RQ Ch. 8 - Write the SQL code that will create only the table...Ch. 8 - Having created the table structure in Problem 1,...Ch. 8 - Prob. 3P Ch. 8 - Write the SQL code that will save the changes made...Ch. 8 - Write the SQL code to change the job code to 501...Ch. 8 - Write the SQL code to delete the row for William...Ch. 8 - Write the SQL code to create a copy of EMP_1,...Ch. 8 - Using the EMP_2 table, write the SQL code that...Ch. 8 - Using the EMP_2 table, write the SQL code to...Ch. 8 - Prob. 10P Ch. 8 - Prob. 11P Ch. 8 - Prob. 12P Ch. 8 - Prob. 13P Ch. 8 - Prob. 14P Ch. 8 - Prob. 15P Ch. 8 - Create the CUSTOMER table structure illustrated in...Ch. 8 - Create the INVOICE table structure illustrated in...Ch. 8 - Prob. 18P Ch. 8 - Prob. 19P Ch. 8 - Create an Oracle sequence named CUST_NUM_SEQ to...Ch. 8 - Create an Oracle sequence named INV_NUM_SEQ to...Ch. 8 - Prob. 22P Ch. 8 - Modify the CUSTOMER table to include the customers...Ch. 8 - Prob. 24P Ch. 8 - Prob. 25P Ch. 8 - Create a trigger named trg_updatecustbalance to...Ch. 8 - Prob. 27P Ch. 8 - Prob. 28P Ch. 8 - Write a trigger to update the customer balance...Ch. 8 - Prob. 30P Ch. 8 - Create a trigger named trg_line_total to write the...Ch. 8 - Create a trigger named trg_line_prod that...Ch. 8 - Create a stored procedure named prc_inv_amounts to...Ch. 8 - Create a procedure named prc_cus_balance_update...Ch. 8 - Modify the MODEL table to add the attribute and...Ch. 8 - Prob. 36P Ch. 8 - Modify the CHARTER table to add the attributes...Ch. 8 - Write the sequence of commands required to update...Ch. 8 - Write the sequence of commands required to update...Ch. 8 - Write the command required to update the...Ch. 8 - Write the command required to update the...Ch. 8 - Write the command required to update the...Ch. 8 - Prob. 43P Ch. 8 - Create a trigger named trg_char_hours that...Ch. 8 - Create a trigger named trg_pic_hours that...Ch. 8 - Create a trigger named trg_cust_balance that...Ch. 8 - Write the SQL code to create the table structures...Ch. 8 - The following tables provide a very small portion...Ch. 8 - For Questions 49-63, use the tables that were...Ch. 8 - Prob. 50P Ch. 8 - Write a single SQL command to increase all price...Ch. 8 - Alter the DETAILRENTAL table to include a derived...Ch. 8 - Update the DETAILRENTAL table to set the values in...Ch. 8 - Alter the VIDEO table to include an attribute...Ch. 8 - Update the VID_STATUS attribute of the VIDEO table...Ch. 8 - Alter the PRICE table to include an attribute...Ch. 8 - Prob. 57P Ch. 8 - Prob. 60P

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.

Create an Oracle sequence named CUST_NUM_SEQ to generate values for customer numbers. The sequence should start with the value 2000.

Solution Summary: The author explains that sequence generates unique numeric values by a special type of object either in ascending or descending order.

Concept explainers

Videos

Chapter 8 Solutions