EBK CONCEPTS OF DATABASE MANAGEMENT
8th Edition
ISBN: 8220100706004
Author: Last
Publisher: Cengage Learning US
expand_more
expand_more
format_list_bulleted
Question
Chapter 3, Problem 11TDE
To determine
To write SQL query to list all the columns and rows in the item table and sorting the results by item description.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Use SQL to make the following changes to the Colonial Adventure Tours database (Figures 1-4 through 1-6 in Chapter 1). After each change, execute an appropriate query to show that the change was made correctly. If directed to do so by your instructor, use the information provided with the Chapter 3 Exercises to print your output or save it to a document. For any exercises that use commands not supported by your version of SQL, write the command to accomplish the task
Create a view named MAINE_TRIPS. It consists of the trip ID, trip name, start location, distance, maximum group size, type, and season for every trip located in Maine (ME)
a. Write and execute the CREATE VIEW command to create the MAINE_TRIPS view.b. Write and execute the command to retrieve the trip ID, trip name, and distancefor every Biking trip.c. Write and execute the query that the DBMS actually executes.d. Does updating the database through this view create any problems? If so, whatare they? If not, why not?
Use SQL to make the following changes to the Colonial Adventure Tours database (Figures 1-4 through 1-6 in Chapter 1). After each change, execute an appropriate query to show that the change was made correctly. If directed to do so by your instructor, use the information provided with the Chapter 3 Exercises to print your output or save it to a document. For any exercises that use commands not supported by your version of SQL, write the command to accomplish the task.
Create a view named MAINE_TRIPS. It consists of the trip ID, trip name, start location,distance, maximum group size, type, and season for every trip located in Maine (ME).
a. Write and execute the CREATE VIEW command to create the MAINE_TRIPS view.b. Write and execute the command to retrieve the trip ID, trip name, and distancefor every Biking trip.c. Write and execute the query that the DBMS actually executes.d. Does updating the database through this view create any problems? If so, whatare they? If not, why not
Using the sample "Solmaris Condo" "database" (just a bunch of tables with a theme) I had you create before this test, write a SQL statement to do the following: List the condo ID, square footage, owner number, service ID, number of estimated hours, and number of spent hours for each service request on which the category number is 4.
Chapter 3 Solutions
EBK CONCEPTS OF DATABASE MANAGEMENT
Ch. 3 - Prob. 1RQCh. 3 - Prob. 2RQCh. 3 - Prob. 3RQCh. 3 - Prob. 4RQCh. 3 - Prob. 5RQCh. 3 - Prob. 6RQCh. 3 - Prob. 7RQCh. 3 - Prob. 8RQCh. 3 - Prob. 9RQCh. 3 - Prob. 10RQ
Ch. 3 - Prob. 11RQCh. 3 - Prob. 12RQCh. 3 - Prob. 13RQCh. 3 - Prob. 14RQCh. 3 - Prob. 15RQCh. 3 - Prob. 16RQCh. 3 - Prob. 1TDECh. 3 - Prob. 2TDECh. 3 - Prob. 3TDECh. 3 - Prob. 4TDECh. 3 - Prob. 5TDECh. 3 - Prob. 6TDECh. 3 - Prob. 7TDECh. 3 - Prob. 8TDECh. 3 - Prob. 9TDECh. 3 - Prob. 10TDECh. 3 - Prob. 11TDECh. 3 - Prob. 12TDECh. 3 - Prob. 13TDECh. 3 - Prob. 14TDECh. 3 - Prob. 15TDECh. 3 - Prob. 16TDECh. 3 - Prob. 17TDECh. 3 - Prob. 18TDECh. 3 - Prob. 1CATCCh. 3 - Prob. 2CATCCh. 3 - Prob. 3CATCCh. 3 - Prob. 4CATCCh. 3 - Prob. 5CATCCh. 3 - Prob. 6CATCCh. 3 - Prob. 7CATCCh. 3 - Prob. 8CATCCh. 3 - Prob. 9CATCCh. 3 - Prob. 10CATCCh. 3 - Prob. 11CATCCh. 3 - Prob. 12CATCCh. 3 - Prob. 13CATCCh. 3 - Prob. 14CATCCh. 3 - Prob. 15CATCCh. 3 - Prob. 16CATCCh. 3 - Prob. 17CATCCh. 3 - Prob. 18CATCCh. 3 - Prob. 19CATCCh. 3 - Prob. 1SCGCCh. 3 - Prob. 2SCGCCh. 3 - Prob. 3SCGCCh. 3 - Prob. 4SCGCCh. 3 - Prob. 5SCGCCh. 3 - Prob. 6SCGCCh. 3 - Prob. 7SCGCCh. 3 - Prob. 8SCGCCh. 3 - Prob. 9SCGCCh. 3 - Prob. 10SCGCCh. 3 - Prob. 11SCGCCh. 3 - Prob. 12SCGCCh. 3 - Prob. 13SCGCCh. 3 - Prob. 14SCGCCh. 3 - Prob. 15SCGCCh. 3 - Prob. 16SCGCCh. 3 - Prob. 17SCGCCh. 3 - Prob. 18SCGCCh. 3 - Prob. 19SCGCCh. 3 - Prob. 20SCGCCh. 3 - Prob. 21SCGCCh. 3 - Prob. 22SCGC
Knowledge Booster
Similar questions
- 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_forwardBelow is part of a Student database. The primary keys are highlighted in bold. Student (studNo, studName, address, mobileNo) Registration (studNo, courseNo, regDate, semester, session) Course (courseNo, courseName, creditHour, level) Project (projNo, projName, courseNo) Assignment (projectNo, studNo, startDate, dueDate, hoursSpent) QUESTION 1. Write a PL/SQL FUNCTION that calculates the cost each student has to pay for all courses taken. In the photo is example the cost detail for each course. 2. Write a PL/SQL Procedure to call the function you created in question 1 . Allow the user to enter the student ID (studno). SECOND PHOTO IS THE EXAMPLE OF EXPECTED OUTPUTarrow_forwarduse sql to answer the following question To perform below tasks, refer to tables in the JustLee Book database. Create a list that display the title of each book and the name and phone number of the contact at the publisher’s office for reordering each book. Which books were written by an author with the Last Name-First Name (BAKER JACK)? Perform the search using author’s last name/first name. Determine which book(s) purchased by customer Steve Schell. Perform the search using the customer name & last name, not the customer number. If he/she has purchased multiple copies of the same book, unduplicated(DISCTINC) the result.arrow_forward
- Write the following queries in SQL, using the university schema. (We suggestyou actually run these queries on a database, using the sample data that weprovide on the web site of the book, db-book.com. Instructions for setting upa database, and loading sample data, are provided on the above web site.). Find the maximum enrollment, across all sections, in Fall 2017arrow_forwardBelow is part of a Student database. The primary keys are highlighted in bold. Student (studNo, studName, address, mobileNo) Registration (studNo, courseNo, regDate, semester, session) Course (courseNo, courseName, creditHour, level) Project (projNo, projName, courseNo) QUESTION : 1. Write a PL/SQL PROCEDURE that will list the project names given the course ID. 2. Call the procedure from an anonymous block. Allow the user to enter the course ID (courseno)arrow_forwardplz help with the following use oracle sql or sql live The procedure should satisfy the following requirements. The video number will be provided as a parameter. a) Verify the video number exists in the VIDEO table. If it does not exist, display a message that the video number provided was not found and do not write any data to the database. b) If the video number does exist, then use a Count() function to ensure that the video has only one record in DETAILRENTAL for which it does not have a return date. If more than one row in DETAILRENTAL indicates that the video is rented but not returned, display an error message that the video has multiple outstanding rentals and do not write any data to the database. the databse CREATE TABLE MEMBERSHIP( MEM_NUM CHAR(3) CONSTRAINT MEMBER_MEM_NUM_PK PRIMARY KEY,MEM_FNAME VARCHAR(30) NOT NULL,MEM_LNAME VARCHAR(30) NOT NULL,MEM_STREET VARCHAR(15),MEM_CITY VARCHAR(10),MEM_STATE CHAR(2),MEM_ZIP CHAR(5),MEM_BALANCE NUMBER (2)); ALTER TABLE…arrow_forward
- Instructions Write SQL queries to solve the following problems. We will be using the “university” database. All queries should involve only the instructor table. After you are done, save your work as .sql file and turn in the .sql file into Moodle for grading. Write a SQL statement to display all columns using the SQL asterisk (*) wild-card character. Write a SQL statement to display ID and name of the instructors (ID appears first). Write a SQL statement to display department names. Write a SQL statement to display unique department names. (expect 7 rows returned) Write a SQL statement to display all info about instructors having a salary greater than 75000. (expect 6 rows returned) Write a SQL statement to display department name, instructor name, and salary for instructors that have a salary less than 70000. Sort the results in ascending order by department name. (expect 4 rows returned) Write a SQL statement to display name, department name, and salary for instructors that have a…arrow_forwardThe 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…arrow_forwardIntegrate Python Database Connectors with SQLite3 For this assignment, I will like you to do the following. Create a database called employees. The table should contain first name, last name, age, date of hire, and salary of the employees. You should run various SQL statement using SQLite3. I am looking for the following. 1) Create table 2) Insert employee 3) Update employee 4) Delete employee 5) Delete table.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