Question: In Oracle SQL, I already have an Employee table with Emp_SSN as its primary key, and a Patient table with Pat_SSN as its primary key.

In Oracle SQL, I already have an Employee table with Emp_SSN

as its primary key, and a Patient table with Pat_SSN as its

primary key. I want to create a child table called Patient_Employee to

relate patients to the employees that care for them. I am trying

In Oracle SQL, I already have an Employee table with Emp_SSN as its primary key, and a Patient table with Pat_SSN as its primary key.

I want to create a child table called Patient_Employee to relate patients to the employees that care for them.

I am trying to use the foreign keys, Emp_SSN from the Employee table, and Pat_SSN from the Patient table, as a composite primary key in the new Patient_Employee table. I cant get it to work..

ive attached pics of the tables, and a pic of the errors im getting when trying to compile the new Patient_Employee table.

Can someone please show me the proper syntax to get this to work (specifically using Oracle SQL syntax)?

CREATE TABLE Employee ( Emp_SSI number (9) HOT HULL, Dept Name varchar (25) Emp First Name varchar (15), Emp Last Name varchar (15), Hire Date DATE, Emp Phone nunber (15), Emp Street Address varchar (25) Emp City varchar (15), Emp State varchar (15), Job Title varchar (15), Emp Birth Date DATE, CONSTRAINT Employee_PK PRIMARY KEY (EMP_SS) CONSTRATNT Department FK FOREIGN KEY (Dept Name) REFERENCES Departaent (Dept Hane) INSERT INTO Employee VALUES (111iiil, '24 Hour Euergency', 'Bob, 'Harley, TO DATE (2017-03-03, TTTY//DD', 4049995555, '123 s 'Atlanta 'Georgia', 'Physician', TO DATE ('1983-12-06', 'Ym/DD')): IHSERT DSTO Eaployee VALUES (222222222, 'clinic/Lab', 'Hark', 'Jones', TO_DATE( 2014-12-04, TTEY/M/DD'1, 7709897683, '456 N. Valley Rd. ' Atlanta', 'Georgia', 'Nurse', TO DATE ( '1992-01-13', 'TYYY/II/DD')): IHSERT INTO Eaployee VALUES (333333333, 'Patient Administration', Sara', 'Hazel', TO DATE ( '2018-04-11, 'TTI//DD'), 4045451243, 134 N. Bear 'Hazel' Marietta', 'Georgia', 'Adninistrator', TO DATE ( '1979-06-o1', TTY/MI/DD ')): INSERT INTO Employee vALUES (444444444, 'General Services', 'Dave', Thomas' TO DATE ( 2018-10-22 TT/D, 6783836745, 147 Main 3t. 'YYYY/MM/DD" ) ) ; Adans Georgia, ' Contractor , T0-DATE ( 1990-08-03' , Atlanta , , DATE (2014-05-13, 4-05-13'YTMDD), 4709873491, '4929 Market mmm/DD"), 4709873491, .4929 Harket Sq INSERT INTO Employee VALUES (555555555, 'General ervices', 'John' Decatur, Georgia', 'Sec ral services", John", . TO urity', TO DATE ( 1980-09-27, TTYY/M/DD') SELECT FRO2t Employee

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

DO ORACLE SQL DEVELOPER CLASS SCRIPT Create table tblStudent ( studentID number(5,2) not null primary key, studentName varchar2(50) not null, email varchar2(50) not null ); create table tblModules (...

1. CAN CASHAPP U 5$ TO DO THIS Write the SQL statements for creating the tables for the Employee Projects Database. Save these statements in a script called M05_LastNameFirstName_CreateTables (where...

Oracle SQL question Here is the Oracle Table code CONNECT prop/prop; -- Use an anonymous PL/SQL script to -- drop all tables and sequences in the current schema and -- suppress any error messages...

INSERT INTO It is used to add one or more rows to a table Attribute values should be listed in the same order as the attributes were specified in the CREATE TABLE command INSERT INTO tablename...

Generate a SEQUENCE and u lize DUAL to examine the pseudo - columns CURRVAL and NEXTVAL values. 2 . U lize an SQL command to generate an EMPLOYEE table that includes two columns: ENO, with a NUMERIC...

The following relational schema (primary keys are underlined) are used by the security company, West Park, described in Assignment 1, with some minor modifications. Stores(sid, name, address, phone)...

Write an SQL statement to list ItemID and ItemDescription for all items that cost $1000 or more. Write an SQL statement to list ItemNumber and Description for all items that cost $1000 or more and...

SHIPMENT_LINE SHIP_ID INV_ID SL_QUANTITY SL_DATE_RECEIVED Number Number Number Date/ Time 25 09/10/2006 2 25 09/10/2006 2 25 5 200 6 200 7 200 12 100 08/15/2006 13 100 08/25/2006 23 50 08/15/2006 24...

Can someone please help me? i dont underdtand this assignment... dentist office tables 1 ... 2 L CIST 1220: SQL - Assign #8 (40 Points) [INSERTS/DELETEs/UPDATEs. - Chap 8] For this assignment, use...

What is relational database normalization? Why is a database schema in third normal form considered to be of higher quality than a UN normalized database schema?

All of the followings are possible causes u: pyuria except: a. Renal lithiases b. Pregnancy c. Urinary tract infection d. Hemolysis

Ater your first year investing in that hedge fund, you have $ 1 . 0 5 8 million remaining. $$ 1 . 1 m - $ 4 2 , 0 0 0 = $ 1 . 0 5 8 m . Next year the irvestments do poorly and your investment falls...

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

3. Contract a horse groomer on an hourly basis to care only for the citys horses. This person would require an hourly rate but would not receive city benefits. The availability of the horse groomer...

3. What constructive coping skills do you want to develop or enhance? Do you want to, for example, start exercising more, learn meditation, manage your time better, develop a new hobby or activity,...

1. Hire a full-time horse groomer to care for the horses. This person would be fully trained to meet the grooming needs of the horses and also would be able to identify health needs when they arose....