Question 16ListenIn the tables described below, which column is a foreign key?SKU_DATA (SKU, SKU_Description, Buyer)BUYER (Buyer, Department)a) Buyer in the SKU_DATA tableO b) Buyer in BUYER tablec) SKU_Description in the SKU DATA tabled) None of the above

Foreign Key is a key present in another table used to refer primary key of another table. Here,…

Question 16 )Listen In the tables described below, which column is a foreign key? SKU_DATA (SKU, SKU_Description, Buyer) BUYER (Buyer, Department) O a) Buyer in the SKU_DATA table O b) Buyer in BUYER table O c) SKU_Description in the SKU_DATA table d) None of the above

Question 16 )Listen In the tables described below, which column is a foreign key? SKU_DATA (SKU, SKU_Description, Buyer) BUYER (Buyer, Department) O a) Buyer in the SKU_DATA table O b) Buyer in BUYER table O c) SKU_Description in the SKU_DATA table d) None of the above

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

Write query to create given table 'MAIN'
Create a table named Clerks, with 3 columns (employee-id, first name and job_id) where all employees whose job id are clerks.
Which clause can be used to restrict or filter the groups returned by a group function- based query?
Question 18 The query in the figure below:. BRANCH SALESPERSON 1 Dr ID Br_Name Em ID TITLE FIRST LAST Gender DOB PASSWORD Dr ID SALART Field Br Name Table BRANCH TILE SALESPERSON First Last SALESPERSON, SALARY SALESPERSON SALESPERSON Sort Show Criteria RTa" DE A. The First, Last, and SALARY for all salespersons who did not work in a Riffa branch will be listed The Br Name, TITLE, First, Last, and SALARY for all salespersons who live in Manama will be listed The Br Name, TITLE, First, Last, and SALARY for all salespersons Mwill be listed The Br Name, TITLE, First Last, and SALARY for all salespersons who worked in a Riffa branch will be listed
Answer plz as soon as possible
Practice Question 6
Create a query for displaying all data of employees who have joined company before 14-JUL-03 OR after 26-OCT-05.
Display the name of customer 16 and the names of all the customers that are in the same zip code as customer 16. (Be sure this query will work for any customer.) Rewrite your answer to Problem for each customer, not just customer 16.
Examine the Employees table. Note that the data in the Title field contains redundant values and therefore is a candidate for a one-field lookup table. Use your Access Query Design View or SQL skils to create a lookup table named Titles with the unique values in the Title field of the employees table. List the steps you performed to create the lookup table
database
Write the SQL code that will produce the results shown as below. Write the SQL code to calculate the ASSIGN_CHARGE values in the ASSIGNMENT table. Note that ASSIGN_CHARGE is a derived attribute that is calculated by multiplying ASSIGN_CHG_HR by ASSIGN_HOURS. Write the SQL code that will yield the total number of hours worked for each employee and the total charges stemming from those hours worked. The result is shown as below.
i need code sql THE TABLES (PROJECT, DEPARTMENT, EMPLOY). • Each EMPLOY has (nemp, ID number, ndept, nproj,salary) NEMP NOT NULL VARCAHR(30) PRIMARY KEY, ID_NUMBER(10) NOT NULL, NDEPT VARCAHR(15), NPROJ VARCAHR(7) PRIMARY KEY, SALARY NUMBER(17). Requirements • Each PROJECT has (nproj, ndept,nemp) NPROJ VARCAHR(15) NOT NULL FOREGIN KEY KEY, NEMP VARCAHRH(30) PRIMARY KEY, NDEPT VARCAHR(10). • Each DEPARTMENT has(ndept, number nemp) Number NUMBER(3), NDEPT VARCAHR(30) NOT NULL, NEMP VARCAHR(15) FORGEIN KEY. Entity Relationship THE EMPOLY HAS A NEMP AND NPROJ AS PRIMARY KEY WILL CONACTED TO BOTH DEPARTMENT AND PROJECT AS FOREIGN KEY. THE PROJECT HAS A NPROJ AS FORGIEN KEY WILL CONACTED TO EMPOLY AS PRIMARY KEY. THE DEPARTMENT HAS A NEMP AS FORGIEN KEY WILL CONACTED TO BOTH EMPLOY AND PROJECT AS PRIMARY KEY. (RELASHINSHEP: EVERY DEPARTMENT has PROJECT and EVERY EMPLOY work on PROJECT and work in DEPARTMENT)