What suppliers have sold more than 10000 euros

Assignment Help Database Management System
Reference no: EM13327363

1) Consider a Product Orders Database: create tables, connections between tables and fill it with data for tests. Then create SQL querys for the following points:

a) supplyer (supplyer_id->name, address, postal code, phone number, e-mail)
b) product (product_id->name, price, unit)
c) order (order_id->data, supplyer_id, deadline, satisfaction <y/n>)
d) order_line (order_id, line->product_id, quantity)

1.1) Define main key and foreign key. Represent graphically the relational data base, with its tables and connections of foreign keys. Follow this rule: 1:N connections is represented table with just one line above and table with multiple lines below.
Next, write, in SQL, the following querys:

1.2) What products in Kg units?
1.3) What is the product with more orders?
1.4) What suppliers have sold more than 10000 euros?
1.5) Select all products with price less than 20 and unit Kg or liter
1.6) List names and respective prices of products with price greater than the mean of all the other products price
1.7 List all data of suppliers that owed money in the 1st semester of 2011 and do not owed money in the second semester.

2) Using the same database refered above, consult https://www.w3schools.com/SQl/default.asp and answer the following questions:

2.a) Give an example of Left Junction;
2.b) Give an example of Right Junction;
2.c) Give an example of Cartesian Product.

 

Reference no: EM13327363

Questions Cloud

Calculate t if the force of interest is delta given : Using the method of equated time, a payment of 100 at time t = 1 plus a payment of X at time t = 10 is equivalent to a payment of 100 + X at time t = 4. The above two payments of 100 and X are equivalent to a payment of 100 + X at time t
Find how much kinetic energy is lost in the collision : A railroad car of mass 2.4 104 kg moving at 4.00 m/s collides and couples with two coupled railroad cars, How much kinetic energy is lost in the collision
Estimate mary taxable income-tax liability and tax refund : Mary Watson is 24 years old and single, lives in an apartment, and has no dependents. Last year she earned $45,000 as a sales assistant for Focused Business Analytics: $3,910 of her wages was withheld for federal income taxes.
Acceptance of the special order affect net income : Method of evaluating financial data that change under different courses of action - how would the acceptance of the special order affect net income?
What suppliers have sold more than 10000 euros : Define main key and foreign key. Represent graphically the relational data base, with its tables and connections of foreign keys. Follow this rule: 1:N connections is represented table with just one line above and table with multiple lines below.
Determine what are earnings and dividends per share : That Wich Corp. had additions to retained earnings for the year just ended of $328,000. The firm paid out $176,000 in cash dividends, and it has ending total equity of $4.81 million.
What is the amount of scholarship hal should include : For each of the following situations, indicate how much the taxpayer is required to include in gross income: a. Steve was awarded a $5,000 scholarship to attend State Law School. The scholarship pays Steve's tuition and fees.
Write a one page report on sip : Write a one page report on SIP, introduced in the Section 7.4.3 in the textbook, and how SIP is currently being used when providing the interface between the user and an application.
Find the speed of the roller coaster at the top of the loop : The radius of curvature of a loop-the-loop for a roller coaster is 11.8 m. Find the speed of the roller coaster at the top of the loop

Reviews

Write a Review

 

Database Management System Questions & Answers

  Write a memorandum to sam jones

Write a memorandum to Sam Jones (CIO) and present your research findings. Your memorandum should be no longer than 500 words.

  Create the following documents for the proposed system

MGMT321 Group Project: Create the following documents for the proposed system and deliver each SDLC documents by the end of each designated module, as shown below

  Draw dependency diagram after identifying all dependencies

Draw the dependency diagram after identifying all dependencies in this data structure. See Lecture 6, Slide 27 for dependency diagram and convert this data structure to a set of 3NF relations. Clearly showing each step

  Determine the relationship between those areas

For this question, need data mining analysis (using k-means clustering algorithm) shows the relationship between poverty area and violent crime rate (homicide) depending on any one of the datasets attached with this assignment.

  Explain turing and von neumann models

Write a 2 page research paper (excluding the title page) on the Turing and von Neumann models. Compare and contrast each and discuss which model is better and why.

  Design an relational model model

Design an Relational Model (RM) model of a database (DB) that will be useful for each of the chosen enterprises and Implement the 2 enterprise relational DBs using either MySQL or SQLite

  Use embedded sql and c or any programming language

Convert the example of GEOMETRY_OBJECTS given in section 11.1.5 from the functional notation to the notation given in Figure 11.2 that distinguishes between attributes and operations. Use the keyword INHERIT to show that one class inherits from an..

  Create script file to list file in directory in sorted order

Create a script file to list the files in a directory in sorted order, showingonlythe file name, file size, and modification date.Each file's attributes must be on one line per file, in any order.

  Data modeling and normalization

Data Modeling and Normalization

  Explain meaning of expression acid transaction

What is lock granularity? Explain the use of BEGIN, COMMIT, and ROLLBACK TRANSACTION statements. Explain the meaning of expression ACID transaction.

  Demonstrate academic and professional literacy

Demonstrate academic and professional literacy by collating theoretical and practical course material into a workable application through understanding concepts and their practical application using .NET.

  How to improve the quality of datasets

Recommend at least three (3) specific tasks that could be performed to improve the quality of datasets, using the Software Development Life Cycle (SDLC) methodology. Include a thorough description of each activity per each phase.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd