Which one is correctWhich SQL statement defines the FOREIGN KEY constraint on the DEPTNO column of the EMP table?EMPLOYEESEMPLOYEE ID EMP NAME DEPT ID MGR ID JOB IDSALARY4000S00101Smith20SA REPCLERK120102MartinChrisJohnDianaSmithJenniferBobRavi1010510310420120ADMIN4200301051061081O8110HR CLERK 2500IT ADMINAD ASST30SO00FO0040108110120304020110HR DIR6500110SA DIR6500DEPARTMENTSDEPARTMENT ID DEPARTMENT NAE10203040AdminEducationITHuman ResourcesCREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptnoO NUMBER(7,2) NOT NULL, CONSTRAINT emp_deptno_fk FOREIGN KEY deptnoREFERENCES dept deptno);CRETE TABLE EM (empno NUMBER(4), ename VARCHAR2(35) deptno NUMBER (7,2)O NOT NULL, CONSTRAINT em_deptno_fk REFERENCES dept (deptno) FOREIGN KEY(deptno));CREATE TABLE EMP (empno NUMBER (4), ename VARCHAR2(35), deptnoONUMBER(7,2) FOREIGN KEY CONSTRAINT emp deptno fk REFERENCES dept(deptno));CREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptnoNUMBER(7,2) CONSTRAINT emp_deptno_fk FOREIGN KEY(deptno)REFERENCES dept(deptno);None of above

Tables are database objects that contain all the data in a database. In tables the data is logically…

Which SQL statement defines the FOREIGN KEY constraint on the DEPTNO column of the EMP table? EMPLOYEES EMPLOYEE ID EMP NAME DEPT ID MGR ID JOB ID SALARY 4000 2500 101 Smith 20 SA REP 120 105 120 102 Martin 10 CLERK 103 Chris John Diana Smith 20 ADMIN HR CLERK 2500 IT ADMIN IT 4200 104 105 106 30 108 30 108 5000 40 110 AD ASST 3000 108 110 120 Jennifer Bob 30 HR DIR EX DIR SA DIR 110 6500 40 SO00 Ravi 20 110 6500 DEPARTMENTS DEPARTMENT ID DEPARTMENT NAME 10 20 30 40 Admin Education IT Human Resources

Which SQL statement defines the FOREIGN KEY constraint on the DEPTNO column of the EMP table? EMPLOYEES EMPLOYEE ID EMP NAME DEPT ID MGR ID JOB ID SALARY 4000 2500 101 Smith 20 SA REP 120 105 120 102 Martin 10 CLERK 103 Chris John Diana Smith 20 ADMIN HR CLERK 2500 IT ADMIN IT 4200 104 105 106 30 108 30 108 5000 40 110 AD ASST 3000 108 110 120 Jennifer Bob 30 HR DIR EX DIR SA DIR 110 6500 40 SO00 Ravi 20 110 6500 DEPARTMENTS DEPARTMENT ID DEPARTMENT NAME 10 20 30 40 Admin Education IT Human Resources

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

Convert and Insert the table into the SQL command
database: sql Q1. Create the following tables: Carrier Attribute name Type Size Constraint carrierID Varchar2 10 Primary key carrierName Varchar2 100 NOT NULL Phone Varchar2 50 LIKE ‘+966%’ Range Varchar2 30 Value is either ‘International’ or ‘Local’ Review Attribute name Type Size Constraint ReviewID INT Primary key Stars INT NOT NULL Comment Varchar2 70 Name Varchar2 50 Default ’User’ CustomerID INT Foreign key references customers ProductID INT
Use the following tables to write the SQL queries: Table Name: Employees EMPLOYEE_ID FIRST_NAME HIRE DATE JOB_ID SALARY DEPARTMENT_ID 100 Steven 02/13/2008 AD PRES 24000 90 101 Neena 05/20/2010 AD_VP 17000 90 102 Lex 09/11/2013 AD VP 17000 90 103 Alexander 09/01/2010 IT PROG 9000 60 104 Bruce 01/17/2012 IT PROG 6000 60 105 David 02/21/2018 IT PROG 4800 60 106 Vali 10/04/2018 IT PROG 4800 60 107 Diana 10/06/2019 IT PROG 4200 60 114 Den 08/05/2015 PU_MAN 11000 30 115 Alexander 01/14/2016 PU CLERK 3100 30 Table Name: Departments Table Name: Locations DEPARTMENT_ID DEPARTMENT_NAME LOCATION_ID LOCATION_ID POSTAL CODE CITY COUNTRY_ID 10 Administration 1700 1400 26192 Southlake US 30 Purchasing 1700 1500 99236 South San Francisco US 50 Shipping 1500 1600 South Brunswick 50090 US 1700 98199 Seattle US 60 IT 1400 1800 M5V 2L7 Toronto CA 90 Executive 1700 1900 YSW 9T2 Whitehorse CA 100 Finance 1700 Write SQL Command to display employee first name , department name for all employees whose job id…
Pls help me to create this ERD into simple oracle sql
sql code sql code sql code
Please use MySQL language and mySQL as server
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.
Write appropriate SQL DDL statements for declaring the database "Employee", assign admin privilege to user "AMAL" Write appropriate SQL DDL statements for declaring the table PERSONS. Specify all constraints: Field Null key PersonID No PRIMARY No LastName varchar(30) FirstName varchar(30) No Address varchar(50) YES City varchar(30) YES Type int
Write down a sql query to find out "Firstname" (s) those have "s" letter in it and havemonthly salary not more than 50000k