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 3CATC
To determine
To create a view named ReservationCustomer consists of the reservation ID, trip ID, trip date, customer number, customer last name, customer first name, and phone number and display the data in the view.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
List out various user authorization to modify the database Schema
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
How can the key and foreign key constraints be enforced by the DBMS?
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
- An integrity constraint is a mechanism used by any DBMS tool to prevent invalid data entry into the table. Suggest all possible actions to be taken for preventing the violation of the data integrity constraints.arrow_forwardList two reasons why null values might be introduced into the database.arrow_forwardThe following tables form part of a database held in a relational DBMS: • Hotel (hotelNo, hotelName, city) • Room (roomNo, hotelNo, type, price) • Booking (hotelNo, guestNo, dateFrom, dateTo, roomNo) • Guest (guestNo, guestName, guestAddress) where Hotel contains hotel details and hotelNo is the primary key; Room contains room details for each hotel and (roomNo, hotelNo) forms the primary key; Booking contains details of bookings and (hotelNo, guestNo, dateFrom) forms the primary key; Guest contains guest details and guestNo is the primary key. 1. Identify the foreign keys in this schema. Explain how the entity and referential integrity rules apply to these relations. 2. Produce some sample tables for these relations that observe the relational integrity rules. Suggest some general constraints that would be appropriate for this schema. 3. Analyze the RDBMSS that you are currently using. Determine the support the system provides for primary keys, alternate keys, foreign keys, relational…arrow_forward
- The following tables form part of a database held in a relational DBMS:Hotel (hotelNo, hotelName, city)Room (roomNo, hotelNo, type, price)Booking (hotelNo, guestNo, dateFrom, dateTo, roomNo)Guest (guestNo, guestName, guestAddress)• Hotel contains hotel details and hotelNo is the primary key;• Room contains room details for each hotel and (roomNo, hotelNo) forms the primarykey;• Booking contains details of the bookings and (hotelNo, guestNo, dateFrom) forms theprimary key;• Guest contains guest details and guestNo is the primary key.Download and install PostgreSQL (Version 14.5). Create the tables for the four rela-tions using the integrity enhancement features of SQL (using the “CREATE TABLE” state-ments) and populate at least 5 tuples for each relation (using the “INSERT” statements)in PostgreSQL. Please report the screenshots of these SQL statements generated fromPostgreSQL.Run the SQL statements for the following queries and report the screenshotsof these SQL statements and the…arrow_forwardThe following tables form part of a database held in a relational DBMS:Hotel (hotelNo, hotelName, city)Room (roomNo, hotelNo, type, price)Booking (hotelNo, guestNo, dateFrom, dateTo, roomNo)Guest (guestNo, guestName, guestAddress)• Hotel contains hotel details and hotelNo is the primary key;• Room contains room details for each hotel and (roomNo, hotelNo) forms the primarykey;• Booking contains details of the bookings and (hotelNo, guestNo, dateFrom) forms theprimary key;• Guest contains guest details and guestNo is the primary key.Run the SQL statements for the following queries and report the screenshotsof these SQL statements and the results generated from PostgreSQL.(a) List the roomNo, type, and price of the Biltmore Hotel (using subquery) (or a specifichotel name in your database).(b) What is the average price of a room?(c) List the guestNo and gusetName of guests who live in Chicago or Seattle, alphabeticallyordered by their names.(d) List the number of rooms in each hotel in…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