Database Systems: Design, Implementation, & Management
12th Edition
ISBN: 9781305627482
Author: Carlos Coronel, Steven Morris
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 8, Problem 40P
Program Plan Intro
ALTER TABLE Statement:
“ALTER TABLE” statement comes under Data Definition Language. It is used to modify column, add constraints, add column(s), drop column, rename column name and table name, drop constraints, and so on.
Syntax:
Syntax to drop constraint is as follows:
ALTER TABLE table_Name ADD CONSTRAINT constraintName;
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
CUSTOMER
Customer table is composed of customer number, name and phone number.
Give and fill-in the appropriate attribute name for each of the column.
custID
123
124
125
126
reservelD
5001
5002
5003
5004
5005
5006
5007
RESERVATION
Each reservation is for one taxi. Reservation table is composed of reservation identification number, start
reservation date, end reservation date, reservation days requested by customers starting from reservation
date until end of reservation date, customer number that make the reservation and taxi number assigned
to the reservation.
Give and fill-in the appropriate attribute name for each of the column.
taxill
custName
Ahmad Bin Abdullah
Fatimah Binti Adam
LAI
LA2
Ruqayya Binti Idris
Sulaiman Bin Daud
LA3
LA4
startDate
01/10/2019
05/10/2019
05/10/2019
15/10/2019
20/10/2019
27/10/2019
02/11/2019
taxiType
endDate
03/10/2019
12/10/2019
08/10/2019
17/10/2019
25/10/2019
Sedan
Sedan
Van
Van
30/10/2019
04/11/2019
cust Phoneno
TAXI
Taxi table is composed of taxi…
Problem 22
Insert the following customer into the CUST_MYSQL table, allowing the AUTO_INCREMENT attribute set up in Problem 20.a and Problem 20.b to generate the customer number automatically:
CUST_LNAME
CUST_FNAME
CUST_BALANCE
Powers
Ruth
500
This is what problem 20.a said, and got right: Using MySQL, create a table named CUST_MYSQL with the same fields as in Problem 16, except, use the AUTO_INCREMENT feature for the CUST_NUM field.
This is what problem 20.b said, and got right: Using MySQL, alter the table to populate the CUST_NUM field, beginning the increment with 2000.
5) Write an SQL Query to display the accountno, name, Recurrent_acno, amount whose fixed deposit
Less than 80000.
(Use inner join)
Chapter 8 Solutions
Database Systems: Design, Implementation, & Management
Ch. 8 - What is a cross join? Give an example of its...Ch. 8 - What three join types are included in the outer...Ch. 8 - Using tables named T1 and T2, write a query...Ch. 8 - Prob. 4RQCh. 8 - Prob. 5RQCh. 8 - Prob. 6RQCh. 8 - Prob. 7RQCh. 8 - What does it mean to say that SQL operators are...Ch. 8 - Prob. 9RQCh. 8 - Prob. 10RQ
Ch. 8 - Prob. 11RQCh. 8 - Prob. 12RQCh. 8 - Given the employee information in Question 11,...Ch. 8 - Prob. 14RQCh. 8 - Prob. 15RQCh. 8 - Prob. 16RQCh. 8 - What Oracle function should you use to calculate...Ch. 8 - Prob. 18RQCh. 8 - What string function should you use to list the...Ch. 8 - Prob. 20RQCh. 8 - Prob. 21RQCh. 8 - Prob. 22RQCh. 8 - Prob. 23RQCh. 8 - Prob. 24RQCh. 8 - Prob. 1PCh. 8 - Insert the data into the tables you created in...Ch. 8 - Prob. 3PCh. 8 - Prob. 4PCh. 8 - Prob. 5PCh. 8 - Prob. 6PCh. 8 - Prob. 7PCh. 8 - Prob. 8PCh. 8 - Prob. 9PCh. 8 - Modify the CUSTOMER table to include two new...Ch. 8 - Assuming that you completed Problem 10, write the...Ch. 8 - Assuming that the CUSTOMER table contains a...Ch. 8 - Write the query that lists the average age of your...Ch. 8 - Write the trigger to update the CUST_BALANCE in...Ch. 8 - Prob. 15PCh. 8 - Prob. 16PCh. 8 - Write a trigger to update the customer balance...Ch. 8 - Write a procedure to delete an invoice, giving the...Ch. 8 - Prob. 19PCh. 8 - Prob. 20PCh. 8 - Prob. 21PCh. 8 - Prob. 22PCh. 8 - Write a single SQL command to increase all price...Ch. 8 - Prob. 24PCh. 8 - Prob. 25PCh. 8 - Prob. 26PCh. 8 - Prob. 27PCh. 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. 33PCh. 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. 40PCh. 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 - Prob. 44PCh. 8 - Prob. 45PCh. 8 - Prob. 46PCh. 8 - Prob. 47PCh. 8 - Prob. 48PCh. 8 - Prob. 49PCh. 8 - Prob. 50PCh. 8 - Prob. 51PCh. 8 - Prob. 52PCh. 8 - Prob. 53PCh. 8 - Prob. 54PCh. 8 - Prob. 55PCh. 8 - Prob. 56PCh. 8 - Prob. 57PCh. 8 - Prob. 58PCh. 8 - Prob. 59PCh. 8 - Prob. 61PCh. 8 - Prob. 62PCh. 8 - Prob. 63PCh. 8 - Prob. 64PCh. 8 - Prob. 65PCh. 8 - Prob. 66PCh. 8 - Prob. 67PCh. 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. 73CCh. 8 - Prob. 76C
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
- Modify the CHARTER table to add the attributes shown in the following table. TABLE P8.37 ATTRIBUTES AND VALUES FOR PROBLEM 37 ATTRIBUTE NAME ATTRIBUTE DESCRIPTION ATTRIBUTE TYPE CHAR_WAIT_CHG Waiting charge for each model (copied from the MODEL table) Numeric CHAR_FLT_CHG_HR Flight charge per mile for each model (copied from the MODEL table using the MOD_CHG_MILE attribute) Numeric CHAR_FLT_CHG Flight charge (calculated by CHAR_HOURS_FLOWN CHAR_FLT_CHG_HR) Numeric CHAR_TAX_CHG CHAR_FLT_CHG tax rate (8%) Numeric CHAR_TOT_CHG CHAR_FLT_CHG + CHAR_TAX_CHG Numeric CHAR_PYMT Amount paid by customer Numeric CHAR_BALANCE Balance remaining after payment Numericarrow_forwardWrite the SQL code to calculate the ASSIGN_CHARGE values in the ASSIGNMENT table in the Ch07_ConstructCo database. (See Figure P7.1.) Note that ASSIGN_CHARGE is a derived attribute that is calculated by multiplying ASSIGN_CHG_HR by ASSIGN_HOURS.arrow_forwardAdd two columns to the EMPLOYEES table. One column, named EmpDate, contains the date of employment for each employee, and its default value should be the system date. The second column, named EndDate, contains employees date of termination.arrow_forward
- Problem 10 Modify the CUSTOMER table to include two new attributes: CUST_DOB and CUST_AGE . Customer 1000 was born on March 15, 1979, and customer 1001 was born on December 22, 1988.arrow_forward1. The data type for Borrower_name in Borrowers Table is: A. Short text C. Currency B. Long text D. Yes/No Borrowers Field Name Borrower ID Borrower Name Phone num Membership_activation Data Type AutoNumber Short Text Short Text Yes/Noarrow_forwardroblem 16 Create the CUSTOMER table structure illustrated in Figure P8.16. The customer number should store integer values. The CUST_FNAME and CUST_LNAME attributes should support variable length character data up to 30 characters each. CUST_BALANCE should support up to eight digits on the left of the decimal place and two digits to the right of the decimal place. Use CUST_NUM as the primary key. Problem 17 Create the INVOICE table structure illustrated in Figure P8.16. INV_NUM should store integer values. INV_DATE should store date values. INV_AMOUNT should support up to eight digits to the left of the decimal place and two digits to the right of the decimal place. Use INV_NUM as the primary key. Note that the CUST_NUM is the foreign key to CUSTOMER, so be certain to enforce referential integrity. Problem 18 Write the set of SQL commands necessary to insert the data into the CUSTOMER table you created in Problem 16, as illustrated in Figure P8.16. Problem 19 Write the set of SQL…arrow_forward
- The Car Maintenance team also wants to store the actual maintenance operations in the database. The team wants to start with a table to store CAR_ID (CHAR(5)), MAINTENANCE_TYPE_ID (CHAR(5)) and MAINTENANCE_DUE (DATE) date for the operation. Create a new table named MAINTENANCES. The PRIMARY_KEY should be the combination of the three fields. The CAR_ID and MAINTENACNE_TYPE_ID should be foreign keys to their original tables. Cascade update and cascade delete the foreign keys.arrow_forward1 Insert the following customer into the CUST_MYSQL table, allowing the AUTO_INCREMENT attribute set up in Problem 20.a and Problem 20.b to generate the customer number automatically: CUST_LNAME CUST_FNAME CUST_BALANCE Powers Ruth 500 2) Modify the CUSTOMER table to include the customer’s date of birth (CUST_DOB), which should store date data.arrow_forwardConsidering Vaccination Database, write queries to: Display the Subject CNIC, Name, Contact, Dose1 Center, and Dose2 Center as shown below: CNIC Name Contact Dose1 Center Dose2 Center 22401-6645321-1 Nasir 3409991112 Lachi Kohat 2 14301-6045321-5 Shahab 3409991112 kohat 3 Dara The subjects who have been vaccinated different types in Dose1 and Dose2. For instance, subjects who were vaccinated ‘Sinovac’ in the first dose, while Pfizer in the second dose.How many Viles of each type have been consumed so far. How many subjects are vaccinated from expired viles. Suggest the name of Incharge for the best performance award based on the highest number of subjects vaccinated on a single dayarrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningDatabase 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 Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
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