Modern Database Management (12th Edition)
12th Edition
ISBN: 9780133544619
Author: Jeffrey A. Hoffer, Ramesh Venkataraman, Heikki Topi
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 7, Problem 7.57PAE
Program Plan Intro
To list:
SQL query for the customer name, and number of vendors in the same state.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Q4
There are 9 workers for ASH Development Sdn. Bhd.
Unfortunately, there are only 4 rooms available for these workers. Every
week, a worker name is randomly selected to do odd jobs for the company.
When a worker has been selected randomly, a
these rooms are full. Based on Figure Q4, worker's ID number 0 (Umar) is
randomly selected for the first week, and the 4 boxes represent 4 rooms for
as shown in Table Q4.
room needs to be vacated if
workers.
Table Q4
Worker's ID
Worker's Name
Umar
1.
Lukman
Arif
Yusuf
Anas
Muadz
Aleef
Hafiz
8.
Amir
9.
Taufik
WI
4
6
2
9.
4
1
3
8
D
R2
R3
R4
W
W
W1
w1
Wi
w1
W1
w1
w1
wi
Wi
W1
2
3
4 56
78 9
1
2
3
4
5
6
8
9
Figure Q4
Investigate the number of page faults occur by illustrating the way how the room is managed
using the list of weekly random selection of workers as shown in Figure Q4 using the
following algorithms:
(a)
Optimal Page Replacement (OPR) replacement algorithm
2.
RRR
CUSTOMER
Customer table is composed of customer number, name and phone number.
Give and fill-in the appropriate attribute name for each of the column.
custID
123
124
125
126
reservelD
5001
5002
5003
5004
5005
5006
5007
RESERVATION
Each reservation is for one taxi. Reservation table is composed of reservation identification number, start
reservation date, end reservation date, reservation days requested by customers starting from reservation
date until end of reservation date, customer number that make the reservation and taxi number assigned
to the reservation.
Give and fill-in the appropriate attribute name for each of the column.
taxill
custName
Ahmad Bin Abdullah
Fatimah Binti Adam
LAI
LA2
Ruqayya Binti Idris
Sulaiman Bin Daud
LA3
LA4
startDate
01/10/2019
05/10/2019
05/10/2019
15/10/2019
20/10/2019
27/10/2019
02/11/2019
taxiType
endDate
03/10/2019
12/10/2019
08/10/2019
17/10/2019
25/10/2019
Sedan
Sedan
Van
Van
30/10/2019
04/11/2019
cust Phoneno
TAXI
Taxi table is composed of taxi…
You will be using the Colonial Adventure Tours database. How many current reservations does Colonial Adventure Tours have and what is the total number of persons for all reservations?
Chapter 7 Solutions
Modern Database Management (12th Edition)
Ch. 7 - Prob. 7.1RQCh. 7 - Prob. 7.2RQCh. 7 - Prob. 7.3RQCh. 7 - Prob. 7.4RQCh. 7 - Prob. 7.5RQCh. 7 - Explain the relationship between EXISTS and...Ch. 7 - Prob. 7.7RQCh. 7 - Prob. 7.8RQCh. 7 - Prob. 7.9RQCh. 7 - Prob. 7.10RQ
Ch. 7 - Under what conditions can a UNION clause be used?Ch. 7 - Prob. 7.12RQCh. 7 - Prob. 7.13RQCh. 7 - List for advantages of SQL-invoked routines.Ch. 7 - Prob. 7.15RQCh. 7 - Prob. 7.16RQCh. 7 - Prob. 7.17RQCh. 7 - Prob. 7.18RQCh. 7 - Prob. 7.19RQCh. 7 - Prob. 7.20RQCh. 7 - Prob. 7.21RQCh. 7 - Prob. 7.22RQCh. 7 - Prob. 7.23RQCh. 7 - This chapter discusses the data dictionary views...Ch. 7 - Prob. 7.25PAECh. 7 - Prob. 7.26PAECh. 7 - Prob. 7.27PAECh. 7 - Are based on the class schedule 3NF relations...Ch. 7 - Prob. 7.29PAECh. 7 - Prob. 7.30PAECh. 7 - Prob. 7.31PAECh. 7 - Are based on Figure 7-17. This problem set...Ch. 7 - Prob. 7.33PAECh. 7 - Prob. 7.34PAECh. 7 - Prob. 7.35PAECh. 7 - Prob. 7.36PAECh. 7 - Prob. 7.37PAECh. 7 - Prob. 7.38PAECh. 7 - Prob. 7.39PAECh. 7 - Prob. 7.40PAECh. 7 - Prob. 7.41PAECh. 7 - Prob. 7.42PAECh. 7 - Prob. 7.43PAECh. 7 - Prob. 7.44PAECh. 7 - Write an SQL query to display the order number,...Ch. 7 - Prob. 7.46PAECh. 7 - Prob. 7.47PAECh. 7 - Prob. 7.48PAECh. 7 - Prob. 7.49PAECh. 7 - Prob. 7.50PAECh. 7 - Write an SQL query to list each customer who...Ch. 7 - Prob. 7.52PAECh. 7 - Modify Problem and Exercise 6-60 so that the list...Ch. 7 - Prob. 7.54PAECh. 7 - Prob. 7.55PAECh. 7 - Prob. 7.56PAECh. 7 - Prob. 7.57PAECh. 7 - Prob. 7.58PAECh. 7 - Prob. 7.59PAECh. 7 - Prob. 7.60PAECh. 7 - Prob. 7.61PAECh. 7 - Prob. 7.62PAECh. 7 - Prob. 7.63PAECh. 7 - Rewrite your answer to Problem and Exercise 6-71...Ch. 7 - Display the customer ID, name, and order ID for...Ch. 7 - Prob. 7.66PAECh. 7 - Prob. 7.67PAECh. 7 - Prob. 7.68PAECh. 7 - Prob. 7.69PAECh. 7 - Prob. 7.70PAECh. 7 - Prob. 7.71PAECh. 7 - Write an SQL query to list the order number,...Ch. 7 - Prob. 7.73PAECh. 7 - Prob. 7.74PAECh. 7 - Prob. 7.75PAECh. 7 - Prob. 7.76PAE
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- Ensure that the only legal values for the BDRMS column in the CONDO_UNIT table are 1, 2, or 3.arrow_forwardSQL Querry Find the list of courses who haven’t got any section opened in Spring 2019. (Use outer join!)arrow_forwardThe Driver Relationship team wants to ensure that the all driving license IDs in the active drivers table have the length of 7. Alter the ACTIVE_DRIVERS table created in Chapter 8, Activity 1 to check the length of the DRIVER_DRIVING_LICENSE_ID.arrow_forward
- Given the following relation that stores details of student registration: Stu_ID Name Town Province Course RegisteredDate S101 Malak Al Nadabi Al Khuwair Western ITDR2106 02-02-2020 S101 Malak Al Nadabi Al Khuwair Western ITDR1105 14-09-2019 S102 Nadar Al Hashli Daesit Southern ITDR1102 05-02-2020 S102 Nadar Al Hashli Daesit Southern ITDR1101 05-02-2020 S103 Basit Barkat Ruwi Central ITDR1105 06-02-2020 S104 Yeshan Al Khuwair Western ITDR2106 15-09-2019 If the functional dependencies are consistent with the above relation, put TRUE. If they are not, put FALSE. Stu_ID à Name, Town Town à Province Course à RegisteredDate RegisteredDate à Course Stu_ID, Course à RegisteredDate Stu_ID à Course Stu_IDarrow_forwardSome rows of the STUDENT table are shown below: CODE NAME GPA YEAR 291 ALEX 3.1 2 938 MICHELE 2.3 1 931 JHON 3.3 1 182 JOE 3.4 2 190 REY 2.0 2 330 RON 3.9 3 Which best describes the result of the query below? SELECT YEAR, AVG(GPA) FROM STUDENT WHERE GPA > 2.0 GROUP BY YEAR a. The average maximum GPA of all the students in each year. b. The year of the student with the maximum GPA. c. The average GPA of students with a GPA higher than 2.0 each year. d. The average GPA of the students with a GPA higher than 2.0.arrow_forwardHR wants to send the completed budget reports to the various department managers. To do so, they need a current listing of the department managers to contact. For this query, the HR department needs the department name, manager first name, manager last name, and job title. The results must be sorted by department name and include the elements in the order listed. This needs to be done in SQLarrow_forward
- The query in the figure below. PROGRAM 1 Dept ID PROGRAM ACADEMIC ADVISOR STUDENT OFFICE PHONE 1 SID Name GPA Gender Dept ID Field: SID Table: STUDENT Sort Show Criteria: Name STUDENT PROGRAM PROGRAM GPA STUDENT Accounting" or Name and PROGRAM for the students who registered in the A program "Accounting" will be listed SID, Name, PROGRAM, and GPA for the students who registered in the B program "Accounting" will be listed SID and GPA for the students who registered in the program "Accounting" will be listed Name and GPA for the students who registered in the program "Accounting will be listedarrow_forwarddatabasearrow_forwardDesign a query of Stores with the following: Store Name, Store Size, Sum of order amounts, Percent of unpaid order amount, Weighted average volume discount. a. Volume discount: Percent difference between order amount and payment amount Design a query of Stores with the following: Store Name, Sum of all order amounts, Number of all orders, Top customer name, Top customer sum of invoice amounts, Top customer number of invoices, Top customer % of total invoice amount. (4 different tables : Orders table: orderid storeid customerid OrderDate OrderAmount paymentid PreferredOrder orderstatusid Customers table: customerid Name Company Type ContractDate PreferredEnrollmentDate PreferredVoidDate Payments Table: paymentid VolumeDiscount PaymentAmount PaymentDate PaymentMethod Stores Table : storeid Name Store Size Category ContractDate Type Order Status: orderstatusid Namearrow_forward
- Below is the answer I got but it is incorrect select PROJ_NUM, ROUND(SUM(ASSIGN_HOURS),2) as 'TOTAL_HOURS', ROUND(SUM(ASSIGN_CHARGE),2) as 'TOTAL_CHARGE' from ASSIGNMENT -- from ASSIGNMENT table group by PROJ_NUM; -- group by to aggregate per PROJ_NUMarrow_forwardhow do you Calculate a query in access database on how many customers there are for each lawn size? if the customers is 30 and the lawn size are 4 different lawns (commercial, large, medium and small?arrow_forwardDatabase systems In SQL MurachCollege database. Provide a list of all of the students, the number of courses they are taking, and the number of different instructors they have across all of their courses. The first column should provide the last name of each student (column titled Student Last Name). The second column should provide the number of courses that each student is taking (column titled Number of Courses). The third column should provide the number of different instructors that each student has for all of the courses they are taking (column titled Number of Different Instructors). No other columns should be provided in the result. Organize the result by student last name in alphabetical order.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage
A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology Ptr
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781285196145Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos CoronelPublisher:Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning