FOLLOW INSTRUCTIONS CAREFULLY Creating TABLES and CONSTRAINTS You receive email

Question

FOLLOW INSTRUCTIONS CAREFULLY

Creating TABLES and CONSTRAINTS

You receive email from the development team to create a table as seen below:

The Request:

Write SQL DDL commands to create the tables below.

TABLE NAME:          PAY_TAB

Column name

Data Type/Bytes

Constraint Name and Type

Null?

EMPID

NUMBER(7)

pk_paytab - PRIMARY KEY

FNAME

VARCHAR2(25)

LNAME

VARCHAR2(25)

PAY_PERIOD

DATE

TABLE NAME:          LAB_DEPT

Column name

Data Type/Bytes

Constraint Name and Type

Null?

DEPTID

NUMBER(7)

pk_labdept - PRIMARY KEY

NAME

VARCHAR2(25)

LOCATION

VARCHAR2(25)

NOT NULL

TABLE NAME:          LAB_EMP

Column name

Data Type/Bytes

Constraint Name and Type

Null?

EMPNO

NUMBER(7)

NOT NULL

LAST_NAME

VARCHAR2(25)

FIRST_NAME

VARCHAR2(25)

DEPTID

NUMBER(7)

fk_labemp - FOREIGN KEY

Referencing table LAB_DEPT

CREATE TABLE fname_lname ( employee_number int NOT NULL, employee_name char(50) NOT NULL, department_id int, salary int, address varchar2(50), CONSTRAINT employees_pk PRIMARY KEY (employee_number), CONSTRAINT fk_departments FOREIGN KEY (department_id) REFERENCES departments(department_id) );

Column name

Data Type/Bytes

Constraint Name and Type

Null?

EMPID

NUMBER(7)

pk_paytab - PRIMARY KEY

FNAME

VARCHAR2(25)

LNAME

VARCHAR2(25)

PAY_PERIOD

DATE

Explanation / Answer

for Table 1

CREATE TABLE PAY_TAB
(
EMPID int ,
FNAME varchar(25),
LNAME varchar(25),
PAY_PERIOD date,
PRIMARY KEY(EMPID)
);

For Table 2

CREATE TABLE LAB_DEPT
(
DEPTID int ,
NAME varchar(25),
LOCATION varchar(25) NOT NULL,
PRIMARY KEY(DEPTID)
);

For Table 3

CREATE TABLE LAB_EMP
(
EMPNO int ,
LAST_NAME varchar(25),
FIRST_NAME varchar(25) NOT NULL,
DEPTID int,
FOREIGN KEY(DEPTID) REFERENCES LAB_DEPT(DEPTID)
);

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

---

---

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