Database Systems: Design, Implementation, & Management
13th Edition
ISBN: 9781337627900
Author: Carlos Coronel, Steven Morris
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 8, Problem 48P
The following tables provide a very small portion of the data that will be kept in the
TABLE P8.48A MEMBERSHIP TABLE
TABLE P8.48BÂ RENTAL TABLE
| RENTAL | ||
| RENT_NUM | RENT_DATE | MEM_NUM |
| 1001 | 01-MAR-18 | 103 |
| 1002 | 01-MAR-18 | 105 |
| 1003 | 02-MAR-18 | 102 |
| 1004 | 02-MAR-18 | 110 |
| 1005 | 02-MAR-18 | 111 |
| 1006 | 02-MAR-18 | 107 |
| 1007 | 02-MAR-18 | 104 |
| 1008 | 03-MAR-18 | 105 |
| 1009 | 03-MAR-18 | 111 |
TABLE P8.48C DETAILRENTAL TABLE
TABLE P8.48DÂ VIDEO TABLE
| VIDEO | ||
| VID_NUM | VID_INDATE | MOVIE_NUM |
| 54321 | 18-JUN-17 | 1234 |
| 54324 | 18-JUN-17 | 1234 |
| 54325 | 18-JUN-17 | 1234 |
| 34341 | 22-JAN-16 | 1235 |
| 34342 | 22-JAN-16 | 1235 |
| 34366 | 02-MAR-18 | 1236 |
| 34367 | 02-MAR-18 | 1236 |
| 34368 | 02-MAR-18 | 1236 |
| 34369 | 02-MAR-18 | 1236 |
| 44392 | 21-OCT-17 | 1237 |
| 44397 | 21-OCT-17 | 1237 |
| 59237 | 14-FEB-18 | 1237 |
| 61388 | 25-JAN-16 | 1239 |
| 61353 | 28-JAN-15 | 1245 |
| 61354 | 28-JAN-15 | 1245 |
| 61367 | 30-JUL-17 | 1246 |
| 61369 | 30-JUL-17 | 1246 |
TABLE P8.48E MOVIE TABLE
TABLE P8.48F PRICE TABLE
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
please use sql to answer the following question an erd has been add
a) Add a new row in the ORDERS table with the following data: Order# = 1021, Customer# 1009, and Order date = today’s date.
Modify the zip code on order 1017 to 33222.
Save the changes permanently to the database. Apply commit
Add a new row in the ORDERS table with the following data: Order# = 1022, Customer# =2000, and Order date = today’s date.
Describe the error raised and what caused the error.
The relational schema shown below is part of a hospital database. The primary and foreign keys are highlighted in bold.
Patient (patientNo, patName, patAddr, DOB)Ward (wardNo, wardName, wardType, noOfBeds)Admission (patientNo, wardNo, admissionDate)Drug (drugNo, drugName, costPerUnit)Prescribed (patientNo, drugNo, unitsPerDay, startDate, finishDate)
Write SQL queries based on the hospital database given above:
1. Create the above tables together with its constraints.
2. Insert some data into the tables to check that the tables created are correct. No limit on how many rows you want to add.
Insert Syntax:insert into table_namevalues (col1_value, col2_value, etc.);
3. List all the patients’ details, alphabetically by name.
IF YOU WANT SOME CHALLENGE4. List all the patients admitted today. (Join between Patient and Admission table)
Chapter 8 Solutions
Database Systems: Design, Implementation, & Management
Ch. 8 - Prob. 1RQCh. 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. 11RQCh. 8 - Prob. 12RQCh. 8 - Write the SQL code that will create only the table...Ch. 8 - Having created the table structure in Problem 1,...Ch. 8 - Prob. 3PCh. 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. 10PCh. 8 - Prob. 11PCh. 8 - Prob. 12PCh. 8 - Prob. 13PCh. 8 - Prob. 14PCh. 8 - Prob. 15PCh. 8 - Create the CUSTOMER table structure illustrated in...Ch. 8 - Create the INVOICE table structure illustrated in...Ch. 8 - Prob. 18PCh. 8 - Prob. 19PCh. 8 - Create an Oracle sequence named CUST_NUM_SEQ to...Ch. 8 - Create an Oracle sequence named INV_NUM_SEQ to...Ch. 8 - Prob. 22PCh. 8 - Modify the CUSTOMER table to include the customers...Ch. 8 - Prob. 24PCh. 8 - Prob. 25PCh. 8 - Create a trigger named trg_updatecustbalance to...Ch. 8 - Prob. 27PCh. 8 - Prob. 28PCh. 8 - Write a trigger to update the customer balance...Ch. 8 - Prob. 30PCh. 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. 36PCh. 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. 43PCh. 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. 50PCh. 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. 57PCh. 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.Similar questions
Recommended textbooks for you
A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology Ptr
Programming with Microsoft Visual Basic 2017Computer ScienceISBN:9781337102124Author:Diane ZakPublisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781285196145Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos CoronelPublisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
dml in sql with examples; Author: Education 4u;https://www.youtube.com/watch?v=WvOseanUdk4;License: Standard YouTube License, CC-BY