Need a help!! Using MS ACCESS Please create tables using SQL DDL statements for

Question

Need a help!!

Using MS ACCESS

Please create tables using SQL DDL statements for the following schema:

RETAIL_ORDER (OrderNumber, StoreNumber, StoreZip, OrderMonth, OrderYear, OrderTotal)

ORDER_ITEM (OrderNumber, SKU, Quantity, Price, ExtendedPrice)

SKU_DATA (SKU, SKU_Description, Department, Buyer)

Primary Key is underlined. Foreign Key is italicized.

There is no requirement to populate the schema with data.

Constraints are required for PK and FK. Show data types of attributes, constraints and referential integrity.

Explanation / Answer

Answer:

CREATE TABLE ORDER_ITEM(OrderNumber NUMBER(20), SKU NUMBER(20), Quantity NUMBER(20), Price NUMBER(20,2), ExtendedPrice NUMBER(20,2));

CREATE TABLE SKU_DATA  (SKU NUMBER(20), SKU_Description VARCHAR2(100), Department VARCHAR2(50), Buyer VARCHAR2(50));

CREATE TABLE

RETAIL_ORDER (OrderNumber NUMBER(20), StoreNumber NUMBER(20), StoreZip VARCHAR2(20), OrderMonth NUMBER(2), OrderYear NUMBER(4), OrderTotal NUMBER(20));

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

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