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

Walker and avant theory analysis - 2-3 pages summary - Ecs electrician gold card - Cedar ward whipps cross - Given a cyclohexane framework in a chair conformation - Fortune 1000 companies in charlotte nc - Cyber cafe business proposal - 972 464 7674 - Discuss one personal strength and one weakness you have regarding professional presentations - Discussion board - Dame carol black working for a healthier tomorrow - 1 why is maersk's business model complex - Rockdale library opening hours - Five service quality dimensions - Pedagogy of the oppressed chapter 2 - Thomas dudley seal kit - Birmingham and district chess league - We were liars movie - It was much better than cats - An aging of a company's accounts receivable indicates that - Nobody gets in to see the wizard meaning - Medibank private top hospital - How to find the multiplicity of a zero - Forces and motion phet simulation - Music psychology unimelb essay - Apartment renovation math worksheet answers - Grand rapids dying city newsweek - What is external stability in economics - Ato occupation codes 2021 - Suppose you short sell 100 shares - What is a soap note in social work - Minkpink sunglasses david jones - Sugar baby header - Econ assignment 12 hrs - Strategic management involves all of the following except - The immunology virtual lab answers - Mystic monk coffee case pdf - East end market adelaide - 021 - Information Systems - +61 3 8521 4994 - Human Capital Management Using Applied Psychology - New testament survey syllabus - Http www edulink org portfolio philosophies htm - Middleboro casebook case 1 - Collision theory gizmo worksheet answers - Florida everglades ecosystem food web - Beer pong blow out - World and screen nicholas carr summary - Crestron idoc pad2 dsc - Jean lave and etienne wenger situated learning - Written assignment-Transformational leadership - Excel 2016 skills approach ch 3 fix it 3.6 - An object is a ____ of a class - Vigiral - Auditing - Apotheosis of homer vase - Independent variable for bacterial growth - Stagnation definition erikson - Burglar alarm circuit using logic gates - Aviation academy newcastle airport - For higher levels of management responsibility accounting reports - Formula Poetry - Orbits and Gravity: Gravity Puzzle - Chemistry ite ate ide - Jasper company provided the following information for last year - 2011 english language exam - Lección 1 lesson test answers - Cleaver brooks flextube boiler manual - Wk1 DQ - Data Analysis & Business Intelligence - First person to reach south pole - Scholarly activity summary grand canyon university - Neobehaviorism - Appalachian mountain club ct - Aca electrical and design - 1. record your hypothesis from step 1 in the procedure section here. - Strategic supply chain management and logistics assignment - Mayo doused batter fried grackle bugs with honey walnuts - Management information system case study for mba - 3 examples of programming languages - Alterations in the urinary elimination pattern - Assignment 05.03 analyzing an argument - Sulfuric acid 98 percent - Strain gauge factor derivation pdf - Impact of language - Anatomy and physiology final project ideas - Skechers swot analysis - The outsiders multiple choice questions - Yea saying and nay saying - Indiana edu tedfrick plagiarism - Amirkabir university of technology tehran polytechnic - Apple firm infrastructure value chain - How do nonvascular plants transport materials - Depth of field biology - Alfresco admin console community edition - How to install 6 by 9 speakers - 17 caroline street redfern - English Comp 2 Week 8 - Why america is self segregating they say i say - 4009 idnet nac extender