a,b,c show step DUE: September 6, 2018 Write schemas for the following relations

Question

a,b,c show step

DUE: September 6, 2018 Write schemas for the following relations. (10 points each) a) 1. PROD_CODE PROD DESCRIPT PROD PRICE PROD ON HAND VEND_CODE Table Name: PRODUCT 001278-AB Claw hammer Primary Key: PROD CODE Foreign Key: VEND_CODE SRE-657UG Rat tail file 123-21UUY Houselite chain saw, 16-in. bar QER-34256 Sledge hammer, 16-lb. head 189.99 18.63 2.99 6.79 15 ZZX 32450 Steel tape, 12-f1. length b) T'able Name: VENDOR VEND CODOE VEND CONTACT VEND AREACODE VEND PHONE Primary Key: VEND_CODE Foreign Key: None 230 Shelly K. Smithson 608 231 James Johnson 615 232 Annelise Crystall 608 555-1234 123-4536 224-2134 Crente 1001 10014 321452 C 324257 B 321452 A 324257 B 321452 C 324257 C Table Name: CLASS Primary Key: CLASS_CODE + STU NUM 10018 Foreign Key: CLASS CODE, STU NUM 10018 10021 10021

Explanation / Answer

1.

CREATE TABLE PRODUCT (

PRO_CODE VARCHAR(10) UNIQUE NOT NULL,

PROD_DESCRIPT VARCHAR(50),

PROD_PRICE REAL,

PROD_ON_HAND INT,

VEND_CODE INT,

PRIMARY KEY(PROD_CODE),

FOREIGN KEY(VEND_CODE) REFERENCES VENDOR(VEND_CODE)

);

2.

CREATE TABLE VENDOR (

VEND_CODE INT UNIQUE NOT NULL,

VEND_CONTACT VARCHAR(50),

VEND_AREACODE INT,

VEND_PHONE VARCHAR(10),

PRIMARY KEY(VEND_CODE)

);

3)

CREATE TABLE CLASS (

CLASS_CODE VARCHAR(10) UNIQUE NOT NULL,

STU_NUM VARCHAR(10),

ENROLL_GRADE VARCHAR(1),

PRIMARY KEY(CLASS_CODE, STU_NUM),

FOREIGN KEY(CLASS_CODE, STU_NUM) REFERENCES ForeignTable(CLASS_CODE, STU_NUM)

);

NOTE: Please replace the ForeignTable with suitable table name

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

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