Create tables (Customer, Invoice, Line, Product and Vendor) of slide 12 (Lecture
ID: 3904531 • Letter: C
Question
Create tables (Customer, Invoice, Line, Product and Vendor) of slide 12 (Lecture notes # 5) in Oracle APEX. Provide screen shots for your queries and outputs. You can use the function below to define a constraint that checks if. V STATE is in alphabetic format. CONSTRAINT check-state CHECK (regexpulike (V-STATE"TLalpha1+S')). USE THE TABLE IN THE PICTURE USING Oracle
ont Create tables (Customer, Invoice, Line, Product and Vendor) of slide 12 (Lecture notes # 5) in Oracle APEX. Provide screen shots for your queries and outputs. You can use the function below to define a constraint that checks if V STATE is in alphabetic format. CONSTRAINT check-state CHECK (regexpulike (V-STATE"TLalpha1+S'))Explanation / Answer
If you have any doubts, please give me comment...
CREATE TABLE CUSTOMER(
CUS_NUM INTEGER NOT NULL PRIMARY KEY,
CUS_LNAME VARCHAR(50),
CUS_FNAME VARCHAR(50),
CUS_INITIAL VARCHAR(5),
CUS_AREACODE VARCHAR(15),
CUS_PHONE VARCHAR(15),
CUS_BALANCE REAL(10,2)
);
CREATE TABLE INVOICE(
INV_NUMBER INTEGER NOT NULL PRIMARY KEY,
CUS_NUM INTEGER,
INV_DATE DATE,
FOREIGN KEY(CUS_NUM) REFERENCES CUSTOMER(CUS_NUM)
);
CREATE TABLE VENDOR(
V_CODE VARCHAR(10) NOT NULL PRIMARY KEY,
V_NAME VARCHAR(100),
V_CONTACT VARCHAR(15),
V_AREACODE VARCHAR(15),
V_STATE VARCHAR(50),
V_ORDER VARCHAR(100)
);
CREATE TABLE PRODUCT(
P_CODE VARCHAR(10) NOT NULL PRIMARY KEY,
P_DESCRIPT VARCHAR(255),
P_INVDATE DATE,
P_ONHAND VARCHAR(50),
P_MIN INTEGER,
P_PRICE REAL(10,2),
P_DISCOUNT REAL(5,2),
V_CODE VARCHAR(10),
FOREIGN KEY(V_CODE) REFERENCES VENDOR(V_CODE)
);
CREATE TABLE LINE(
INV_NUMBER INTEGER,
LINE_NUMBER INTEGER,
P_CODE VARCHAR(10),
LINE_UNITS INTEGER,
LINE_PRICE REAL(10,2),
PRIMARY KEY(INV_NUMBER, LINE_NUMBER),
FOREIGN KEY(INV_NUMBER) REFERENCES INVOICE(INV_NUMBER)
);
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.