I AM HAVING ERROR ON EMPLYOEE TABLE WHILE ADDING FORIEGN KEY, AND THE ERROR IS GIVEN IN NEXT PICTURE ▷ ExecuteXer 1✓ & B ÔLAB2.sql - COMPUT...PUTER\Navne (65))CREATE DATABASE COMPANY;CREATE TABLE EMPLOYEE (FNAME VARCHAR (20) NOT NULL,Minit CHAR(1),LNAME VARCHAR(30) NOT NULL,SSN CHAR (9) NOT NULL UNIQUE,BDATE VARCHAR(25),ADDRESS VARCHAR (50),SEX CHAR(10),SALARY INT,SUPERSSN CHAR(9),DNO INT NOT NULL,0101 01CREATE TABLE DEPARTMENT (DNAME VARCHAR (20) NOT NULL UNIQUE,DNUMBER INT NOT NULL UNIQUE,=SQLQuery1.sql - C...MPUTER\Navne (62))* + XPRIMARY KEY(SSN),FOREIGN KEY (SUPERSSN) REFERENCES EMPLOYEE (SSN),FOREIGN KEY (DNO) REFERENCES DEPARTMENT (DNUMBER));INSERT INTO EMPLOYEE VALUES ('John', 'B', 'Smith', '123456789', '09-Jan-55', '731 Fondren, Houston, TX', 'M', 30000, '987654321', 5);INSERT INTO EMPLOYEE VALUES ('Franklin', 'T', 'Wong', '333445555', '08-Dec-45', '638 Voss, Houston, TX', 'M', 40000, '888665555', 5);INSERT INTO EMPLOYEE VALUES ('Joyce', 'A', 'English', '453453453', '31-Jul-62', '5631 Rice, Houston, TX', 'F', 25000, 333445555', 5);INSERT INTO EMPLOYEE VALUES ('Ramesh', 'K', 'Narayan', '666884444', '15-Sep-52', '975 Fire Oak, Humble, TX', 'M', 38000, '333445555', 5);INSERT INTO EMPLOYEE VALUES ('James', 'E', 'Borg', '888665555', '10-Nov-27', '450 Stone, Houston, TX', 'M', 55000, 'NULL', 1);=INSERT INTO EMPLOYEE VALUES ('Jennifer', 'S', 'Wallace', '987654321', '20-Jun-31', '291 Berry, Bellaire, TX', 'F', 43000, '888665555', 4);INSERT INTO EMPLOYEE VALUES ('Ahmad', 'V', 'Jabbar', '987987987', '29-Mar-59', '980 Dallas, Houston, TX', 'M', 25000, 987654321', 4);INSERT INTO EMPLOYEE VALUES ('Alicia', 'J', 'Zelaya', '999887777', '19-Jul-58', '3321 Castle, Spring, TX', 'F', 25000, '987654321', 4);MGRSSN CHAR (9) NOT NULL,MGRSTARTDATE VARCHAR (20),PRIMARY KEY (DNUMBER),FOREIGN KEY (MGRSSN) REFERENCES EMPLOYEE (SSN));INSERT INTO DEPARTMENT VALUES ('Headquarters', 1, 888665555, 19-Jun-71');INSERT INTO DEPARTMENT VALUES ('Administration', 4, 987654321, 01-Jan-85');INSERT INTO DEPARTMENT VALUES ('Research', 5, 333445555, ¹22-May-78');INSERT INTO DEPARTMENT VALUES ('Automation', 7, 123456789, '06-Oct-05');CREATE TABLE DEPENDENT (ESSN CHAR (9) NOT NULL,DEPENDENT_NAME VARCHAR(20) NOT NULL UNIQUE, SEX CHAR(10), BDATE VARCHAR(50),RELATIONSHIP CHAR (20) NOT NULL, PRIMARY KEY (ESSN, DEPENDENT_NAME), FOREIGN KEY (ESSN) REFERENCES EMPLOYEE (SSN)); xecuteMDX UMI IMLA DAXSQLQuery1.sql-C...MPUTER\Navne (62))CREATE DATABASE COMPANY;ECREATE TABLE EMPLOYEE (FNAME VARCHAR(20) NOT NULL,Minit CHAR(1),HLNAME VARCHAR(30) NOT NULL,SSN CHAR (9) NOT NULL UNIQUE,BDATE VARCHAR(25),ADDRESS VARCHAR(50),SEX CHAR(10),SALARY INT,SUPERSSN CHAR(9),DNO INT NOT NULL,PRIMARY KEY (SSN),FOREIGN KEY (SUPERSSN) REFERENCES EMPLOYEE (SSN),FOREIGN KEY (DNO) REFERENCES DEPARTMENT (DNUMBER));INSERT INTO EMPLOYEE VALUES (JohnINSERT INTO EMPLOYEE VALUES (Frank Foreign key 'FK_EMPLOYEE_06d4e02d925162174559'INSERT INTO EMPLOYEE VALUES(JoyceCREATE TABLE DEPARTMENT (DNAME VARCHAR (20) NOT NULL UNIQUE,DNUMBER INT NOT NULL UNIQUE,MGRSSN CHAR (9) NOT NULL,MGRSTARTDATE VARCHAR (20),references invalid table 'DEPARTMENT.INSERT INTO EMPLOYEE VALUES ('Ramesh', 'K', 'Narayan', '666884444, 15-Sep-52', '975 Fire Oak, Humble, TX', 'M', 38800, 333445555", 5);INSERT INTO EMPLOYEE VALUES(James, 'E', 'Borg', '888665555, 10-Nov-27, 450 Stone, Houston, TX', 'M', 55000, "NULL", 1);INSERT INTO EMPLOYEE VALUES (Jennifer', '5', 'Wallace', 987654321, 20-Jun-31, 291 Berry, Bellaire, TX", "F, 43000, 888665555", 4);INSERT INTO EMPLOYEE VALUES("Ahmad', 'V', *Jabbar', '987987987, 29-Mar-59, 980 Dallas, Houston, TX', 'M', 25000, 987654321", 4);INSERT INTO EMPLOYEE VALUES ('Alicia', '3', 'Zelaya', '999887777", 19-Jul-58', '3321 Castle, Spring, TX', 'F', 25000, '987654321', 4);76%XPRIMARY KEY (DNUMBER),FOREIGN KEY (MGRSSN) REFERENCES EMPLOYEE (SSN));BINSERT INTO DEPARTMENT VALUES ('Headquarters', 1, 888665555, 19-Jun-71');4, 987654321, 01-Jan-85');INSERT INTO DEPARTMENT VALUES(Administration.INSERT INTO DEPARTMENT VALUES ('Research, 5, 333445555, 22-May-78*);INSERT INTO DEPARTMENT VALUES ('Automation, 7, 123456789, 06-Oct-05');Connected. (1/1)HECREATE TABLE DEPENDENT (ESSN CHAR(9) NOT NULL,DEPENDENT_NAME VARCHAR(20) NOT NULL UNIQUE, SEX CHAR(10),BDATE VARCHAR(50),RELATIONSHIP CHAR(20) NOT NULL, PRIMARY KEY (ESSN, DEPENDENT NAME), FOREIGN KEY (ESSN) REFERENCES EMPLOYEE (SSN));Q SearchTLn 1Col 1HCh 1DELLOTCOMPUTER\SQLSERVER2022 (16.... COMPUTER NavneXINS(6)E

Given :- In the above given question, table schema along with Structure query language is mention…

Answered: FORIEGN KEY

Engineering

Computer Science

FORIEGN KEY

A Guide to SQL

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter7: Database Administration

Section: Chapter Questions

Problem 10RQ

See similar textbooks

Similar questions

from structured query language course
In Sql These are some database from a set of tables insert into AccountHolder(AccountID, CustomerID, AccountType)values (55003, 115, 'Savings'),(44001, 101, 'Chequing'),(55006, 109, 'Savings'),(44002, 102, 'Chequing'),(44003, 113, 'Chequing'),(55007, 108, 'Savings'),(44004, 103, 'Chequing'),(44005, 110, 'Chequing'),(55005, 112, 'Savings'),(44006, 114, 'Chequing'),(55001, 111, 'Savings'),(44007, 107, 'Chequing'),(44008, 104, 'Chequing'),(55004, 106, 'Savings'),(44009, 105, 'Chequing'),(44010, 113, 'Chequing'),(55002, 107, 'Savings'),(44011, 110, 'Chequing'),(44012, 104, 'Chequing') select * from AccountHolder insert into Branch(LocationID, BranchName, Address, Type, DepositSum, LoanSum)values (1, 'Boulevard Branch', '3268 Wade Boulevard', 'Rural', 171848.88, 37681.72),(2, 'Avenue Branch', '4814 Dare Avenue', 'Rural', 232707.42, 68324.56),(3, 'Street Branch', '208 Ferry Street', 'Commercial', 375010.75, 44665.08),(4, 'Road Branch', '468 Zulauf Road', 'Commercial', 496001.41,…
q4- Choose all that apply
q10- Options to fill in the blank to choose from are - 0,1,2
in database using oracle.xe how to write SQL queries
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
SQL
Assume you have StudentsDB database stored in MYSQL server that contains the following 2 tables as follows: Table 1: Students Table 2: Grades int, Primary Key, Auto Increment Sid Gid int, Primary Key, Auto Increment UniversityID varchar(8), Unique Sid int, Foreign Key Name varchar(50) CourseCode varchar(10) Мajor varchar(50) Credits int CourseGrade varchar(4) *** Note: Students must use PDO to access MYSQL DB, MYSQLI isn't allowed *** Implement the following PHP scripts as required below: 1. displayStudentGrades.php: the script should display student's name and major. In addition, all courses codes with their grades should be displayed in HTML table followed by its Cumulative GPA, Total Credits Passed and Total Credits Registered at the bottom of the TABLE. Highlight the course row by red if it's F grade. The studentlD is received using HTTP GET method from an HTML form. 2. addnewStudentwithgrades.php: the script should obtain all the required student details using HTML form including…
WorksOn Database: Employee (EmployeeNumber, EmployeeName, BirthDate, Title, Salary, DepartmentNumber) Project (ProjectNumber, ProjectName, Budget, DepartmentNumber) Department (DepartmentNumber, DepartmentName, ManagerNumber) WorksOn (EmployeeNumber, ProjectNumber, Responsibility, Hours) Questions: 1) Write an SQL query that returns the project number and name for projects with a budget no greater than $1,050,000. 2) Write an SQL query that returns all works on records where hours worked is less than 5 and the responsibility is 'Manager'. 3) Write an SQL query that returns the employees (number and name only) who have a title of 'EE' or 'SA' and make more than $50,000. 4) Write an SQL query that returns the employees (name and salary only) in department 'D1' ordered by decreasing salary. 5) Write an SQL query that returns the departments (all fields) ordered by descending department name.
help me with database sql exercise
Given the following relation: Book (BooklD, Author, ISBN, Title) Write a PL/SQL block of code that performs the following tasks: i. Read a Book id provided by user at run time and store it in a variable. ii. Fetch the Author and title of the book having the entered id and store them inside two variables i. Display the fetched book author and title. T TTF Paragraph Arial 3 (12pt) ABC T T, e HTML CSS O f. Mashups
Assistance with SQL statements Previous code; CREATE TABLE Lab4program_piershed ( code VARCHAR(5) PRIMARY KEY, name VARCHAR(20), tel VARCHAR(20));CREATE TABLE Lab4course_xxxx ( cid INT PRIMARY KEY, name VARCHAR(20), credits INT, mycode VARCHAR(5), FOREIGN KEY (mycode) REFERENCES Lab4program_xxxx(code)); 1. Insert 3 records into your Lab4program_xxxx table. The code should be "CPS", "TECH", "MATH", or "BIO". Please copy/paste your SQL statements with the output message in the text that shows you successfully insert 3 records to your table. 2. Insert 4 records into your Lab4course_xxxx table with at least 2 different mycode. Please copy/paste your SQL statements with the output message in the text that shows you successfully insert 4 records to your table.