I need help creating a table using ORACLE please. Here are the instructions for

Question

I need help creating a table using ORACLE please. Here are the instructions for creating this table:

Create the PRICE table as per the specification qualified below with one qualification. You need to name the CHECK constraint YN_PRICE. If anyone can help create this table I would appreciate it.

able Name: PRICE Constraint Physical Size Data Column Name Type Reference Table Reference Column Type PRIMARY KEY FOREIGN KEY ITEM NOT NULL FOREIGN KEY COMMON_LOOKUP NOT NULL CHECK( Y','N') NOT NULL PRICE_ID Integer Maximum ITEM ID ITEM ID Integer Maximum PRICE TYPE COMMON_LOOKUP ID Integer Maximum ACTIVE FLAG Text START_DATE END_DATE AMOUNT CREATED_BY Date Date Integer Integer Date Date Maximum Maximum NOT NULL FOREIGN KEY NOT NULL NOT NULL FOREIGN KEY NOT NULL NOT NULL SYSTEM_USER SYSTEM_USER_ID CREATION_DATE Date Date LAST_UPDATED_BY SYSTEM_USER SYSTEM_USER_ID Integer Maximum LAST_UPDATE_DATE Date Date

Explanation / Answer

CREATE TABLE PRICE(
Price_ID Integer PRIMARY KEY,
Item_ID Integer NOT NULL FOREIGN KEY REFERENCES Item(Item_ID),
Item_ID Integer NOT NULL FOREIGN KEY REFERENCES Common_Lookup(Common_Lookup_ID),
Active_Flag char(1) NOT NULL CHECK (Active_Flag in ('Y','N')),
Start_Date date NOT NULL,
End_Date date NOT NULL,
Amount Integer NOT NULL,
Created_By Integer NOT NULL FOREIGN KEY REFERENCES System_User(System_User_ID),
Creation_Date date NOT NULL,
Last_Updated_By Integer NOT NULL FOREIGN KEY REFERENCES System_User(System_User_ID),
Last_Update_Date date
);

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

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