ssn text; 11 characters only required; user will enter dashes; must be unique Cr

Question

ssn text; 11 characters only required; user will enter dashes; must be unique Creat sgl table IN oracle, table Columns DATA TYPE Constraint customer ustomer ID primary key Last name required First name salesperson Sales person ID rimary key required Last name: First name text; 11 characters only required; user will (Ctr) nter dashes: must be unique Hire date date required car Vinit primary key text, variable length to model text; up to 40 char Vehicle year integer number text, variable length to 20 characters price number with decimals required must be "Y" or N"; text; 1 character default to N sale discount decimal number, 0 to 1 default to 0 Sale ID integer number primary key sale Customer ID integer number required; foreign key to customer table: do not cascade

Explanation / Answer

Create table customer(

Customer_ID NUMBER PRIMARY KEY,

Last_name VARCHAR2(25) NOT NULL,

First_name VARCHAR2(25)

)

Create table salesperson(

Sales_person_ID NUMBER PRIMARY KEY,

Last_name VARCHAR2(25) NOT NULL,

First_name VARCHAR2(25),

ssn VARCHAR2(11) ENCRYPT NOT NULL,

Hiredate DATE NOT NULL,

CONSTRAINT ssn_unique UNIQUE(ssn)

);

Create table car(

Vin# NUMBER PRIMARY KEY,

make VARCHAR2(70),

model VARCHAR2(40),

Vehicle_year NUMBER,

color VARCHAR2(20),

price NUMBER(7,2) NOT NULL,

sold CHAR(1) DEFAULT 'N',

sale_discount NUMBER(3,2) DEFAULT 0,

CONSTRAINT check_sold CHECK(sold = 'Y' OR sold = 'N'),

CONSTRAINT check_sale_discount CHECK(sale_discount between 0 and 1)

);

Create table sale

(

Sale_ID NUMBER PRIMARY KEY,

Customer_ID NUMBER NOT NULL,

CONSTRAINT sale_customer_fkey REFERENCES customer(Customer_ID)

);

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.