Write the SQL code that will create only the table structure for a table named EMP_1. This table will be a subset of the EMPLOYEE table. The basic EMP_1 table structure is summarized in the following table. Use EMP_NUM as the primary key. Note that the JOB_CODE is the FK to JOB so be certain to enforce referential integrity. Your code should also prevent null entries in EMP_LNAME and EMP_FNAME.

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
icon
Concept explainers
Question

Write the SQL code that will create only the table structure for a table named EMP_1. This table will be a subset of the EMPLOYEE table. The basic EMP_1 table structure is summarized in the following table. Use EMP_NUM as the primary key. Note that the JOB_CODE is the FK to JOB so be certain to enforce referential integrity. Your code should also prevent null entries in EMP_LNAME and EMP_FNAME.

The table represents a schema for an employee database, detailing various fields and their data types. 

**Table Fields:**

1. **EMP_NUM**
   - Type: `varchar(3)`
   - Description: Employee number, stored as a variable character string with a maximum length of 3 characters.

2. **EMP_LNAME**
   - Type: `varchar(15)`
   - Description: Employee's last name, stored as a variable character string with a maximum length of 15 characters.

3. **EMP_FNAME**
   - Type: `varchar(15)`
   - Description: Employee's first name, stored as a variable character string with a maximum length of 15 characters.

4. **EMP_INITIAL**
   - Type: `varchar(1)`
   - Description: Employee's middle initial, stored as a variable character string with a maximum length of 1 character.

5. **EMP_HIREDATE**
   - Type: `date`
   - Description: The date on which the employee was hired, stored as a date type.

6. **JOB_CODE**
   - Type: `varchar(3)`
   - Description: Code corresponding to the employee's job, stored as a variable character string with a maximum length of 3 characters.
Transcribed Image Text:The table represents a schema for an employee database, detailing various fields and their data types. **Table Fields:** 1. **EMP_NUM** - Type: `varchar(3)` - Description: Employee number, stored as a variable character string with a maximum length of 3 characters. 2. **EMP_LNAME** - Type: `varchar(15)` - Description: Employee's last name, stored as a variable character string with a maximum length of 15 characters. 3. **EMP_FNAME** - Type: `varchar(15)` - Description: Employee's first name, stored as a variable character string with a maximum length of 15 characters. 4. **EMP_INITIAL** - Type: `varchar(1)` - Description: Employee's middle initial, stored as a variable character string with a maximum length of 1 character. 5. **EMP_HIREDATE** - Type: `date` - Description: The date on which the employee was hired, stored as a date type. 6. **JOB_CODE** - Type: `varchar(3)` - Description: Code corresponding to the employee's job, stored as a variable character string with a maximum length of 3 characters.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Query Syntax
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education