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 4CATC
To determine
(a)
To create an index named as TripIndex1 on the TripName field in the Trip table
To determine
(b)
To create an index named TripIndex2 on the Type field in the Trip table
To determine
(c)
To create an index TripIndex3 on the Type and Season fields in the Trip table and list the seasons in descending order.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Write appropriate SQL DDL statements to define the database schema you made in the previous question. Create all the appropriate Referential Integrity constrains.
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)
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
- 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?arrow_forwardparts that follow are the building blocks of most relational DBMSs' physical data structuresarrow_forwardUse 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 notarrow_forward
- 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!arrow_forwardyour database has the information in figure below make the database easy to update and modified by using Normalizationarrow_forwardWhat is store procedure in DBMSarrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology PtrEnhanced 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