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

DataBase , please heelp , i have no time ....
DataBase , please heelp , i have no time .... 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

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

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!