77 357
Assignments Done
Successfully Done
In July 2019

Databases | SQL | Oracle | MS Access Answers

Questions: 229

Free Answers by our Experts: 144

Ask Your question

Need a fast expert's response?

Submit order

and get a quick answer at the best price

for any assignment or question with DETAILED EXPLANATIONS!

Search & Filtering

Define and discuss the concept of transitive dependency. Include an example. (
Suppose you have student data that is captured in a table as shown below. Normalize the data in this
table to 3NF.

Student Age Subject
Asongile 15 Afrikaans, Life skills
Avela 14 Life skills
Sibusiso 17. Life skills
What is SQL, and is SQL a scripting language? What do you have to support your answer?
3. Find audio tracks which have a length longer than the average length of all
the audio tracks;
4. Which playlists do not contain any tracks for the artists “Black Sabbath" nor
“Chico Buarque"?

~~ Tracks is a table
~~ Playlist is a table
Name Region Area Population GDP
Afghanistan South Asia 652225 260000000
Albania Europe 28728 3200000 6656000000
Algeria Middle East 2400000 32900000 75012000000
Andorra Europe 468 64000
Bangladesh South Asia 143998 152600000 67144000000
United Kingdom Europe 242514 59600000 2022824000

Now based on the above table

a) Write a query that shows the name, region and population of the smallest country in each region.

b) Select the code that shows the countries with population smaller than Russia but bigger than Denmark
Write the queries that will do the following:

1. Select the top 10 countries with the most number of ip blocks allocated to it and the number of address blocks in it. Order if from greatest to least.

2. Select the top 10 cities with the most number of ip blocks in the united states and the number of address blocks in it. Order it from greatest to least.

3. Select the cities in the united states that have between 4,000 - 5,000 ip address blocks ordered from least to greatest.

4. Select the average number of ip blocks that would be found in a city for each state. Order it by state from least to greatest or A-Z.

The relational tables are below:


country(fk pointing to id in countries table)

country(fk pointing to id in countries table)
city(fk pointing to city in CityByCountry table)
First of all go to https://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all.
This is the link to W3Schools MySQL Tryit Editor
and the sample database we are using.

1. Write a query that lists the first name and the number of sales of each
employee including the ones that has not received any orders yet.
2. Write a query that calculates and lists the total price of each order.
3. Write a query that lists the name of each different product shipped by
Speedy Express.
How many levels of abstraction a typical database should hold
Write a SQL query for the following:

1. I need to know which of our sales reps don’t have any customers, all regions. (Hint: This is a different type of JOIN. Also, test for nulls and eliminate the managers.)

2. tell me which region managers are responsible for those sales reps who don’t have customers in all regions. Display the region ID, I can get the full name separately. (Hint: You’ll need to see the entire employee/customer list to provide this answer)
I want a list of employees in the east and west regions and I need the full region name, not just the region ID.
Privacy policy Terms and Conditions