(4) Consider the following two relations in a database:CUSTOMERS:customer_id last_name first_name favorite_website4000JacksonJoetechonthenet.com5000SmithJanedigminecraft.com6000FergusonSamanthabigactivities.com7000ReynoldsAllencheckyourmath.com8000AndersonPaigeNULL9000JohnsonDerektechonthenet.comORDERS:order_id customer_id order_date170002016/04/18250002016/04/1880002016/04/19440002016/04/20NULL2016/05/01What are the data output generated for the following SQL retrievalcommands? (a) SELECT customers.customer_id, orders.order_id, orders.order_dateFROM customers INNER JOIN ordersON customers.customer_id = orders.customer_idORDER BY customers.customer_id;(b) SELECT customers.customer_id, orders.order_id, orders.order_dateFROM customers LEFT OUTER JOIN ordersON customers.customer_id = orders.customer_idORDER BY customers.customer_id;(c) SELECT customers.customer_id, orders.order_id, orders.order_dateFROM customers FULL OUTER JOIN ordersON customers.customer_id = orders.customer_idORDER BY customers.customer_id;

Answer: Answer a: customer_id order_id order_date 4000 4 2016/04/20 5000 2 2016/04/18 7000…

(4) Consider the following two relations in a database: CUSTOMERS: customer_id last_name first_name favorite_website 4000 Jackson Joe techonthenet.com 5000 Smith Jane digminecraft.com 6000 Ferguson Samantha bigactivities.com 7000 Reynolds Allen checkyourmath.com 8000 Anderson Paige NULL 9000 Johnson Derek techonthenet.com ORDERS: order_id customer_id order_date 1 7000 2016/04/18 5000 2016/04/18 8000 2016/04/19 4. 4000 2016/04/20 NULL 2016/05/01 What are the data output generated for the following SQL retrieval commands?

(4) Consider the following two relations in a database: CUSTOMERS: customer_id last_name first_name favorite_website 4000 Jackson Joe techonthenet.com 5000 Smith Jane digminecraft.com 6000 Ferguson Samantha bigactivities.com 7000 Reynolds Allen checkyourmath.com 8000 Anderson Paige NULL 9000 Johnson Derek techonthenet.com ORDERS: order_id customer_id order_date 1 7000 2016/04/18 5000 2016/04/18 8000 2016/04/19 4. 4000 2016/04/20 NULL 2016/05/01 What are the data output generated for the following SQL retrieval commands?

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

SQL Queries: Given the following schema. Primary keys are underlined and highlighted in yellow and foreign keys are bold. The meaning of the relations is straightforward. Medical_Staff(MS_Id, MS_First, MS_Last, MS_PhoneNumber, MS_Occupation, Salary) Blood_Bank(Bank_Id, Bank_Name, Bank_Street, Bank_City, Bank_St, Bank_PhoneNumber) Donor(Donor_Id, Donor_First, Donor_Last, Donor_BloodType, Donor_City, Donor_St, DOB, TotalNumberOfDonations) Donation_Record(Donor_Id, Donation_Date, Donation_Amount) Employee(MS_Id, Bank_Id) Storage(Donor_Id, Donation_Date, Bank_Id) Write SQL queries to answer the following questions: a.Find the average donation amount for Sue Thompson (Donor Id = 3329) for the year 2018. b.Sum all donations by Bank for each State (i.e. the State the blood bank is located in, not the Donor). c.Find the name of the youngest donor and all the donations made in by that donor in 2020.
data
identify the primary keys figure q3.22 the ch03_theather database table
Consider the following schemas: Employee(staffId, name, salary, depNo) primary key staffId foreign key depNo references Department(depNo) Department(depNo,depname, totalSal) primary key depNo and the following procedural SQL statement: CREATE TRIGGER mystery AFTER INSERT ON Employee FOR EACH ROW IF NOT (NEW.depNo IS NULL) UPDATE Department SET totalSal = totalSal + NEW.salary NEW.depNo WHERE depNo ENDIF / = Explain what this trigger does without referring to its code. Describe the effect on the database that it has.
Make your own relation instance(s)○ Determine a schema○ Write a CREATE command for the instance(s)○ Choose another SQL command that modifies the relation and write it in full
JANUARY DATA MANAGEMENT SHORTAND NOTATION FOR RELATIONAL SQL TABLES Notation Underlined Example Meaning The attribute(s) is (are) a primary key The attribute(s) is (are) a foreign key referencing relation R CREATE TABLE R A or A, B A cany SQL type>, B cany SQL type>, C cany SQL type>, D cany SQL type>, E cany SQL type>, A or A", B* Superscript name of relation PRIMARY KEY(A), As an example, the schema FOREIGN KEY (E) REFERENCES S(F) ): R(A, B, C, D, E') S(E, G, H) CREATE TABLE S F , G cany SQL type>, H cany SQL type>, PRIMARY KEY(F)) corresponds to the following SQL tables: EXERCISE Consider the following relational schema, representing five relations describing shopping transactions and information about credit cards generating them [the used notation is explained above]. SHOPPINGTRANSACTION (Transld, Date, Amount, Currency, ExchangeRate, CardNbrREDITCARD, StoreldSTORE) CREDITCARD (CardNbr, CardTypeCARDTYPE, CardowneroWNER, ExpDate, Limit) OWNER (Ownerld, Name, Surname, BirthDate,…
(4) Consider the following two relations in a database: CUSTOMERS: customer_id last_name first_name favorite_website 4000 Jackson Joe techonthenet.com 5000 Smith Jane digminecraft.com 6000 Ferguson Samantha bigactivities.com 7000 Reynolds Allen checkyourmath.com 8000 Anderson Paige NULL 9000 Johnson Derek techonthenet.com ORDERS: order_id customer_id order_date 1 7000 2016/04/18 2 5000 2016/04/18 8000 2016/04/19 4 4000 2016/04/20 NULL 2016/05/01 What are the data output generated for the following SQL retrieval commands?
database
Show all the sql query codes and the output with it please