create the hospital database using the following design and data in Oracle datab

Question

create the hospital database using the following design and data in Oracle database. Create a script file(.SQL) to create tables and insert data into the table in Oracle. Include all primary and foreign keys. Run your Script and make sure to fix all errors if any.dddd

Explanation / Answer

Dear, >start mysql.sql It opens file for saving use commit command. > CREATE TABLE DOCTOR (ID CHARACTER (5) NOT NULL CONSTRAINT pk_DOCTOR PRIMARYKEY, FNAME VARCHAR2 (10), LNAME VARCHAR2 (10), PHONE VARCHAR2 (10), BEEPER VARCHAR2 (10)); >/ COMMIT TABLE CREATED > CREATE TABLE PATIENT(ID CHARACTER(5) NOT NULL CONSTRAINT pk_PATIENT PRIMARYKEY, Doctors_ID CHARACTER(5) NOT NULL, Fname VARCHAR2(10), Lname VARCHAR2(10), street VARCHAR2(10), city VARCHAR2(10), state CHARACTER2) zip CHARACTER(10), Phone CHARACTER(12)); >/ Commit TABLE CREATED > CREATE TABLE INSURANCE (Company VARCHAR2 (15) NOT NULL CONSTRAINT pk_INSURANCE PRIMARYKEY,Contact_Fname VARCHAR2 (10), Contact_Lname VARCHAR2 (10), Phone VARCHAR2 (10)); >/table created > CREATE TABLE INSURE (Patient_id CHARACTER (5) NOT NULL, Insurance_Company VARCHAR2 (15) NOT NULL); >/table created > Insert values with this command INSERT INTO Doctor(ID , FNAME, LNAME, PHONE, BEEPER) VALUES (‘0001’,‘Derry’,’cox’,’555-1111’,’555-1212’) ; INSERT INTO Doctor(ID , FNAME, LNAME, PHONE, BEEPER) VALUES (‘0002’,Elite’,’reed’,’555-2222’,’555-2323’) ; INSERT INTO Doctor(ID , FNAME, LNAME, PHONE, BEEPER) VALUES (‘0003’,‘FD’,’dorlan’,’555-1111’,’555-1212’) ; Add remaining fields also INSERT INTO Patient(ID, Doctors_ID, Fname, Lname, street, city, state, zip, Phone) VALUES (‘11111’,‘0001’,‘jim’,’perotti’,’12oakst’,’shade’,’OH’,’45701’, ‘555-123’) ; INSERT INTO Patient(ID, Doctors_ID, Fname, Lname, street, city, state, zip, Phone) VALUES (‘22222’,‘0001’,‘Glen’,’staimeri’,’1walnotare’,’ather’,’FL’,’58475’, ‘555-234’) ; INSERT INTO INSURANCE (Company, Contact_Fname, Contact_Lname), Phone ) VALUES (‘Prudential’,’Jan’,‘Johnson’, ‘555-9876’) ; INSERT INTO INSURE (Patient_id, Insurance_Company); VALUES (‘11111’,’Prudential’) ; add all fields above format.

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.