In: Computer Science
Please convert this to work in Oracle SQL:
CREATE TABLE GUEST
(
SSN number(10),
name varchar2(20),
DOB date,
roomnumber number(10)
);
INSERT INTO guest VALUES (1,'Lucy','2019-1-8',301);
INSERT INTO guest VALUES (2,'John','2019-11-18',302);
INSERT INTO guest VALUES (3,'Smith','2019-2-6',303);
INSERT INTO guest VALUES (4,'Tom','2019-2-7',304);
INSERT INTO guest VALUES (5,'Harry','2019-10-9',305);
)
CREATE TABLE INVENTORY
(
itemnumber number(10),
itemneeded number(10),
iteminstock number(10),
dateofpurchase date
);
INSERT INTO INVENTORY VALUES (21,10,60,'2019-1-8');
INSERT INTO INVENTORY VALUES (22,20,70,'2019-1-11');
INSERT INTO INVENTORY VALUES (23,30,75,'2019-2-4');
INSERT INTO INVENTORY VALUES (24,20,55,'2019-3-7');
INSERT INTO INVENTORY VALUES (25,40,65,'2019-5-6');
)
CREATE TABLE VOLUNTEER
(
ssn number(10),
name varchar2(20),
dob date,
skills varchar2(20)
);
INSERT INTO VOLUNTEER VALUES
(31,'Tim','2019-2-7','Beginner');
INSERT INTO VOLUNTEER VALUES
(32,'Lucy','2019-3-11','Advanced');
INSERT INTO VOLUNTEER VALUES
(33,'Jack','2019-1-2','Beginner');
INSERT INTO VOLUNTEER VALUES
(34,'Alice','2019-4-18','Advanced');
INSERT INTO VOLUNTEER VALUES (35,'Bob','2019-3-6','Beginner');
CREATE TABLE SCHEDULE
(
volunteername varchar2(20),
volunteerdaysofwork number(10),
volunteerhours number(10),
guestname varchar2(20),
gueststaydate date
);
INSERT INTO SCHEDULE VALUES
('John',10,5,'Alex','2019-11-5');
INSERT INTO SCHEDULE VALUES
('Lucy',15,4,'Carolin','2019-11-6');
INSERT INTO SCHEDULE VALUES
('Alice',20,3,'Lisa','2019-11-7');
INSERT INTO SCHEDULE VALUES
('Bob',30,4,'Hayden','2019-11-7');
INSERT INTO SCHEDULE VALUES ('TIm',5,2,'Mathew','2019-11-9');
)
CREATE TABLE DONOR
(
donationnumber number(10),
donationamount number(10),
donationdate date,
donorsname varchar2(20)
);
INSERT INTO DONOR VALUES (41,500,'2019-10-3','Alex');
INSERT INTO DONOR VALUES (42,2500,'2019-9-15','Alex');
INSERT INTO DONOR VALUES (43,5200,'2019-7-25','Alex');
INSERT INTO DONOR VALUES (44,700,'2019-11-5','Alex');
INSERT INTO DONOR VALUES (45,2300,'2019-10-6','Alex');
)
Note: I have created above tables in Oracle and inserted the rows into table using SQL queries. The execution screenshots are as follows: