Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

MYSQL

28/10/2020 Client: arwaabdullah Deadline: 2 Day

 


we will work with the Sailingdatabase. Download the sailingDB-JS.sql from and load it in MySQL.Submit your lab report as Word document.


1.Read the statements in sailingDB-JS.sql. For each type of statements, choose one example to explain what that statement does. Refer to the textbook or MySQL reference manual for information.


2. Describe briefly each relation in the Sailing database. Point out the entity relations and association relations and explain your rationale.


3. Queries A and B below demonstrate the impact of order when we use outer jointo connect three or more database tables. Execute each query, then compare the query results, and include in your lab report:


•A screenshot of the results for each query


•An explanation of where and why the results of the two queries differ


Query A: SELECT SA.sid, SA.sname AS Sailor_Name, CONCAT('S:',RA.sid,'-B:',RA.bid) AS Reserv_Track_id, BA.bid, BA.bname AS Boat_NameFROM reserves RA right outer join sailors SA on RA.sid=SA.sid right outer join boats BA on RA.bid=BA.bid;


Query B: SELECT SA.sid, SA.sname AS Sailor_Name, CONCAT('S:',RA.sid,'-B:',RA.bid) AS Reserv_Track_id, BA.bid, BA.bname AS Boat_NameFROM reserves RA right outer join boats BA on RA.bid=BA.bid right outer join sailors SA on RA.sid=SA.sid;


4.QueriesC, D, and E attempt to find the names of sailors who have reserved BOTH a red boat and a green boat. Execute each query, compare the results, and include in your lab report:


•The screenshot of results for each query


•A comparative analysis of the different results


•Explanation of why Query E does not work


Query C: SELECT S.snameFROM Sailors S, Reserves R1,Boats B1,ReservesR2,Boats B2WHERE S.sid=R1.sid AND R1.bid=B1.bidAND S.sid=R2.sid AND R2.bid=B2.bidAND B1.color='red' AND B2.color='green';


Query D:SELECT S.snameFROM Sailors S, Reserves R, Boats BWHERE S.sid=R.sid AND R.bid=B.bid AND B.color='red'AND S.sid IN ( SELECT S2.sidFROM Sailors S2, Boats B2, Reserves R2WHERE S2.sid=R2.sid AND R2.bid=B2.bidAND B2.color='green');


Query E:SELECT S.snameFROM Sailors S, Reserves R, Boats BWHERE S.sid=R.sid AND R.bid=B.bidAND (B.color='red'AND B.color='green');


Reference to database below:

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Top Essay Tutor
Quality Homework Helper
Top Grade Essay
Buy Coursework Help
University Coursework Help
Essay Writing Help
Writer Writer Name Offer Chat
Top Essay Tutor

ONLINE

Top Essay Tutor

I have more than 12 years of experience in managing online classes, exams, and quizzes on different websites like; Connect, McGraw-Hill, and Blackboard. I always provide a guarantee to my clients for their grades.

$135 Chat With Writer
Quality Homework Helper

ONLINE

Quality Homework Helper

Hi dear, I am ready to do your homework in a reasonable price.

$132 Chat With Writer
Top Grade Essay

ONLINE

Top Grade Essay

Working on this platform from a couple of time with exposure of dynamic writing skills gathered with years experience on different other websites.

$132 Chat With Writer
Buy Coursework Help

ONLINE

Buy Coursework Help

Hi dear, I am ready to do your homework in a reasonable price.

$132 Chat With Writer
University Coursework Help

ONLINE

University Coursework Help

Hi dear, I am ready to do your homework in a reasonable price.

$132 Chat With Writer
Essay Writing Help

ONLINE

Essay Writing Help

I am a qualified and experienced Writer, Researcher, Tutor, analyst and Consultant. I hold MBA (Strategic Management) (Finance and Marketing) & CPA.K (Accounting and Finance.)

$132 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Chapter 1 what is psychology worksheet answers - 10 27 police code - Nishat textile mills lahore - Vision mission and strategy of coca cola - Jetmaster gas fireplace manual - MUSIC DISCUSSION - Week 3 - Smoothie king minimum age - A certain light bulb has a tungsten filament - The guitar shoppe reports the following sales forecast - Veltri corporation is working on its direct - Jamie mcintyre net worth - Burger king strengths and weaknesses 2018 - Geography extended essay questions - Charlton college of business - Lululemon athletica inc case study - First poem for you by kim addonizio summary - Mailbox magazine companion preschool april may 2010 learning centers - BU204 Assignment 5 - Discussion / Answer 2 questions and comments / each answer write about 200~300 words / need in 10 hours - Homage to my hips meaning - Why it worked a rhetorical analysis on Obama's speech on race - Reflection paper - The Sermon on the Mount - Education is a never ending process - Certificate ii in retail services online - Environmental scanning in strategic management - Erica olsen swot - Crc publications grand rapids michigan - Algebra 2 cp geometric series worksheet - Ansys mechanical failed to open the database - Softview contact lenses australia - Compare and contrast essay checklist - Functional health assessment of a movie character - Laying egger laminate flooring - Swot analysis of safaricom - SECURITY ARCHITECTURE AND DESIGN (ISOL-536-M31) PHD IN IT - Sensitivity analysis questions and answers - Brothers and sisters i have none riddle answer - Social work intake interview questions - Elena usa el para maquillarse - The story of bottled water norton reader - Glacier tax prep gtp - Criminal Justice - Linux server market share 2012 - Nova college of accounting and business - Poverty in urban areas - Beverly hills puppies inc - A hanging questions and answers - Ps2100 week 4 assignment worksheet - Assignment - Who did president reagan christen as the “heroes for the eighties”? - Capstone Analysis - Abc catch up harrow - Action on the IOM Report/ WEEK 5 DISCUSSION - Part of a tree - The smartest guys in the room book chapter summary - Actual utilization factor formula - Since you ethan derose lyrics - Story of ramanan and chandrika pdf - BUSN601 Week 2 - Lesson 4.7 flowchart thinking answers - Assume 185 and 122 are signed 8 bit decimal integers - Spirituality in nursing standing on holy ground pdf - Microsoft lync web client - TM_Discussion 5 - Belbin team roles test questionnaire free - Unit 2 Assignment: Web Field Trip - Understanding motivation and emotion pdf free - Nmr worksheet with answers - Collins connect answers maths - Acall instruction in 8051 - Protected in class diagram - Cordon investments pty ltd v lesdor properties pty ltd summary - Racq car insurance call - Tutor account on sale - 4908 interboro ave pittsburgh pa 15207 - Similarities and differences between job order costing and process costing - Keith rn case study answers pdf - Bosch water wizard 16p manual - How to calculate population density per square mile - Difference between statistically significant evidence and clinically significant evidence - Investigating the social world 7th edition - Cost accounting chapter 2 ppt - Goodstart early learning webmail - Big mac meal price 1990 - David peat net worth - Lizard evolution virtual lab answer key - Short eassy - 2 tim 2 24 26 - Week 10 environmental science - Al pacino and shakespeare - Long service leave provision calculation aasb - Ray bradbury the pedestrian analysis - Mathematics - University of phoenix mth 217 - First time in forever lyrics - Centre for ecological sciences - Rmit mechanical engineering and business management - Big mac inside the mcdonald's empire worksheet