Question: CREATE TABLE INSTRUCTOR ( INS _ ID NUMBER NOT NULL, INS _ FNAME VARCHAR 2 ( 1 0 0 ) NOT NULL, INS _ SNAME

CREATE TABLE INSTRUCTOR( INS_ID NUMBER NOT NULL, INS_FNAME VARCHAR2(100) NOT NULL, INS_SNAME VARCHAR2(100) NOT NULL, INS_CONTACT CHAR(15) NOT NULL, INS_LEVEL NUMBER NOT NULL, CONSTRAINT PK_INSTRUCTOR PRIMARY KEY(INS_ID )); CREATE TABLE CUSTOMER( CUST_ID CHAR(10) NOT NULL, CUST_FNAME VARCHAR2(100) NOT NULL, CUST_SNAME VARCHAR2(100) NOT NULL, CUST_ADDRESS VARCHAR2(50) NOT NULL, CUST_CONTACT CHAR(15) NOT NULL, CONSTRAINT PK_CUSTOMER PRIMARY KEY(CUST_ID)); CREATE TABLE DIVE( DIVE_ID NUMBER NOT NULL, DIVE_NAME VARCHAR2(100) NOT NULL, DIVE_DURATION VARCHAR2(50) NOT NULL, DIVE_LOCATION VARCHAR2(100) NOT NULL, DIVE_EXP_LEVEL NUMBER NOT NULL, DIVE_COST INT NOT NULL, CONSTRAINT PK_DIVE PRIMARY KEY(DIVE_ID)); CREATE TABLE DIVE_EVENT( DIVE_EVENT_ID VARCHAR2(100) NOT NULL, DIVE_DATE DATE NOT NULL, DIVE_PARTICIPANTS NUMBER NOT NULL, INS_ID NUMBER NOT NULL, CUST_ID CHAR(10) NOT NULL, DIVE_ID NUMBER NOT NULL, CONSTRAINT PK_DIVE_EVENT PRIMARY KEY(DIVE_EVENT_ID), CONSTRAINT FK_INSTRUCTOR_DIVE_EVENT FOREIGN KEY(INS_ID) REFERENCES INSTRUCTOR(INS_ID), CONSTRAINT FK_CUSTOMER_DIVE_EVENT FOREIGN KEY(CUST_ID) REFERENCES CUSTOMER(CUST_ID), CONSTRAINT FK_DIVE_DIVE_EVENT FOREIGN KEY(DIVE_ID) REFERENCES DIVE(DIVE_ID)); Question 1 Create GUI for reports Management of IT Gear Dealer requires an external program that will provide a graphical user interface to display the results for the following stored procedures and finctions you have created: 1.sp_customer_details 2. fn_Dive_adjustments At this moment, you are only required to provide a design of the GUI and the code of the GUI to database. You are, however not required to connect the GUI required to connect the GUI to the database. You are allowed to use any programming language and integrated development environment to achieve this functionality.

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!