Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Database Management

Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi

12th edition

133544613, 978-0133544619

More Books

Students also viewed these Databases questions