SQL Query Assignment Help | Database Homework Task
Database Assignment Help is a most important subject of Computer Science. We provide database experts to design your database and will complete database homework assignment and solutions to the questions related to Query ,Sub-query,Join etc.Addition of database assignment help we do RDBMS, DBMS, SQL Query Problems, Database Design,
Database is the central part for any company, Organization or website. Database Management System or DBMS refers to the technology of storing and retrieving users’ data with utmost efficiency along with appropriate security measures.
The basics of DBMS such as its database architecture, data models, database schemas, Tables, Touple, Feilds, data independence, E-R model, relation model, relational database design, and storage and file structure and much more.
We are very excited to make solution for all your database problem or database queries. Someone who are looking for Database homework help or help with Database SQL scripts or Help with database program Procedural language or PLSQL can visit us .
Topics like E-R diagram, Generalization, Specialization, Normalization, ACID properties and more.
Database assignment Help
Database Assignment examples
1. Do My SQL Query
i'm in need for some SQL queries.
And possibly some database optimizations.
and a quick explanation of the tables:
results: identifies the results for a specific tid (tournament)
matches: gives the result for each tid of the matches disputed. the result (1) indicates if the winner was team1+deckone or (2), team2,decktwo.
The queries i will need are:
a) Select distinct from results the deck and number of times it appears
Deck : total ------------ red : 5 Yellow : 2 Blue: 6
b) A select from the table matches that will give the win rates from a specified deck.
meaning, counting all the ocorrences of deck, and times it won, against what. Ignore when deckone = decktwo
Deck : wins : loses : total ____________________________ Yellow : 5 : 2 : 7 Blue : 2 : 2 : 4
c) Same as previous querie, except it relates to other decks.
global win = total wins / total plays.
win vs x = wins vs deck x / plays vs deck x
example expected (don't need the % calculated, i can do that, just need to wins and totals).
Deck : global win : win vs Yell : win vs blue : win vs Pink ------------------------------------------------------------- Yell : 50% : - : 20% : 50% : 80% Blue : 40% : 30% : - : 20% : 45% Pink : 90% : 50% : 100% : 70% : -
d) A mix of a) + c) Meaning to include a new collum with: (number of deck)/total.
click here to see solutions