Question: Write named CHECK constraints for the following integrity rules. Modify the CREATE TABLE statement to add the named CHECK constraints. CREATE TABLE Customer ( CustNo

Write named CHECK constraints for the following integrity rules. Modify the CREATE TABLE statement to add the named CHECK constraints.

CREATE TABLE Customer ( CustNo CHAR(8), CustFirstName VARCHAR2(20) CONSTRAINT CustFirstNameRequired NOT NULL, CustLastName VARCHAR2(30) CONSTRAINT CustLastNameRequired NOT NULL, CustStreet VARCHAR2(50), CustCity VARCHAR2(30), CustState CHAR(2), CustZip CHAR(10), CustBal DECIMAL(12,2) DEFAULT 0, CONSTRAINT PKCustomer PRIMARY KEY (CustNo) ) Customer balance is greater than or equal to 0. Customer state is one of CO, CA, WA, AZ, UT, NV, ID, or OR.

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!

Assignment for Module 3 The graded problems in Module 3 provide experience with the CREATE TABLE statement. You can use Oracle or MySQL for this assignment. If you use Oracle, you will need to use...

The graded problems in Module 3 provide experience with the CREATE TABLE statement. You should execute the statements using either Oracle, PostgreSQL, or MySQL. To facilitate grading, please number...

Here are the directions I need only the SQL code not the database itself: 1. Basic CREATE TABLE Statement Requirements Use the table descriptions in the Intercollegiate Database background document....

SQL -- Classic Models Database NetBeans: Select the latest version of NetBeans and start it. Open the Services window (available from the window menu in NetBeans) Right-click Java DB and start the...

For this project, you are going to create the Intercollegiate Athletic Database. More specifically you will have to create the tables described in the Background file and populate the tables with the...

-- ************************************************************* -- This script creates the database -- for Labs 4-7 based on OM (Order Management) database -- **REVISED by PRP to remove some orders...

CHAPTER 3 1. Which of the following is a correct statement? a. You can restore the data deleted with the DROP COLUMN clause, but not the data deleted with the SET UNUSED clause. b. You cant create...

SESSION: SUMMER 2017 LAB 1B SQL * Plus - CREATING TABLES and CONSTRAINTS FOLLOW INSTRUCTIONS: DO NOT SKIP A SINGLE STEP SECTION I: NOTE: Do not specify any constraints with the create statement...

Klara is 25 years old and is planning for her retirement. She wants to consider both options of retiring at age 60 or at age 65, and has no savings into her RRSP yet. She figures she would like to...

Q. 1. (15) Some of the energy levels of a hypothetical one electron atom (not hydrogen) are listed in the table below. n 1 2 3 4 5 En (eV) -15.60 -5.30 -3.08 -1.45 -0.80 Draw the energy level diagram...

Multiple Choice Question $1 is compounded semiannually for 10 years at 8% interest. What is the interest rate per period? Multiple choice question. 1% 8% 4% 2%

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

Critically evaluate: In comparing the two equilibrium positions in Figure 3.7b, I note that a smaller amount is actually demanded at a lower price. This refutes the law of demand.

ADVANCED ANALYSIS Assume that demand for a commodity is represented by the equation P 10 .2Qd and supply by the equation P 2 .2Qs, where Qd and Qs are quantity demanded and quantity supplied,...

LAST WORD What is the current overall number of American candidates waiting for an organ transplant? (For the answer, visit the United Network for Organ Sharing Web site, www.unos.org.) For what...