Refer to the sample tables and data below.Tables:employees (id(pk), name, job_code(fk))jobs (code (pk), title, salary)mysql> SELECT * FROM employees;| id | name+--|1 | Captain Hook2Tiger Lily3 | Pocahontas4 | Meeko4 rows in set (0.00 sec)mysql> select * from jobs;| codetitle | salary |+-Iauthor | 100.50200.00|editor3 manager 150.00 ||12I job_code3 rows in set (0.00 sec)21 |foreign key references jobs (code)How many rows will the following commands return?(a) SELECT name, salary FROM employees LEFT JOIN jobs ON job_code= code;(b) SELECT name, salary FROM employees RIGHT JOIN jobs ON job_code = code;[Select][Select]

Answer:- 4 rows will appear Output will be:- Explanation:- As, its a left join so, it will take all…

Tables: employees (id(pk), name, job_code(fk)) jobs (code(pk), title, salary) mysql> SELECT * FROM employees; . | id | name | 1 | Captain Hook | 2 | Tiger Lily | 3 | Pocahontas | 4 | Meeko 4 rows in set (0.00 sec) mysql> select from jobs; code title | salary | 1 author | 100.50 2 | editor | 200.00 3 manager | 150.00 3 rows in set (0.00 sec) How many rows will the following commands return? | job_code | foreign key references jobs (code) 21 21 1 | (a) SELECT name, salary FROM employees LEFT JOIN jobs ON job_code - code; (b) SELECT name, salary FROM employees RIGHT JOIN jobs ON job_code = code; [Select] [Select]

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 FOR THERES TABLES
question 6 use the picture below to answer the following question Add a ZIP field/column to the customer table.
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.
Topic: Database Software: SQLite Schema Table: CREATE TABLE name_basics (nconst VARCHAR(45) NOT NULL, primaryName VARCHAR(45) NULL, birthYear YEAR(4) NULL, deathYear YEAR(4) NULL, age INT NULL, movieNum INT NULL, PRIMARY KEY (nconst)); CREATE TABLE title_episode (episodeID VARCHAR(45) NOT NULL,parentTconst VARCHAR(45) NULL, seasonNumber INT NULL,episodeNumber INT NULL, PRIMARY KEY (episodeID), CONSTRAINT parentTconst FOREIGN KEY (parentTconst) REFERENCES title_basics (tconst) ON DELETE NO ACTION ON UPDATE NO ACTION); CREATE TABLE title_principals (tconst VARCHAR(45) NOT NULL, ordering INT NULL, nconst VARCHAR(45) NULL, category VARCHAR(45) NULL,job VARCHAR(45) NULL, characters VARCHAR(45) NOT NULL, PRIMARY KEY (tconst, characters), CONSTRAINT nconst FOREIGN KEY (nconst)REFERENCES name_basics (nconst) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT tconst FOREIGN KEY (tconst) REFERENCES title_basics (tconst) ON DELETE NO ACTION ON UPDATE NO ACTION); CREATE TABLE title_ratings…
Without using the MAJOR_CUSTOMER VIEW, retrieve the customer ID, first name, and last name for every customer whose credit limit is $500 or less.
Topic: Database Software: SQLite Schema Table: CREATE TABLE name_basics (nconst VARCHAR(45) NOT NULL, primaryName VARCHAR(45) NULL, birthYear YEAR(4) NULL, deathYear YEAR(4) NULL, age INT NULL, movieNum INT NULL, PRIMARY KEY (nconst)); CREATE TABLE attributes (attributeID INT NOT NULL,attribute VARCHAR(45) NOT NULL,PRIMARY KEY (attributeID)); CREATE TABLE attributes_collection (akasID INT NOT NULL,attributeID INT NOT NULL,PRIMARY KEY (akasID, attributeID),CONSTRAINT attributeIDFOREIGN KEY (attributeID)REFERENCES attributes (attributeID)ON DELETE NO ACTIONON UPDATE NO ACTION);CREATE TABLE crew_directors (crewID INT NOT NULL,nconst VARCHAR(45) NOT NULL,PRIMARY KEY (crewID, nconst),CONSTRAINT crewIDFOREIGN KEY (crewID)REFERENCES title_crew (crewID)ON DELETE NO ACTIONON UPDATE NO ACTION,CONSTRAINT nconstFOREIGN KEY (nconst)REFERENCES name_basics (nconst)ON DELETE NO ACTIONON UPDATE NO ACTION);CREATE TABLE crew_writers (crewID INT NOT NULL,nconst VARCHAR(45) NOT NULL,PRIMARY KEY…
Write SQL Queries for following Employee table : EMPLOYEE_ID Name EMAIL HIRE_DATE SALARY DEPARTMENT Juniad@abc.com | 2010-06-18 Irfan@abc.com Hassan@abc.com 2010-03-08 Fahad@abc.com 2013-01-28 110000.00 CS 100000.00 Sales 88000.00 Marketing 101 Juniad Irfan 102 2011-04-16 103 Hassan 104 Fahad 90000.00 Sales 105 Husnain Hus@abc.com 2012-01-28 55000.00 ES 1. Write a query to display sales and marketing department data. 2. Write a query to get the names, salary, PF of all the employees (PF is calculated as 15% of salary). 3. Write a query to get the total salaries payable to employees. 4. Write a query to get the average salary and number of employees in the employees table. 5. Write a query to select first 2 records from a table. 6. Write a query to get the name of employees ends with character 'N'. Such as Hassan etc.
Given the following schema, answer the following questions USERS Attribute Data Type USER_ID NUMBER(3) USER_NAME VARCHAR2(20) USER_TYPE VARCHAR2(10) USER_LIMIT NUMBER(1) BOOKS Attribute Data Type BOOK_ID NUMBER(5) BOOK_TITLE VARCHAR2(25) BOOK_YEAR VARCHAR2(4) Write the SQL code that will create the tables structures for the tables named Books, and Users. Identify and include any PK and FK for both tables.
Composite datatypes may only include multi row and multi column values.Answers: Yes No