Question: DataBase , please heelp , i have no time .... QUESTION 1 7 points Q6: Write down a SQL query to create the given relations


QUESTION 1 7 points Q6: Write down a SQL query to create the given relations with the following specifications. CUSTOMER INVOICE Y CUS_CODE IN NUMBER CUS_LMAME CUS_CODE CUS, FLAME BW.DATE CUS, DETAL CUS AREACODE CUS, PHONE Apply the Primary key constraint on CUS_CODE in Customer table. Apply the Primary key constraint on INV_NUMBER in INVOICE table. Apply the NOT NULL constraint on CUS FNAME Apply the Foreign key constraint on CUS CODE in INVOICE table. Apply the CHECK constraint on CUS_AREACODE that CUS_AREACODE could not be equal to 0. For the Al 10 AT10 Mar relations with the following specifications. 00 CUSTOMER * CUS_CODE CUS_LNAME CUS_FNAME CUS_INITIAL CUS_AREACODE CUS_PHONE INVOICE Y INV_NUMBER CUS_CODE INV_DATE CODE in Customer table. NUMBER in INVOICE table. . . Apply the Primary Key constraint on CUS CODE in Customer table. Apply the Primary Key constraint on INV_NUMBER in INVOICE table. Apply the NOT NULL constraint on CUS FNAME. Apply the Foreign key constraint on CUS CODE in INVOICE table. Apply the CHECK constraint on CUS_AREACODE that CUS_AREACODE could not be equal to 0
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
