Question: Read the following scenario and answer ALL questions Include SCREENSHOTS OF SQL STATEMENTS 1) Pet Shop Sdn. Bhd. hires you to be their Project Manager

Read the following scenario and answer ALL questions Include SCREENSHOTS OF

Read the following scenario and answer ALL questions Include SCREENSHOTS OF SQL STATEMENTS 1) Pet Shop Sdn. Bhd. hires you to be their Project Manager cum Database Designer for their new project, a pet boarding management system. Assume you have normalized the raw data into the 3rd Normal Form. Below shows the pet, Owner, Branch and Boarding tables. PET (id, name, type, breed, owneric, dietRemark) OWNER (ic, name, address, phoneNo, points) BRANCH (id, city, capacity) BOARDING (id, petID, branchid, datein, dateOut) (x) Write an SQL that calculates the total price for each boarding. Total price is calculated by multiplying the total number of days with RM15. Display the total price in a column labelled "Total Payment". You should only display the boarding ID, and the total payment column. (xi) Write an SQL statement that shows the average number of days pet owner's sends their pet for boarding

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Harris Corp. is a technology start-up currently in its second year of operations. The company didn't purchase any assets this year but purchased the following assets in the prior year: Placed in...

Read the following scenario and answer ALL questions Include SCREENSHOTS OF SQL STATEMENTS JJ Pet Shop Sdn. Bhd. hires you to be their Project Manager cum Database Designer for their new project, a...

do the database using phpmyAdmin ,and screenshot 1. This lab tutorial is to access CLO2: Construct database queries using Structured Query Language (SQL). 2. This is a one-week lab tutorial. Upload...

Read the following scenario and answer ALL questions in the answer sheet provided. JJ Pet Shop Sdn. Bhd. hires you to be their Project Manager cum Database Designer for their new project, a pet...

JJ Pet Shop Sdn. Bhd. hires you to be their Project Manager cum Database Designer for their new project, a pet boarding management system. Assume you have normalized the raw data into the 3rd Normal...

J] Pet Shop Sdn. Bhd. hires you to be their Project Manager cum Database Designer for their new project, a pet boarding management system. Assume you have normalized the raw data into the 3rd Normal...

Please only provide answer, no explanation needed. Also, there are two sections with SIX QUESTIONS EACH that need to be completed. PAY CLOSE ATTENTION, I need the format with question # and part (Ex....

Due Week 4: Work Breakdown Structure According to the PMBOK Guide, "the WBS is a deliverableoriented hierarchical decomposition of the work to be executed by the project team, to accomplish the...

A plane sinusoidal electromagnetic wave in air has a wavelength of 3.84 cm and an E-field amplitude of 1.35 V/m. (a) What is the frequency? (b) What is the B-field amplitude? (c) What is the...

Write a paper on Internal IT Audit Policy

Which of the following is an investment account in which withdrawals and earnings on the investment are untaxed? Group of answer choices Traditional IRA Futures 401(k) Roth IRA Flag question:...

Which of the following are problems with identifying users of ABC? Multiple select question. ABC means different things to different organizations. Organizations will announce the discontinuance of...

2 How can companies like Shell ensure that managers and key personnel are adequately prepared for international assignments?

2 Is there a relationship between country of origin of the expatriate and success or failure in an assignment (e.g. are Dutch managers more successful expatriates than British or Japanese managers)?...

3 In view of the experiences of Shell outlined above, is there really a problem with expatriate failure? How can this best be safeguarded against? How might this differ between companies such as...