EBK CONCEPTS OF DATABASE MANAGEMENT
8th Edition
ISBN: 8220100706004
Author: Last
Publisher: Cengage Learning US
expand_more
expand_more
format_list_bulleted
Question
Chapter 4, Problem 9CATC
To determine
To change the value in Waiver field to Y for the customer with given last name.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
For this problem, the registrar’s office has requested that we create a report of students and the number of courses they have taken to verify minimum graduation requirements. You have been tasked with creating a table and procedure that track this information. To complete this problem:
a. create a table (NOT a temporary table) called student_course_nums within the university database schema.
b. Write a procedure that accepts a student ID as input. You must name your procedure: __stuCourseNumsProc Where is your last name and is the day of the month you were born. Below is an example of how I named my procedure: Hollers_21_stuCourseNumsProc
c. The procedure calculates the total number of course sections attended by that student, and adds a tuple to the student_course_nums table consisting of the student’s ID number, name, and total courses attended - call these attributes: ID, name, and tot_courses.
d. If the student already has an entry in the table, then the procedure makes sure the…
2
Luxury Restaurant Sdn Bhd, was set-up in Jan 2019. The retail outlet was conveniently
located in Paragon Mall, Penang to offer a complete range of local and western food.
Below form shows the examples of bookings form record which requires normalization
process. You as the database administrator, normalize the below information from
Unnormalized Form (UNF), First Normal Form (INF), Second Normal Form (2NF) and
Third Normal Form (3NF).
Booking Form
Staff No:
P123
28th Dec 2018
Staff Name:
Amy
Customer ID: C223
Customer Name Candy
Table No
Type
T11
Birthday
T20
Wedding
Quantity
10
100
Date:
Payment: Cash
(30 marks)
Write the SQL statements necessary to remove the PET_OWNER table from the database. Assume that the PET table also needs to be removed. Do not run these commands in an actual database!
Chapter 4 Solutions
EBK CONCEPTS OF DATABASE MANAGEMENT
Ch. 4 - Prob. 1RQCh. 4 - Prob. 2RQCh. 4 - Prob. 3RQCh. 4 - Prob. 4RQCh. 4 - Prob. 5RQCh. 4 - Prob. 6RQCh. 4 - Prob. 7RQCh. 4 - Prob. 8RQCh. 4 - Prob. 9RQCh. 4 - Prob. 10RQ
Ch. 4 - Prob. 11RQCh. 4 - Prob. 12RQCh. 4 - Prob. 13RQCh. 4 - Prob. 14RQCh. 4 - Prob. 15RQCh. 4 - Prob. 16RQCh. 4 - Prob. 17RQCh. 4 - Prob. 18RQCh. 4 - Prob. 1TDECh. 4 - Prob. 2TDECh. 4 - Prob. 3TDECh. 4 - Prob. 4TDECh. 4 - Prob. 5TDECh. 4 - Prob. 6TDECh. 4 - Prob. 7TDECh. 4 - Prob. 8TDECh. 4 - Prob. 9TDECh. 4 - Prob. 10TDECh. 4 - Prob. 11TDECh. 4 - Prob. 12TDECh. 4 - Prob. 13TDECh. 4 - Prob. 1CATCCh. 4 - Prob. 2CATCCh. 4 - Prob. 3CATCCh. 4 - Prob. 4CATCCh. 4 - Prob. 5CATCCh. 4 - Prob. 6CATCCh. 4 - Prob. 7CATCCh. 4 - Prob. 8CATCCh. 4 - Prob. 9CATCCh. 4 - Prob. 10CATCCh. 4 - Prob. 11CATCCh. 4 - Prob. 12CATCCh. 4 - Prob. 13CATCCh. 4 - Prob. 14CATCCh. 4 - Prob. 1SCGCCh. 4 - Prob. 2SCGCCh. 4 - Prob. 3SCGCCh. 4 - Prob. 4SCGCCh. 4 - Prob. 5SCGCCh. 4 - Prob. 6SCGCCh. 4 - Prob. 7SCGCCh. 4 - Prob. 8SCGCCh. 4 - Prob. 9SCGCCh. 4 - Prob. 10SCGCCh. 4 - Prob. 11SCGCCh. 4 - Prob. 12SCGC
Knowledge Booster
Similar questions
- Does the DBMS or the user make the choice of which index to use to accomplish a given task?arrow_forwardAn EMPLOYEES table was added to the JustLee Books database to track employee information. Display a list of each employee’s name, job title, and manager’s name. Use column aliases to clearly identify employee and manager name values. Include all employees in the list and sort by manager name.arrow_forwardOne way to secure a database is to allow only administrators to have access to create and delete tables. (513)arrow_forward
- What is store procedure in DBMSarrow_forwardTo perform these activities, refer to the JustLee database tables. During an afternoon at work, you receive various requests for data stored in the database. As you fulfill each request, you decide to document the SQL statements you used to find the data to assist with future requests. The following are two of the requests that were made: A manager at JustLee Books requests a list of the titles of all books generating a profit of at least $10.00. The manager wants the results listed in descending order, based on each book’s profit. A customer service representative is trying to identify all books in the Computer or Familylife categories published by Publisher 1 or Publisher 3. However, the results should not includeany book selling for less than $45.00.arrow_forwardDATABSEarrow_forward
- given the structure of the Ch07_LargeCo database shown above , use SQL commands to answer the problems in the following steps .arrow_forwardConsidered the tables structures that you need in this question are the same of DBS311 database : Display the highest, lowest, and average customer credit limits. Name these results high, low, and average. Add a column that shows the number of no credit records named "Invalid credit". Display the result of the average as integer. For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac). BI U S Paragraph A v In x X2 Arial 10pt ...arrow_forwardbased on the image, write SQL statement to display the patient's IC, name, the city's name of the quarantine centre and the nuber of the total days the patients been admiited in the quarantine centrearrow_forward
- PLZ help with the following: The manager wants to add a new painter as an artist in the database. What would the insert statement look like? For a painter to be considered in the Artist database, the painter must have painted at least one painting, however, a painting might not be exhibited in a gallery. Based on these business rules, please insert one painting for the painter that you inserted in Q1. sql file CREATE TABLE GALLERY (GAL_NUM char(4),GAL_OWNER varchar(35),GAL_AREACODE char(3),GAL_PHONE char(8),GAL_RATE number);INSERT INTO GALLERY VALUES('5','L. R. Gilliam','901','123-4456',0.37);INSERT INTO GALLERY VALUES('6','G. G. Waters','405','353-2243',0.45 );INSERT INTO GALLERY VALUES('1','N. D. Cosner','203','123-9956',0.67);INSERT INTO GALLERY VALUES('2','S. H. Artwork','415','154-3243',0.30); /* -- */ CREATE TABLE PAINTER (PTR_NUM char(4),PTR_LASTNAME varchar(15) NOT NULL,PTR_FIRSTNAME varchar(15) NOT NULL,PTR_AREACODE char(3),PTR_PHONE char(8));INSERT INTO PAINTER…arrow_forwardSUBJECT: DATABASE MANAGEMENT SYSTEM NOTE: All these tasks must be done in Oracle Database 10g Enterprise Edition Display the Employee name and designation in one column. Display all records from table whose name is Smith using all uppercases in where clause. Display all records from table whose name is Smith using first letter captializaed in where clause. Display all records from table whose name is Smith using all lowercases in where clause. Display all records from table whose name is Smith using lower and upper cases both. i.e. SMITH, smith both should be acceptable. Show the result of those employees whose name length exceeds 8. Display ename, salary and concatenated result of deptno and empno from table EMP where salary is less than 2500 or job is equal to MANAGER. Display first 3 characters of ename, deptno and job from table EMP where second character of ename is ‘A’ and deptno is 30 or job is SALESMAN. Right Append dollar sign in Employee table to make salary 8 digit value.…arrow_forwardusing data from tal distributors database , define a view named toplevelcust. it consists of the number, name, address , balance , and credit limit of all customers with credit limits taht are greater than or equal to $10,000arrow_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
Enhanced Discovering Computers 2017 (Shelly Cashm...Computer ScienceISBN:9781305657458Author:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. CampbellPublisher:Cengage Learning
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Enhanced Discovering Computers 2017 (Shelly Cashm...
Computer Science
ISBN:9781305657458
Author:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:Cengage Learning