1. Create the following two tables with Proper Relationship TABLE NAME CUSTOMER88 FIELD NAME DATA TYPE SIZE CONSTRAINT CUST ID NUMBER PRIMARY KEY CUST NAME VARCHAR2 25 NOT NULL INDICATOR VARCHAR2 20 DATE OF_VISIT DATE CONST FEES NUMBER 9,3 Validate Const Fees accept more than 100 only. GSM NUMBER UNIQUE TABLE NAME SPECIALIST88 FIELD NAME DATA TYPE SIZE CONSTRAINT DOCTOR ID DOCTOR NAME NUMBER PRIMARY KEY VARCHAR2 25 NOT NULL SPECIALIST VARCHAR2 25 GSM NUMBER 8. UNIQUE CUST ID NUMBER FOREIGN KEY

1. Create the following two tables with Proper Relationship TABLE NAME CUSTOMER88 FIELD NAME DATA TYPE SIZE CONSTRAINT CUST ID NUMBER PRIMARY KEY CUST NAME VARCHAR2 25 NOT NULL INDICATOR VARCHAR2 20 DATE OF_VISIT DATE CONST FEES NUMBER 9,3 Validate Const Fees accept more than 100 only. GSM NUMBER UNIQUE TABLE NAME SPECIALIST88 FIELD NAME DATA TYPE SIZE CONSTRAINT DOCTOR ID DOCTOR NAME NUMBER PRIMARY KEY VARCHAR2 25 NOT NULL SPECIALIST VARCHAR2 25 GSM NUMBER 8. UNIQUE CUST ID NUMBER FOREIGN KEY

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter4: Constraints

Section: Chapter Questions

Problem 13MC: Which of the following commands can be used to enable a disabled constraint? a. ALTER TABLE MODIFY...

See similar textbooks