MINDTAP From Cengage Problems 8.1-8.15 (MysQL) Problems 8.1-8.4 Problem 1 Write

Question

MINDTAP From Cengage Problems 8.1-8.15 (MysQL) Problems 8.1-8.4 Problem 1 Write the sQL code that will create only the table structure for a table named ExNP1 . This table will be a subset of the ENPLOVEE table. The basic ENP.: table structure is summarized in the following table. Use ENP_NUH as the primary key. Note hat the 008_CODE is the FK to JoB so be certain to enforce referential integrity. Your code should also prevent null entries in EMP. LINAME and EMP FNAME varchart15) Complete Problem 1 above

Explanation / Answer

CREATE TABLE EMP_1(
EMP_NUM varchar(3) PRIMARY KEY,
EMP_LNAME varchar(15) not null,
EMP_FNAME varchar(15) not null,
EMP_INITIAL varchar(1),
EMP_HIREDATE date,
JOB_CODE varchar(3),
CONSTRAINT FK FOREIGN KEY (JOB_CODE) REFERENCES JOB(JOB_CODE)
);

Related Questions

Navigate

• Browse (All)
• Browse M
• Subjects

---

---

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