EBK A GUIDE TO SQL
9th Edition
ISBN: 8220103671682
Author: Last
Publisher: CENGAGE L
expand_more
expand_more
format_list_bulleted
Question
Chapter 2, Problem 14CATC
To determine
To list Reservation ID, trip name, customer last name, customer first name and total cost calculated as adding trip price plus other fees multiplying the result by number of persons where number of persons is greater than four.
Expert Solution & Answer
Trending nowThis is a popular 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…
The StayWell Property Management team considers creating a discount scheme for the property owners with more than one property in the system. You will need to provide all the owner IDs (OWNER_NUM) and the count of properties of the owners with more than one active property in the database. The output columns should be OWNER_NUM and COUNT(*) respectively.
The figure below shows a sample database containing information about:
· Students and their registrations
· Courses and their sections
· Faculty and their qualified courses
The sample data is shown in each table for your understanding.
Write SQL DML commands to do the following tasks:
List the IDs of all faculty members who are qualified to teach both ISM 3112 and ISM 3113.
Modify the query above in part 16 so that both qualifications must have been earned after the year 2005.
List the ID of the faculty member who has been assigned to teach ISM 4212 during the semester II-2015.
Display the course ID and course name for all courses with an ISM prefix.
Display all courses for which Professor Berndt has been qualified.
Display the class roster, including student name, for all students enrolled in section 2714 of ISM 4212. Class roster means attendance list.
Which instructors are qualified to teach ISM 3113?
Is any instructor qualified to teach ISM 3113 and not…
Chapter 2 Solutions
EBK A GUIDE TO SQL
Ch. 2 - Prob. 1RQCh. 2 - Prob. 2RQCh. 2 - Prob. 3RQCh. 2 - Prob. 4RQCh. 2 - Prob. 5RQCh. 2 - Prob. 6RQCh. 2 - Prob. 7RQCh. 2 - Prob. 8RQCh. 2 - Prob. 9RQCh. 2 - Prob. 10RQ
Ch. 2 - Prob. 11RQCh. 2 - Prob. 12RQCh. 2 - Prob. 13RQCh. 2 - Prob. 14RQCh. 2 - Prob. 15RQCh. 2 - Prob. 16RQCh. 2 - Prob. 17RQCh. 2 - Prob. 18RQCh. 2 - Prob. 19RQCh. 2 - Prob. 20RQCh. 2 - Prob. 21RQCh. 2 - Prob. 22RQCh. 2 - Prob. 23RQCh. 2 - Prob. 24RQCh. 2 - Prob. 25RQCh. 2 - Prob. 26RQCh. 2 - Prob. 27RQCh. 2 - Prob. 28RQCh. 2 - Prob. 29RQCh. 2 - Prob. 30RQCh. 2 - Prob. 1BCEQBECh. 2 - Prob. 2BCEQBECh. 2 - Prob. 3BCEQBECh. 2 - Prob. 4BCEQBECh. 2 - Prob. 5BCEQBECh. 2 - Prob. 6BCEQBECh. 2 - Prob. 7BCEQBECh. 2 - Prob. 8BCEQBECh. 2 - Prob. 9BCEQBECh. 2 - Prob. 10BCEQBECh. 2 - Prob. 11BCEQBECh. 2 - Prob. 12BCEQBECh. 2 - Prob. 13BCEQBECh. 2 - Prob. 14BCEQBECh. 2 - Prob. 15BCEQBECh. 2 - Prob. 16BCEQBECh. 2 - Prob. 17BCEQBECh. 2 - Prob. 18BCEQBECh. 2 - Prob. 1BCERACh. 2 - Prob. 2BCERACh. 2 - Prob. 3BCERACh. 2 - Prob. 4BCERACh. 2 - Prob. 5BCERACh. 2 - Prob. 6BCERACh. 2 - Prob. 7BCERACh. 2 - Prob. 1CATCCh. 2 - Prob. 2CATCCh. 2 - Prob. 3CATCCh. 2 - Prob. 4CATCCh. 2 - Prob. 5CATCCh. 2 - Prob. 6CATCCh. 2 - Prob. 7CATCCh. 2 - Prob. 8CATCCh. 2 - Prob. 9CATCCh. 2 - Prob. 10CATCCh. 2 - Prob. 11CATCCh. 2 - Prob. 12CATCCh. 2 - Prob. 13CATCCh. 2 - Prob. 14CATCCh. 2 - Prob. 15CATCCh. 2 - Prob. 16CATCCh. 2 - Prob. 17CATCCh. 2 - Prob. 18CATCCh. 2 - Prob. 1SPTCCh. 2 - Prob. 2SPTCCh. 2 - Prob. 3SPTCCh. 2 - Prob. 4SPTCCh. 2 - Prob. 5SPTCCh. 2 - Prob. 6SPTCCh. 2 - Prob. 7SPTCCh. 2 - Prob. 8SPTCCh. 2 - Prob. 9SPTCCh. 2 - Prob. 10SPTCCh. 2 - Prob. 11SPTCCh. 2 - Prob. 12SPTCCh. 2 - Prob. 13SPTCCh. 2 - Prob. 14SPTCCh. 2 - Prob. 15SPTCCh. 2 - Prob. 16SPTCCh. 2 - Prob. 17SPTCCh. 2 - Prob. 18SPTCCh. 2 - Prob. 19SPTC
Knowledge Booster
Similar questions
- An 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_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_forwardDesign a survey form of your own. Fill it out as it might have been completed during the database design for Henry Books. For any questions you have too little information to answer, make a reasonable guess. (Ray Henry, the owner of a bookstore chain named Henry Books, gathers and organizes information about branches, publishers, authors, and books. Each local branch of the bookstore has a number that uniquely identifies the branch. In addition, Ray tracks the branch’s name, location, and number of employees. Each publisher has a code that uniquely identifies the publisher. In addition, Ray tracks the publisher’s name and city. The only user of the Book database is Ray, but you do not want to treat the entire project as a single user view. Ray has provided you with all the reports the system must produce, and you will treat each report as a user view. Ray has given you the following requirements: User View 1 Requirements: For each publisher, list the publisher code, publisher name, and…arrow_forward
- The figure below shows a sample database containing information about: · Students and their registrations · Courses and their sections · Faculty and their qualified courses The sample data is shown in each table for your understanding. Write SQL DML commands to do the following tasks: Display all courses for which Professor Berndt has been qualified. Display the class roster, including student name, for all students enrolled in section 2714 of ISM 4212. Class roster means attendance list. Which instructors are qualified to teach ISM 3113? Is any instructor qualified to teach ISM 3113 and not qualified to teach ISM 4930? Note: If a faculty member has qualified a course, then he is eligible to teach that course. Moreover, you can also consider the Qualified table as the Faculty Course Allocation table.arrow_forwardA select procedure in a relational database can shrink a table's size by deleting columns that don't fit a certain set of requirements.Is it good or bad?arrow_forwardThe 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_forward
- To 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_forwardparts that follow are the building blocks of most relational DBMSs' physical data structuresarrow_forwardNote: Use MYSQL Create a database named book-collection-db and table named: bookcollect. Your tableshould contain the following columns: Title, Author, Genre (Children’s, Romance,Thriller, Fantasy, etc.), Publisher, Copyright Date, ISBN Number, Category (Fiction/Nonfiction), Overview, Link Where to Buy, and Price. Create 30 rows containing list of bookwith varied genre.arrow_forward
arrow_back_ios
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