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

Sizzling starts for persuasive writing - Molar mass for benzoic acid - Bpcc debit - How to calculate field of view biology - The developing child homework activities answer key chapter 4 - Ati basic concept template legal responsibilities - John deere 42 hydraulic tiller manual - How to measure fetal thoracic circumference - BUS-FP3050 Assessment 3 Communicating a Team Vision - Pearson places not working - Global issues - What is a hypothetical experiment - Acls patient cases robert mccrae answers - Mnemonic device for scientific method - Why does methylene blue turn colourless - Is elroy berdahl a real person - Social work role play examples - Navy chief eval bullets - 5 - Module 3 Journal Article Analysis - Avondale lake macquarie campus - Sans disaster recovery plan template - ℂhild/Baby+91-9829866507 ℙroblem Solution Specialist Molvi Ji - BI - Case Study reflection - Implement and monitor environmentally sustainable practices - Financial planning association of australia - Rewrite each of the following as a base ten numeral - APA Paper - Keep change flip integers - The murderous mansion of mr uno script - Microcontroller Need it in 5 hours - Single effect evaporator calculations pdf - Oxide ion protons neutrons electrons - Advantages and disadvantages of rubrics - Civil right/ must be original work/ no plagiarism/ scholarly resources 2015/ turn in ready - Keep your hands to yourself karaoke - Pacific dunlop ltd v hogan case summary - Voices of freedom eric foner 4th edition volume 1 pdf - Anthropology schools of thought - Essentials of investments 10th edition pdf - Halo wars 2 leaders strengths and weaknesses - Topic: Elkins Farms - Melton borough council planning - Cass pennant net worth - Fill in the missing values in the table below - Week 2 - Assignment: Evaluate Decision-Making Processes and Knowledge Needs for Successful Decision-Making - Are you able to help me - 3 - Dunkin donuts distribution channels - How to make a lineweaver burk plot from michaelis menten - Commis de rang meaning - Question - WEEK 8 - Snpha national conference 2017 schedule - Case study on apple inc - Emerging trends in industrial relations - Cybertext building blocks of accounting a financial perspective - Chemistry - Business ethics: Journal Article Analysis4 - Teuer furniture - Strategies for market leaders challengers followers and nichers - 7 tools of quality control ppt - How to make a beer's law plot in excel - Moshi monsters sign up - Ethics and accountability in public administration - Professional Assignment in Managerial Economics (BUS 505) - What is advertising execution - Tools for mindful living pdf - Choose a topic from Micro economics that matters to you and find a recent news article covering that topic. - Case study - Antifreeze solute and solvent - 4240 carnation ln las vegas nv 89108 - Bankable feasibility study template - Relational database optimized for online transactions - Mental illness informative speech outline - Paper due tomorrow - Hhmi lizard evolution virtual lab answers - 2 components of fitness - Dalton conley you may ask yourself chapter summaries - Pulp vitality test ppt - Good persuasive essay topics for 8th graders - Chinese english medical terminology - Assignment: Interoperable Communications Among Agencies - The basic practice of statistics pdf - What should costa vida's compensation strategy look like - Gymnosperms were the first plants to reproduce using - Who killed katie in mystic river - Week 4 research paper - Personal Business Management Brief - Starbucks opened its first store in zagreb - Physics formula sheet hsc - Final project - Essay assignments - M1 m2 buses timetable bournemouth - Warren buffett 2005 case study - What was hulegu's greatest military accomplishment - Annotated Bibliography - Kent institute moodle - Guy sebastian standing with you piano sheet music - Outline text effect lime accent 3