QUESTION 4 (10 MARKS) The following tables for part of a database held in a relational...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
QUESTION 4 (10 MARKS) The following tables for part of a database held in a relational DBMS (Primary Key, Foreign Key): CUSTOMER (CustID. CustName. Annual Revenue) TRUCK CITY SHIPMENT (TruckNumber, DriverName) wwwwwww (CityName, Population) wwwwww wwwwwwwwww wwwwwwww wwwwwwww (Shipment Number, CustID, Weight, Year, TruckNumber, CityName) Formulate SQL for the following queries (2 marks each): a. Names of Customers who had shipments in 2020. b. Names of Drivers who drove shipments in 2019 or drove a shipment with a weight greater than 200 tonnes. c. Names of Drivers who drove shipments in 2019 and 2020. d. Total weight of shipments per year for each city. e. Drivers who drove shipments to London but not Paris. QUESTION 4 (10 MARKS) The following tables for part of a database held in a relational DBMS (Primary Key, Foreign Key): CUSTOMER (CustID. CustName. Annual Revenue) TRUCK CITY SHIPMENT (TruckNumber, DriverName) wwwwwww (CityName, Population) wwwwww wwwwwwwwww wwwwwwww wwwwwwww (Shipment Number, CustID, Weight, Year, TruckNumber, CityName) Formulate SQL for the following queries (2 marks each): a. Names of Customers who had shipments in 2020. b. Names of Drivers who drove shipments in 2019 or drove a shipment with a weight greater than 200 tonnes. c. Names of Drivers who drove shipments in 2019 and 2020. d. Total weight of shipments per year for each city. e. Drivers who drove shipments to London but not Paris.
Expert Answer:
Related Book For
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last
Posted Date:
Students also viewed these databases questions
-
Consider the following relational schema: Staff ( staffNo , name, dept, skillCode) Skill ( skillCode , description, chargeOutRate) Project ( projectNo ,...
-
If the resultant of the forces shown passes through point A, determine the magnitude of the unknown pulley tension T. The pulley is welded to the frame and is therefore not free to rotate. 0 280 N...
-
Please help Gary earned \( \$ 97,000 \) as an executive. Gary, who is single, supported his half sister, who lives in a nursing home. His half sister had no income during the year. Gary received the...
-
Debra owned City of Long Beach bonds that were issued several years ago to pay for basic government services. She received $3,800 of interest income from the bonds in the current year. Due to a...
-
When you purchase a bond, why do you have to pay accrued interest?
-
Describe the difference between the two types of criterion validity and provide an example of each.
-
Foxx Corp. purchased 75% of the outstanding shares of Rabb Ltd. on January 1, Year 3, at a cost of $117,000. Non-controlling interest was valued at $35,000 by an independent business valuator at the...
-
How do emerging theories, such as social exchange theory and psychological contract theory, offer insights into the reciprocal dynamics between employers and employees in cultivating sustained...
-
Set one SMART goal for yourself for this year. SMART stands for Specific, Measurable, Attainable, Relevant, and Time-bound. Answer the following questions create SMART goal: What specifically want to...
-
What is the yield to maturity of one simple loan of $800 that its interest payment is $108?
-
Spot price of silver is $21.32/oz and the quoted interest rate is 1.94% for 4 months. There are no storage or transaction costs, but borrowers have to pay 0.58% above the quoted rate. Determine the...
-
Currently, the spot exchange rate is USD/AUD = 0.85, and the one-year forward exchange rate is USD/AUD = 0.90. One-year risk-free interest rate is 5.5 % in Australia and 3.2% in the United States....
-
A pet store has 5 birds, 8 dogs, 3 cats and 4 lizards. A person walks into the store and wants to purchase 3 pets. Assuming equally likely outcomes, what is the probability that all 3 pets are of the...
-
You have started working with an event company (Pick a name of your choice). The company can't sell event tickets on its website, so they use third-party services. The marketing department spends a...
-
Sandra started up her own business a couple of years ago. It has been tough getting it going. In fact, she has incurred a loss each year so far (i.e. her expenses have been greater than her income)...
-
An 8.0 kg crate is pulled 5.0 m up a 30 incline by a rope angled 18 above the incline. The tension in the rope is 120 N, and the crates coefficient of kinetic friction on the incline is 0.25. a. How...
-
Give an example of a column A and a column B such that B is functionally dependent on A. Give an example of a column C and a column D such that D is not functionally dependent on C.
-
The owner of Colonial Adventure Tours knows the importance of the SQL language in database management. He realizes that he can use SQL to perform the same functions that you performed with queries in...
-
When do you use OLAP?
-
Examine Fowlers account pattern on following characteristics: a. Simplicity b. Generality c. Completeness d. Stability e. Visual and graphical model f. Testability
-
What is Fowlers account pattern? Explain with the help of a diagram.
-
Draw a class diagram for resource rental pattern and its installation for library service by using analogy approach.
Study smarter with the SolutionInn App