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.
|
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
|