SQL Help Task 4:As a part of marketing strategy, the Marketing team continuously conducting anadvertising campaign on different channels. The team would like to know how thiscampaign is impacting the overall rides being taken through the InstantRide, specificallythe rides which cost $5 or more.You need to send the number of travels calculated for each day and month with theirtotals using Month, Day and Count column names. Furthermore, you can name yoursubquery as PREMIUM_RIDES to work only with the travels with the price of 5 or higher.TaskCalculate the number of premium rides given for each day and month.<> Module 13 Activity 1Instructions Page 3 of 3Task 3:LalThe Driver Relationship team wants to analyze drivers and their car usages in InstantRide</>for the month October. Thus, they want to focus on each driver and respective carallocation occurred. In more detail, the team requires the DRIVER_ID and the CAR_IDwith their usage counts as the TOTAL column for the travels occurred in the month ofOctober. Since the team wants to also learn the total number of the travels by the driversyou need to use GROUP BY ROLLUP functionality.TaskCreate a query to analyze car usage for the month of October.

Actually, database is a used to stores the data.

Task 4: As a part of marketing strategy, the Marketing team continuously conducting an advertising campaign on different channels. The team would like to know how this campaign is impacting the overall rides being taken through the InstantRide, specifically the rides which cost $5 or more. You need to send the number of travels calculated for each day and month with their

Task 4: As a part of marketing strategy, the Marketing team continuously conducting an advertising campaign on different channels. The team would like to know how this campaign is impacting the overall rides being taken through the InstantRide, specifically the rides which cost $5 or more. You need to send the number of travels calculated for each day and month with their

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Ch. 4-problem 3: Given the business rule “an employee may have many degrees,” discuss its effect on attributes, entities, and relationships. (Hint: Remember what a multivalued attribute is and how it might be implemented.) Suppose that an employee has the following degrees: BA, BS, and MBA. These degrees could be stored in a single string as a multivalued attribute named EMP_DEGREE in an EMPLOYEE table such as the one shown next: EMP_NUM EMP_LNAME EMP_DEGREE 123 Carter AA, BBA 124 O’Shanski BBA, MBA, Ph.D. 125 Jones AS 126 Ortez BS, MS Ch. 4-problem 4: What is a composite entity, and when is it used? Ch. 4-problem 5: Suppose you are working within the framework of the conceptual model in Figure Q4.5. Figure Q4.5 The Conceptual Model for Question 5 Given the conceptual model in Figure Q4.5: Write the business rules that are reflected in it. Identify all of the cardinalities. Ch. 4-problem 6: What is a recursive relationship?…
A database of application of wholesaler can be modelled by means of the relations price, in_stock and supplies. Price is a relation over products1…30, which models the association between prices and stock items. In_stock is a relation over productsN, which models the association between stock items and the current number in stock of product. Supplies is a relation over suppliersproducts which models the relation between a supplier and the product that is delivered by that supplier. If the current value of these relations are following:price = {(nut, 5), (bolt, 13), (screw, 3), (board, 25), (fastener, 23)}, in_stock = {(nut, 700), (bolt, 2200), (screw, 55), (board, 0), (fastener, 600)}, supplies = {(Thomas, nut), (Thomas, bolt), (Wilks, bolt), (Wilks, screw), (Wilks, board), (Wilks, fastener), (Rogers, board), (Rogers, fastener)}, then what is the value of the following expressions? i. {nut, bolt} priceii. dom(price 1…15).iii. rng(price 1…10).iv. dom(supplies; (in_stock {0})). v.…
A database has four transactions. Let min_support=60% and min conf=80% TID date Items_bought T100 10/15/99 {K,A,D,B} T200 10/15/2000 {D,A,C,E,B} T300 10/19/2000 {C,A,B,E} T400 10/22/99 {B,A,D} Find all frequent itemset using Apriori and FP-growth respectively, Compare the efficiency of two mining processes List all strong association rules (with support s and confidence c).
Draw an ER diagram and then map it into a relational schema(database) for the following scenario.• For each MEMBER we keep track of the unique MemdID, a well as Name, Zip, and the Datethe membership was paid.• For each MEMBERSHIP type we keep track of the unique Mid, as well as MName and Price• For each PASS CATEGORY we keep track of the unique PassCatID, as well as PCName andPrice• For each ONE DAY PASS we keep track of the unique PassID and Date• For each MERCHANDISE item we keep track of the unique MrchID, as well as Name andPrice• For each sale TRANSACTION we keep track of the unique Tid and Date• Each member pays for exactly one membership type; each membership type has at leastone member but can have many members.• Each member can buy many day passes but does not have to buy any, each day pass wasbought by exactly one member• Each day pass belongs to exactly one pass category; a pass category can have manyindividual day passes issued for it but does not have to have any. • Each…
Q. 1 Consider a university database for the scheduling of classrooms for final exams. This database could be modeled as the single entity set exam, with attributes course-name, section-number, room-number, and time. Alternatively, one or more additional entity sets could be defined, along with relationship sets to replace some of the attributes of the exam entity set, as1. course with attributes name, department, and c-number2. section with attributes s-number and enrollment, and dependent as a weak entity set on course3. room with attributes r-number, capacity, and buildingShow an E-R diagram illustrating the use of all three additional entity sets Listed and also specify the primary keys all
1. Develop a database procedure that takes "student_id" as an input parameter. The procedure should return the GENDER of the student for the given studentId including the output status message and status code for successful completion. 2. Develop a database function that takes category as an input parameter. The function should return how many categories are present.3. Develop a database function that takes eventId as an input parameter. For the given eventId, find out SUM of score for all students for this given eventId
35. For the following problem case description: Identify the objects of interest, potential classes Draw the software architecture diagram. Draw a sequence diagram for this use case Use case name Plantrip Entry condition The Driver logs into the trip planning service. Flow of events 1. The Driver enters constraints for a trip as a sequence of destinations. 2. Based on a database of maps, the planning service computes the shortest way of visiting the destinations in the specified order. The result is a sequence of travel segments concatenated together and a list of directions. 3. The Driver can revise the trip by adding or removing destinations. Exit condition The Driver saves the planned trip by name in the planning service database for later retrieval..
Clayton Elementary School is converting the wish list request form below into online form because of COVID-19. 1. Class Diagram: Class name, attributes, and data type Operations (Methods) that you need to perform 'Fill Wishlist' Relationship between classes. Multiplicity of each relationship Assumptions that you need if any Sequence Diagram: Actor, boundary, and control objects Objects that participate this use case Messages, operations, etc. that indicate a successful filling of the form as illustrated in the form above.
Suppose the due date for a book depends not only on the date the book issued but also on the following factors; - member type (assume 3 types of member -regular, senior, academics- and define rule for these types) - number of books already issued to the member (define a rule yourself) For the requirement defined above, answer the following questions;- Update all Use Case(s) which are affected- Update the Domain Model if necessary- Update all Sequence Diagram(s) and discuss your design in terms of Grasp Patterns Define a simple tax (%10 percent of the sale is added to the sale total) for sale processing. - Update all Use Case(s) which are affected - Update the Domain Model if necessary - Update all Sequence Diagram(s) and discuss your design in terms of Grasp Patterns
If we had another relation, staff, which was union compatible with faculty, what would the following expression return for a result? Πempno (Staff ⋃ Instructor) Select one: a. The employee number of every staff employee and every instructor b. Every employee who is either a member of the staff or an instructor c. All tuples of the instructor relation along with all tuples of the staff relation d. The employee number of all rows in the staff and in the instructor relations
Computer Science 1.Consider a conceptual schema in which the only fact type associated with Department (code) is: Department at Level {UG, PG} has students in Quantity. Here “UG” and “PG” abbreviate “undergraduate” and “postgraduate”, respectively. The role played by Department has a frequency constraint of 2. Let a focused query be: What is the ratio of postgraduate to undergraduate enrollments for the department of computer science? (a) Draw the conceptual fact type, and Rmap it. (b) Optimize the conceptual (sub)schema, and Rmap it. (c) Although primarily identified by its code (e.g., “CS”), each department also has a unique name (e.g., “Computer Science”) which is now mandatorily recorded. The enrollment figures are now optional, but if any figures are recorded, both UG and PG figures are required. Draw the new conceptual schema and Rmap it. (d) Optimize the new conceptual schema, and Rmap it.
G: Race conditions can be occurred in any computer program. Consider a group of two students develop a FYP project and maintain a database in it. One student calls an update( ) function on some data and at the same time second student calls update( ) on the same data to update the database. Describe what problem can be arise in the scenario and what might be done to prevent such problem?